SQL 2000 / 2005 Monitoring
Below you will find a listing of great MOM scripts courtesy of MOMResources.org. Many of these scripts are fully functional with no user customization required. This archive contains both scripts and Transact SQL queries for use with MOM 2005 to enhance and extend out-of-the-box functionality. The hyperlink in the script column will present the source code in a new window, and the description column provides guidance on function and purpose. Double-click on column headers below to sort entries by date or alphabetically.
| Date Added | Script | Description / Instructions for Use |
|
12/22/06 |
SQL Query Performance Check | For additional details see HERE. |
|
12/14/06 |
SQL Databases Missing Backups | Raises an alert for every database on every SQL server in your environment that has not received a full backup in a user-defined number of days. |
|
10/14/06 |
Recent MOM Alerts | SQL script that returns recent alerts generated by MOM. |
|
05/30/06 |
SQL 2000 Compliance Scripts | 2 Scripts here. 1 for checking version compliance for SQL Reporting Services and the second for checking the version of SQL 2000. |
| 05/30/06 | SQL Space Monitoring w/ Stored Procs | This is a SQL Space Monitoring that uses a stored procedure to get DB and log used space rather than relying on SQL DMO. Drawback is that you have to place the stored procedure in the master DB for each instance of SQL |
| 05/30/06 | SQL 2000 Space Analysis Percent Full | This is the same SQL Server 2000 Space Analysis script from the MOM SQL Manangement Pack, but it has been modifed to alert on the Percent full a DB or log is rather than alerting on raw space. |
| 06/15/2006 | SCDW Reindexing Script | This script reindexes the SystemCenterReporting data warehouse to optimize MOM Reporting Server performance. Complete explanation and instructions for use are in the accompanying readme.txt file. |
| 07/20/2006 | SQL Script Collection | A collection of miscellaneous mom-related scripts. |