Thursday, March 22, 2012

Database Size - how to get

Could anybody remind please, how can I get the current database size having
the full access to this database and server? What's the SQL query?
What else helpful about the current database can I get using queries? Load,
statistics, what else?
Thanks,
Just D.Check out sp_spaceused in the BOL.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Just D." <no@.spam.please> wrote in message
news:D_o%d.57888$xt.46304@.fed1read07...
Could anybody remind please, how can I get the current database size having
the full access to this database and server? What's the SQL query?
What else helpful about the current database can I get using queries? Load,
statistics, what else?
Thanks,
Just D.

No comments:

Post a Comment