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

Content with tags Performance Tuning, Query plans Rss

   Items 1 to 2 of 2   
 

Plans

By Steve Jones 2011/05/19 | Category: performance tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 2,637 reads

DMVs for Query Plan Metadata

Before you can tackle any performance issues with a working database, you need to know which queries to work on first: The ones that are taking the most time in total, and which are the most expensive in terms of cache, CPU and disk. Although SQL Server Management Studio can help, it isn't long before you need an armoury of DMVs to provide you the statistics to find the culprits.  Read more...
By Additional Articles 2010/09/02 | Source: SimpleTalk | Category: query plans
Rating:  Rate this |   Briefcase | 2,866 reads
   Items 1 to 2 of 2