Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag DMV Rss

Search for any content tagged dmv

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 9 of 9   
 

SQLPS Meets the DMV's

This is a great wrapper for your DMV's to automate a quick performance metric capture.  Read more...
By Edward Pochinski 2016/01/12 | Source: SQLServerCentral.com | Category: dmv
Rating: (not yet rated) |  Discuss |   Briefcase | 290 reads

Finding Queries to Tune

A query to help identify queries that need some tuning.  Read more...
By Simon Osborne 2015/10/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,449 reads

Get Top Queries Taxing SQL Server CPUs

Script which uses SQL Server DMOs to gather top CPU taxing queries which can benifit most from tuning.  Read more...
By Prakash Heda 2012/03/10 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,761 reads

What Is Filling Up The Transaction Log

Report unusual conditions that may be filling up your transaction log.  Read more...
Rating: |  Discuss |   Briefcase | 4,818 reads

Signal and Resource Waits

Calculates the signal and resource waits as a percentage of overall wait time.  Read more...
Rating: |  Discuss |   Briefcase | 1,358 reads

Missing Indexes By Index Advantage

Identifies potentially missing indexes.  Read more...
Rating: |  Discuss |   Briefcase | 4,355 reads

List Unused Tables and Indexes

Finds tables and indexes that do not show up in the usage statistics.  Read more...
Rating: |  Discuss |   Briefcase | 3,295 reads

Clear Wait Statistics

Clears the wait statistics so that the results of the 'Signal and Resource Waits' scripts are more relevant  Read more...
Rating: |  Discuss |   Briefcase | 1,826 reads

Aggregating Index usage information

This script aggregates index usage stats into a view.  Read more...
By sql frenzy 2008/11/25 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,284 reads
   Items 1 to 9 of 9