Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chetan.bhattad
Starting Member
3 Posts |
 Posted - 2009-02-24 : 08:18:28
|
| Hello Everyone,I am new with SQL profiler.I want to know, once we run the trace which are the most important columns in the trace. Means what to analyse in trace..What developer or administrator exactly analyse in trace..Thanks in advanceChetan |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-24 : 08:48:44
|
| I look for Textdata,Duration,CPU usage and who ran it and.......You can use events,columns and filters to analyze your slow running queries,locking issues and etc.check books online for details. |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-02-24 : 09:28:58
|
| That largely depends on what you're running profiler for. Are you having a performance issue or just monitoring to see what your system is doing?Mike"oh, that monkey is going to pay" |
|
|
|
chetan.bhattad
Starting Member
3 Posts |
Posted - 2009-02-24 : 09:53:36
|
| Thanks for reply..performance isssue..Like1.For worst performing queries.. Which are the important columns to analyse2.Worst performing store procedures..3.Queries taking more cpu usage..4.Deadlock events |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-02-24 : 09:55:19
|
| sodeep's post then will help you with the first 3. Check out deadlock graphs (2005 and above) for your deadlock issues. They're extremely helpful.Mike"oh, that monkey is going to pay" |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-24 : 09:56:46
|
quote:
Originally posted by chetan.bhattad
Thanks for reply..performance isssue..Like1.For worst performing queries.. Which are the important columns to analyse2.Worst performing store procedures..3.Queries taking more cpu usage..4.Deadlock events
You don't need to run SQL profiler if you are looking for 10 worst performing queries.Look at STANDARD REPORTS |
|
|
|
|
|
|
SQL Profiler