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

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)

Monitor Database Growth

By Brandie Tarvin-25024565,

This code provides a way of monitoring the growth of all your databases within a single instance. The first part is the creation of a monitoring table with the initial load of current databases and sizes. The second part is the SQL that can be put in a scheduled job to automate the growth monitoring.

It is recommended that this job is run weekly or monthly, depending on how fast your databases grow. Also, the code was written for SQL 2005 but can easily be altered for SQL 2000 by changing sys.Master_Files to sysaltfiles and sys.databases to sysdatabases. Make sure to change your column names appropriately if you make this alteration!

Total article views: 24248 | Views in the last 30 days: 86
 
Related Articles
FORUM

Monitor SSAS database size

Monitor SSAS database size

FORUM

Monitoring Connections to Databases

Monitoring Connections to Databases

FORUM

Database Monitoring System

Monitoring mulitple platforms and databases

FORUM

database mirroring monitor - remove server or database

database mirroring monitor - remove server or database

SCRIPT

Monitor database size with dbcc showfilestats

Use DBCC to help monitor the database size.

 
Contribute