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

Scripts with tag Monitoring Rss

Search for any content tagged 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 20 of 20   


The sp_spaceused procedure does not provide schema name in return. Here is sp_spaceused2 that does.  Read more...
By Jason S Wong 2012/04/02 | Source: | Category: size
Rating: |  Discuss |   Briefcase | 1,405 reads

Server-Side Trace Pack

Loads temporary stored procs that assist in running and monitoring server-side tracing.  Read more...
By Greg Drake 2012/03/02 | Source: | Category: server side trace
Rating: (not yet rated) |  Discuss |   Briefcase | 1,032 reads

Job Summary

This script lists the name, running and success status, last executed/currently executing step name, Average and Last duration, next run time and other related information about Jobs.  Read more...
By Adnan Korkmaz 2012/10/10 | Source: | Category: agent jobs
Rating: |  Discuss |   Briefcase | 2,023 reads

Tracking processes

This script quick tip for those who will accurately monitor sessions on SQL Server.  Read more...
By Wellington Vitoriano 2011/08/16 | Source: | Category: monitoring
Rating: |  Discuss |   Briefcase | 1,621 reads

Email Long Running SPID Info

This script will email info about the longest running SPID in an HTML formatted table  Read more...
By Deon Benjamin 2011/07/07 | Source: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,128 reads

Transcation Log space monitoring

This SP will monitor T-Log space and sends mail to DBA if log space usage is above threshold value  Read more...
By Vinayaka Gangadhar 2010/10/05 | Source: | Category: transaction log
Rating: |  Discuss |   Briefcase | 3,394 reads

SQL Server System Report

Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more.  Read more...
By Sean Smith 2016/01/11 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 14,423 reads


Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2016/01/06 | Source: | Category: sp_who
Rating: |  Discuss |   Briefcase | 12,030 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: | Category: monitoring
Rating: |  Discuss |   Briefcase | 5,393 reads

Backups daily monitoring

This script finds the last run status for Full / TL backups.  Read more...
By Arun Jebakumar 2009/09/04 | Source: | Category: backup and restore
Rating: |  Discuss |   Briefcase | 2,242 reads

Change Monitor in SQL Server 2005

Track object definition or table schema changes in any database. Batteries required: you need to create a few things to make it run.  Read more...
By David Korb 2010/05/14 | Source: | Category: change
Rating: |  Discuss |   Briefcase | 1,686 reads

Disk Space Report

This scripts helps to power you with the disk space monitoring for the Mount points. Hope this helps  Read more...
By Aditya Kota 2010/05/27 | Source: | Category: disk space
Rating: |  Discuss |   Briefcase | 3,945 reads

Find failed SQL Jobs

Simple T-SQL to find failed SQL Agent jobs 
By free mascot 2013/01/03 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,358 reads

Default Trace Load of All 5 Files

The default trace keeps the last 20 meg of info, and a max of 5 files...This loads all 5 files into a table so it can be reviewed.  Read more...
By Lowell Izaguirre 2009/02/25 | Source: | Category: sql trace
Rating: |  Discuss |   Briefcase | 1,194 reads

Complete Blocking Report

A complete blocking report which gives the complete information about what queries are runninng and it will be worth capturing the details before we decide to kill the processes.  Read more...
By Vee 2009/01/08 | Source: | Category: blocking
Rating: |  Discuss |   Briefcase | 2,146 reads

Another way to track the database data growth

Scripts will display size of the data in the database/data files and remaining allocated space.  Read more...
By Max Yasnytsky 2013/05/10 | Source: | Category: database size
Rating: |  Discuss |   Briefcase | 3,640 reads

Monitor database growth - a better way for sp_spaceused

A better way to use sp_spaceused, returning values on one row for the database instead of two.  Read more...
By Gaby Abed 2008/09/04 | Source: | Category: sp_spaceused
Rating: |  Discuss |   Briefcase | 3,985 reads

Monitor Any Linked Server From SQL 2000

Best way to monitor Excel, Access, SQL Linked Servers from SQL 2000  Read more...
By Sakthivel Chidambaram 2008/07/11 | Source: | Category: monitoring
Rating: |  Discuss |   Briefcase | 1,459 reads

Monitor Any Linked Server From SQL 2005

Best way to monitor Excel, Access, SQL Linked Servers from SQL 2005  Read more...
By Sakthivel Chidambaram 2011/12/19 | Source: | Category: monitoring
Rating: |  Discuss |   Briefcase | 3,095 reads

Who did what?

This select will show the last sql statement for every open session plus many helpfull information.  Read more...
By mobasha B 2012/01/13 | Source: | Category: monitoring
Rating: |  Discuss |   Briefcase | 3,944 reads
   Items 1 to 20 of 20