Track Database Disk-Space Usage on a Granular Level

Thursday Oct 30th 2008 by DatabaseJournal.com Staff

Find out how much space is being used by tables and their indexes.

[From SQL Server Magazine]

One of the housekeeping challenges DBAs face is to keep track of their databases’ growth and how much space is being used by each table and index in those databases. To meet this challenge, I wrote a stored procedure, usp_ SpaceUsedAnalyzer, that extends the functionality of the sp_spaceused system stored procedure to present more detailed information.

The article continues at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=100213

Mobile Site | Full Site