|
saleh_binmasood
Starting Member
1 Posts |
 Posted - 09/22/2012 : 07:56:08
|
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. |
|
CPU Utilization 100% after migration to Virtual M
