December 11, 2013 at 1:04 pm
we recently moved from 4 to 8 cores on the SQL server 2008 db in a vm environment (at hosting.com). CPU has been higher than ever.
What could be the issue..
Or do i need to check some key points can some one through a light on this..?
December 12, 2013 at 4:36 am
Is it a problem? I mean, you're using a lot of CPU, but are you experiencing slow performance? And further, is that slow performance caused by CPU? What are your top 10 wait statistics? If you are experiencing issues because of CPU, then you need to determine if it's SQL Server that's using the CPU or an external process. If it's SQL Server, then you need to drill down on which processes are using the most CPU.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 12, 2013 at 5:35 am
Also check if any settings changed in VM and thus facing this issue?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 13, 2013 at 5:37 pm
Penserver (12/11/2013)
we recently moved from 4 to 8 cores on the SQL server 2008 db in a vm environment (at hosting.com). CPU has been higher than ever.What could be the issue..
Or do i need to check some key points can some one through a light on this..?
Did you ever figure out the answer to this?
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply