SQL Server instance is taking 100% CPU and is very slow

Question

SQL Server instance is taking 100% CPU and is very slow

Mani-584606

SSChampion

Points: 11788
More actions
November 16, 2012 at 10:43 am

#264996

Hi,
SQL Server instance is taking 100% cpu. I tried to find the active sessions using sp_who2 'active' and I got one select statement in running. but when I see the cpuTime column for that, the value is 1063
I believe that query is taking very little CPU.
But why the SQL Server is taking 100% CPU? how to find what else is taking cpu?
Please advise.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

Run Brad's DMV Starter Pack especially the CPU related DMVs against your instance, http://www.bradmcgehee.com/2010/07/free-sql-server-dmv-starter-pack/

Also read chapter 3 of the Accidental DBA guide, link in my signature below.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass