SQL Server 2008 CPU usage goes to 100% - troubleshooting help needed?

Posted by Ali on Server Fault See other posts from Server Fault or by Ali
Published on 2011-08-04T09:21:27Z Indexed on 2012/04/11 17:31 UTC
Read the original article Hit count: 293

I have a fairly powerful database server having SQL Server 2008 R2 installed. There is only one database on it which is being accessed from 2 servers (around 5/6 applications). The problem is as soon as applications start pointing to the database, system's CPU usage goes upto 100% with sqlserver itself using 95+%.

I have checked profiler, there aren't any heavy queries running there. I have checked active connections, they are hardly 150. Still CPU usage is around 100% and applications are experiencing slow response/connection to database server are getting refused.

Database grus, I really need some ideas here. Thanks.

© Server Fault or respective owner

Related posts about sql-server

Related posts about sql-server-2008