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 - 2009-11-02 : 07:22:04
|
| sql is using a high usage of the cpu if i do sp_who2 to see what's running i see for example AWAITING COMMAND 5521331 as cpu usage what does this mean - with status of sleeping? |
|
|
srivatsahg
Yak Posting Veteran
71 Posts |
Posted - 2009-11-02 : 09:46:51
|
| Hi I had the same problem with SQL couple of weeks back.I restarted the sql services, and after that everything started to work normal with optimum usage of CPU. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-02 : 11:15:48
|
| high cpu is usually long running queries with table scans...look at the active processes, and see what they are doing.examine those queries, look for missing indexes |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2009-11-02 : 11:18:01
|
| How can I see which queries it is? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-02 : 12:59:37
|
| DBCC INPUTBUFFER (spid)or can run a profiler trace |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2009-11-03 : 02:02:15
|
| thanks but how does this work 62 sleeping CCPDCMS . pdpay AWAITING COMMAND 85178 657 11/02 18:24:38 Microsoft SQL Server Management Studio - Query 62 0 so what does this mean it's just doing a simple select - if using this much cpu (85178) is something wrong? and what does it mean by sleeping? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-03 : 10:42:54
|
| sleeping means it isn't doing anything now, but is still connected. that's not necessarily a lot of cpu.select queries that perform scans on large tables can peg your cpu to 100%if your cpu utilization is high and you can't find the offending queries, run a trace and filter on cpu. and/or reads |
|
|
|
|
|
|
sql usage of cpu