Home Forums SQL Server 2008 SQL Server 2008 - General SQL Server instance is taking 100% CPU and is very slow RE: SQL Server instance is taking 100% CPU and is very slow
Ant-Green
SSC Guru
Points: 113445
More actions
November 19, 2012 at 1:54 am
#1560200
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.