cpu usage - SQL Server Forums

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.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

cpu usage

Author

Topic

helpme
Posting Yak Master

141 Posts

Posted - 2010-03-10 : 18:21:21

We have a new server running sql 2008, SP1 (WindowsServer2008 R2). When the instance is running, the cpu usage bounces from 1-4 percent to 85-90 percent. This is a new instance, no one is running any queries on it and there aren't any jobs running on it. If the instance is stopped, the cpu usage drops to and stays around 0-1 percent. Why would just having the instance started cause these spikes?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-11 : 00:29:02

I'm not aware of anything that would cause this, so I would suggest running SQL Profiler to see what is going when those spikes happen. This would be helpful in your troubleshooting: http://www.sqlteam.com/article/integrating-profiler-and-perfmon-log-files

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

helpme
Posting Yak Master

141 Posts

Posted - 2010-03-12 : 11:47:20

Thanks Tara

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-03-12 : 12:38:04

if it's system idle process you can ignore it by the way

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources