Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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   
 

sp_spaceused2

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: SQLServerCentral.com | Category: size
Rating: |  Discuss |   Briefcase | 1,374 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: SQLServerCentral.com | Category: server side trace
Rating: (not yet rated) |  Discuss |   Briefcase | 936 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: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 1,880 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: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 1,569 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: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 1,891 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: SQLServerCentral.com | Category: transcation log
Rating: |  Discuss |   Briefcase | 3,264 reads

SQL Server System Report

Report to keep you abreast of various details of an instance, including: general 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 2013/10/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,917 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/07/18 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 7,851 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,221 reads

Backups daily monitoring

This script finds the last run status for Full / TL backups.  Read more...
By Arun Jebakumar 2009/09/04 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,210 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: SQLServerCentral.com | Category: change
Rating: |  Discuss |   Briefcase | 1,647 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: SQLServerCentral.com | Category: disk space
Rating: |  Discuss |   Briefcase | 3,751 reads

Find failed SQL Jobs

Simple T-SQL to find failed SQL Agent jobs  Read more...
By free mascot 2013/01/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,014 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: SQLServerCentral.com | Category: sql trace
Rating: |  Discuss |   Briefcase | 1,154 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: SQLServerCentral.com | Category: blocking
Rating: |  Discuss |   Briefcase | 2,049 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: SQLServerCentral.com | Category: database size
Rating: |  Discuss |   Briefcase | 3,403 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: SQLServerCentral.com | Category: sp_spaceused
Rating: |  Discuss |   Briefcase | 3,917 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: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 1,429 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: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 3,033 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: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 3,877 reads
   Items 1 to 20 of 20