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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2006-02-20 : 11:04:26
|
| hello friends ..i m just scared with cpu utilization..it is near @ 80 to 95 %..when i check for select * from master..sysprocesseswhere status = 'runnable'order by cpu desci got one spid that really killing my cpu..it is near @ cpu column 3055221...i then go for...dbcc inpubuffer (spid)..i got this reasulteventifo column...sp_execute;1???????????????????????..what that mean exactly i m not clear..pls help me out..T.I.APapillon |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-21 : 15:45:46
|
| CPU column in sysprocesses is a cumulative amount. This does not mean that it is the one killing your CPU. Run Performance Monitor to determine what process is using the most CPU. If it is the sqlservr.exe process, then you'll need to run SQL Profiler to determine what the problem is. I like to trace my data to a table. Then:SELECT TOP 100 Duration, TextDataFROM TraceTableNameWHERE TextData IS NOT NULLORDER BY Duration DESCThat query will give you a good idea of what queries are taking the longest.Tara Kizeraka tduggan |
 |
|
|
|
|
|
CPU really killing me!!!!!!!!!