October 15, 2008 at 12:23 pm
We use LINQ2sql and start to have performance issues.
I would like to know exactly what SQL queries are received by SQL server during an amount of time.
SQL Server Profiler seems to be the right tool... but I can't make it work.
It works only when I do queries in Sql manager.
Can somebody help me ?
(Yes I am a newbie)
October 15, 2008 at 12:36 pm
What events are you collecting using Profiler? Linq queries come across on the SQL:BatchStarting and SQL:BatchCompleted events.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 15, 2008 at 12:45 pm
joselefou (10/15/2008)
We use LINQ2sql and start to have performance issues.I would like to know exactly what SQL queries are received by SQL server during an amount of time.
SQL Server Profiler seems to be the right tool... but I can't make it work.
It works only when I do queries in Sql manager.
Can somebody help me ?
(Yes I am a newbie)
There could be many things that went wrong. You could use the wrong events, or use the wrong filter or connect to the wrong server. Without more details such as which events you are using and what filters you defined we can only guess. Also when you say that it doesn’t work do you mean that you get an error message or that you don’t see anything that the profiler catches?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 15, 2008 at 12:59 pm
OK, thanks a lot. I just did not use the RPC filters.
It works...
October 15, 2008 at 1:01 pm
You can check out http://www.jumpstarttv.com as there is a series of short vidoes on how to use Profiler. Just a disclaimer, I did the videos. They are based on a presentation I did on Profiler at my local users group.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply