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

Scripts with tag Performance Monitoring Rss

Search for any content tagged performance monitoring

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 3 of 3   

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,504 reads

Collect SQL Server/Process Information - Quickly

Execute this script to get information on SQL server, databases, processes, memory, buffer, locks, etc.  Read more...
By Rudy Panigas 2011/04/21 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 5,404 reads

Finding Execution Time of a SQL Statement

Capturing the execution time for rebuilding an index for set of tables.  Read more...
By Prashanth Jayaram 2008/12/26 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,601 reads
   Items 1 to 3 of 3