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)

Script to gain capacity information

By kmlakov,

Recently at my site we had a need to gather current capcatiy of all databases as well as table obejcts on our servers.  although there are some out of the box stored proceudres to assist in this effort as well as some schema objects, they mostly would return information on one database at a time.  Not to mention we wanted to foramt this information into a report that could be distrubuted to server administrators and management.  the follwoing two scripts will return inforamtion for all databases on server as well as individual table inforamtion such as primary key size, index size, total records etc.you can then take these results and paste into excel, i have a dts as well that will paste for me but i belive that is another topic.  please note these procs will call system tables and objects so sa privileges will be required.PLEASE NOTE THESE PROCS SHOULD BE PALCED INTO MASTER DB AND IN QUERY ANALYZER SET TABS AT 4. enjoy

Total article views: 254 | Views in the last 30 days: 1
 
Related Articles
FORUM

How to insert these dates in database

How to insert these dates in database

ARTICLE

Database Snapshots in SQL Server 2005

One of the brand new features in SQL Server 2005 is the database snapshot. New authors Arvinder Sing...

FORUM

database mirroring monitor - remove server or database

database mirroring monitor - remove server or database

FORUM

Backup BizTalk Server Databases

Backup of BizTalk Server Databases

ARTICLE

TDE and SQL Server Databases

The article discusses and demonstrates TDE for SQL Server databases

 
Contribute