Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saleh_binmasood
Starting Member
1 Post |
 Posted - 2012-09-22 : 07:56:08
|
| Dear Geeks,Please help me for a critical issue of 100% CPU Utilization and very Low Performance. Details are given belowServer Configuration Before:Quad Core 1 CPU15 GB RamSQL Server 2005IIS 71GBPS connectivityWindows 2008 Server Server Configuration AfterQuad Core 4 CPU16 GB RamSQL Server 2005IIS 71GBPS connectivityWindows 2008 ServerVMWare 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
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
CPU Utilization 100% after migration to Virtual M