Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tags Performance Tuning, DMV, SQL Server 2008 Rss

   Items 1 to 2 of 2   

Get Top Queries Taxing SQL Server CPUs

Script which uses SQL Server DMOs to gather top CPU taxing queries which can benifit most from tuning.  Read more...
By Prakash Heda 2012/03/10 | Source: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,702 reads

Troubleshooting Performance Problems in SQL Server 2008

This white paper provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools.  Read more...
By Additional Articles 2009/07/31 | Source: TechNet Blogs | Category: troubleshooting
Rating:  Rate this |   Briefcase | 4,268 reads
   Items 1 to 2 of 2   
dmo (1)    
extended events (1)    
profiler (1)    
sql server 2012 (1)    
system monitor (1)    
top cpu queries (1)    
troubleshooting (1)