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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2011-11-18 : 04:42:20
|
| I am trying to figure out what makes my cpu peak to 100%the issue is when I analyze the trace the things using the most cpu show a textdata of null -- so how can I know what is causing the issue? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2011-11-18 : 13:17:35
|
| Ignore those. I always add WHERE TextData IS NOT NULL to my query when analyzing a trace.So now what's at the top for CPU?Here's where I start:select top 1000 Duration/1000.0 as DurationMs, TextDatafrom TraceFilewhere TextData is not nullorder by Duration descselect top 1000 Reads, TextDatafrom TraceFilewhere TextData is not nullorder by Reads descselect top 1000 CPU, TextDatafrom TraceFilewhere TextData is not nullorder by CPU descTara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2011-11-19 : 10:38:45
|
| Have you run the missing indexes report yet? Any with an extremely high Impact value?can you give me a link to more on info on how I can scan for this? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
help with analyzing traces