SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Performance Tuning, Query plans Rss

   Items 1 to 2 of 2   


By Steve Jones 2011/05/19 | Category: performance tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 2,677 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 | 3,209 reads
   Items 1 to 2 of 2