Cool Tips‎ > ‎

Data/Database Size

 

Title

Description

Applicability

 

Retrieve DB and Log File Sizes    

 

Utilises sysperfinfo view to get the current file sizes for all DB and Log files.

 

2000, 2005, 2008, 2008R2, 2012

 

 

 

Get Database size and Object Counts    

Retireves a list of database sizes and objects counts for SPs, Tables, Views, UDFs and Users for all active DBs on a server. 

 

 

2000, 2005, 2008, 2008R2, 2012

 

 

Get Index Size and Counts

Retrieves index statistics for all tables in a database.  Includes sizes and counts by index type plus statistics update date.

 

2000, 2005, 2008, 2008R2, 2012

 

 

 

Comments