June 14, 2011 at 9:04 am
Can anybody explain what is the purpose of SQL profiler?
June 14, 2011 at 10:27 am
Profiler is for viewing the results of and defining server side traces. You can also run it directly against a database to capture data, but I don't recommend it.
It's primary purpose is to capture events. Events cover a lot of ground, but most people use it to monitor query execution. You can see individual procedures or even statements within them (although that's an expensive set of events). These can be captured and output to a file where you can then clean aggregate the data into tables in order to run reports against it to see which queries are the longest running, most frequently called, etc.
For an excellent overview of the topic, I'd pick up Brad McGehee's book.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 14, 2011 at 10:31 am
Thank you Grant
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply