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, T-SQL Rss

   Items 1 to 2 of 2   
 

Finding queries to tune

A query to help identify queries that need some tuning.  Read more...
By Simon Osborne 2013/06/11 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,117 reads

Finding the Worst Performing T-SQL Statements on an Instance

Greg Larsen introduces some Dynamic Management Views (DMVs) and Dynamic Management Functions (DMFs) to help monitor your application's T-SQL performance. In addition, he provides a Stored Procedure that utilizes the DMVs and DMFs to produce a report that quickly identifies poorly performing T-SQL statements.  Read more...
By Additional Articles 2009/03/02 | Source: Database Journal | Category: dmv
Rating: (not yet rated)  Rate this |   Briefcase | 5,434 reads
   Items 1 to 2 of 2