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

Content with tags Performance Tuning, SQL Server 2008, DMV 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: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,539 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,157 reads
   Items 1 to 2 of 2   
 
Tags
dmo (1)    
extended events (1)    
profiler (1)    
sql server 2012 (1)    
system monitor (1)    
top cpu queries (1)    
troubleshooting (1)