Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 CPU Utilization 100% after migration to Virtual M
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 09/22/2012 :  07:56:08  Show Profile  Reply with Quote
Dear Geeks,

Please help me for a critical issue of 100% CPU Utilization and very Low Performance. Details are given below

Server Configuration Before:
Quad Core 1 CPU
15 GB Ram
SQL Server 2005
1GBPS connectivity
Windows 2008 Server

Server Configuration After
Quad Core 4 CPU
16 GB Ram
SQL Server 2005
1GBPS connectivity
Windows 2008 Server
VMWare Server


The application was running smoothly before and the server was also not showing this much CPU consumption normally it was around 40 to 60 percent. We then upgraded to a new machine with 4 CPU. The upgrade was done using VMWare tools and the same software configuration was maintained as on the old machine. The database was copied and attached in the new server. Now as soon as the users begin to hit the application the server CPU usage shoots up to 100 percent and does not come down at all. We checked which process is running and SQL Server is showing 100 % CPU consumption. We are unable to track down what is causing this issue. A few things that we have observed.

1. There is not much difference in the incoming traffic onto the website.
2. The number of users remains constant.
3. There are multiple sessions generated in the SQL Server event viewer.
4. There are sessions for master and/or temp databases although the processes are showing sleeping in the event viewer.

Your help and suggestions are highly appreciated.

Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 09/22/2012 :  08:13:13  Show Profile  Visit jackv's Homepage  Reply with Quote
Just as a double check - check there isn't a query which is consuming all the CPU.
I have some notes on various virtualization issues - check the CPU checklist section.

Jack Vamvas
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000