Know all Database sizes in a server.

By gundapaneni, 2013/05/18

We can know how much space a database is occupied in hard disk by using sp_spaceused function. If we want to find all database sizes at a time, we have to provide use and sp_spaceused for all databases. It takes some time to write all those T-sql statments. My script will find each and every database size with out using sp_spaceused function. It will save your time and server time. Try this,

Total article views: 1572 | Views in the last 30 days: 7

FORUM

sp_spaceused

BLOG

sp_spaceused system-stored procedure

You can use the sp_spaceused system-stored procedure to return space usage information about a datab...

SCRIPT

Monitor database growth - a better way for sp_spaceused

A better way to use sp_spaceused, returning values on one row for the database instead of two.

FORUM

spaceused of a table

spaceused query...

ARTICLE

Automated Monitoring Database Size Using sp_spaceused

Keeping track of the amount of space in a database is something every DBA needs to do or face the dr...

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com