More and more applications use SQL Server as back-end it becomes important to track the growth of them. Especially when you everything on clustered indexes where diskspace can become a problem if the databases grow to fast. Their are 3th party programs that can track the growth but all the information we need is stored in the master database of a SQL Server. I wrote an Active X Script that runs from a DTS to collect the information from the SQL Servers in your company and bundles all that information in 1 webinterface. This DTS can then be scheduled to run once a week so you get a nice overview. I have taken some screenshots, I will not explain the script step-by-step. All source is open and you can ask additional information about it via the forum. Comments or suggestions are offcourse welcome.

Download the source files

Discuss this article in the forum!

List of databases on a server


Database details


Shared disks on a selected cluster


Free diskspace history