MS SQL Server - Check Disk Size in SQL 2000

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Check Disk Size in SQL 2000

cpatel1@gmail.com

2006-10-28, 7:14 pm

I was wondering if there is a way to check the total disk size using
SQL 2000. There is a function to check how much is left, but havnt
found anything to check total size.

John Bell

2006-10-28, 7:14 pm

Hi

I am not sure what you mean by this! You can look at the output of sp_helpdb
or sp_helpfile to get the file sizes of the databases and you can do this for
each database using a cursor! There are also SQL Server related permon
counters to monitor file sizes as well as perfmon counters to monitor disc
space usage. You can set an alert using perfmon if you disc usage reaches a
threshold. Alternatively you could use MOM to monitor your systems.

HTH

John

"cpatel1@gmail.com" wrote:

> I was wondering if there is a way to check the total disk size using
> SQL 2000. There is a function to check how much is left, but havnt
> found anything to check total size.
>
>

Sponsored Links