SQL Server 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)

SQL Server CPU Usage

Author

Topic

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2011-05-12 : 06:48:18

If the CPU usage on a server is 20 - 25% then is that considered high? Could it cause performance issues?

How can I check how much CPU SQL Server is using?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-05-12 : 07:05:18

You can monitor CPU usage with Performance Monitor, and limit it to the SQL Server process. If that's all you want, an easier way is to use on of Glenn Berry's diagnostic queries:

http://sqlserverperformance.wordpress.com/2010/05/02/recap-of-april-2010-dmv-a-day-series/

Particularly this one: http://sqlserverperformance.wordpress.com/2010/04/20/a-dmv-a-day-%E2%80%93-day-21/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources