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 |
|
uberman
Posting Yak Master
159 Posts |
 Posted - 2005-07-11 : 11:20:58
|
One of my servers is missbehaving!W2K advanced serverSP 4SQL Server 2000 SP3aOccassionally it runs like a dog and I get periodic timeouts from my ASP applications (IIS is running on a separate box), which I am looking into...BUT... what worries me is that I when I use "Task Manager" to have a look at what my server is up to I get different results in the "Performance" and "Processes" tabsIn the Performance tab the graph is reporting that the CPU is running at a constant 70-80% (peaking to 100% when it hits my slow T-SQL code :-(If I look in the Processes tab to see what is taking all the CPU time (to make sure it is sql and not some rogue process) the Process lists reports that the CPU is basically 80 - 99% idle.Sql server occassionally pops into the list.In summary : performance graph says CPU is constantatly loadedprocess tab says CPU is basically idle Which one is lying to me and how/why?Any suggestions would be appreciated as I find this a little worrying!(I have tried a quick "tlist" but cant see anything reported in that task list that isnt in the Task Mananger list)Help! |
|
|
|
|
|
Worrying Task Manager Oddity