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

Content with tags T-SQL, Performance Tuning, DMV 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: | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,346 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,491 reads
   Items 1 to 2 of 2