SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

saleh_binmasood
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
IIS 7
1GBPS connectivity
Windows 2008 Server

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

ISSUE

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.

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2067 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. http://www.sqlserver-dba.com/2011/04/virtualization-and-database-servers.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.06 seconds. Powered By: Snitz Forums 2000