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

Scripts by Tim Parker

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

Intelligent Index Reorganize and Rebuild Script - v1.0

This script will provide a dynamic mechanism to decide between REBUILDING an index or simply REORGANIZING an index. Tested and approved for SQL Server 2005 & 2008 Standard or Enterprise or R2.  Read more...
By Tim Parker 2012/11/26 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,456 reads

Monitoring Resource Governor Memory Grants

A very useful query that will allow you to monitor the resource governor memory grants along with other useful information.  Read more...
By Tim Parker 2011/03/03 | Source: SQLServerCentral.com | Category: resource governor
Rating: |  Discuss |   Briefcase | 2,973 reads

Average Page Life Expectancy

A useful script that I wrote that will sample the DMV sys.dm_os_performance_counters table to provide an average PLE captured in (1) minute intervals.  Read more...
By Tim Parker 2010/12/01 | Source: SQLServerCentral.com | Category: performance monitoring
Rating: |  Discuss |   Briefcase | 1,402 reads
   Items 1 to 3 of 3