SQL Clone
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)

SP to determine database file growth at intervals

By Neil Jacobson,

I wrote this SP to be run from a job every night. Change the myDB reference to be a database on your system for DBA use.

I just set up a job to run:
Exec sp_CatchFileChanges

Then I run in another step:

Select * from mydb.dbo.tbl_sysaltfiles_3

and output to a log file.

Alternatively you could insert into another table with a time stamp.

This gives me advanced warning if the database physical files are growing rapidly.

Total article views: 264 | Views in the last 30 days: 1