x

SQL 2012 CPU Utilization at Rest

We have observed from task manager that SQL 2012 instances that we have recently installed consume 5% CPU even when no user sessions or SQL Agent jobs are running. These are 40 core servers. This seems abnormally high for an instance servicing no user requests. We do not see this with previous versions of SQL. Ideas?

more ▼

asked May 14, 2013 at 03:03 PM in Default

avatar image

Lookin4Answers
0 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

You don't have any monitoring running or any other processes hitting SQL Server? How about the operating system. Anything running there? Do you know that the 5% CPU utilization is due to the SQL Server engine?

more ▼

answered May 14, 2013 at 04:59 PM

avatar image

Grant Fritchey ♦♦
137k 20 44 81

Thanks for the reply. Yes, it is due to the engine. You can verify this through task manager or Perfmon. The sqlservr.exe for the 2012 instances are the consumers of a minimum of 5% CPU regardless of session activity. None of our monitoring tools had been deployed to the instances. They were newly installed instances at the time this was observed. I am hesitant to upgrade/install too many 2012 instances on the servers now until I have a definitive reason for or understanding that this is a known expected behavior, so that I can adjust accordingly. We have a combination of 2005, 2008, 2008R2 and now 2012 instances running on any given server host. If we can expect to see 5% CPU utilization always we will definitely not be able to safely host as many instances on these large servers as we have done prior to introducting 2012 to our environment.

May 14, 2013 at 05:18 PM Lookin4Answers

It's not normal to see 5% CPU with nothing running on any of the 2012 instances I've managed. Granted, I don't have 2012 with 2005, 2008 & 2008R2 all at the same time. Maybe the behavior changes then.

May 18, 2013 at 10:24 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x388
x32
x4
x2

asked: May 14, 2013 at 03:03 PM

Seen: 899 times

Last Updated: May 19, 2013 at 04:00 AM

Copyright 2017 Redgate Software. Privacy Policy