-
Available Space at my database
Hi, I work on SQL Server 6.5,
and I want to make a documentation about available space of my databases.
So, I must know how many databases space used everyday ?
If somebody know how to get this available space or how to make this script.
I hope you want to tell me about this.
Thanks you so much for your cooperation.
-
Available Space at my database (reply)
Try sp_spaceused.
------------
Susan at 1/9/2002 11:28:18 PM
Hi, I work on SQL Server 6.5,
and I want to make a documentation about available space of my databases.
So, I must know how many databases space used everyday ?
If somebody know how to get this available space or how to make this script.
I hope you want to tell me about this.
Thanks you so much for your cooperation.
-
Available Space at my database (reply)
I created a web page that runs from my web server that polls the database and displays:
Disk Free Space
Database Size
Database % Free
Data DEVICE % Free
Log DEVICE % Free
All data comes from available stored procs in sql
xp_fixeddrives
sp_helpdb
dbcc sqlperf(logspace)
sp_spaceused
Cheers,
Davy
------------
Susan at 1/9/2002 11:28:18 PM
Hi, I work on SQL Server 6.5,
and I want to make a documentation about available space of my databases.
So, I must know how many databases space used everyday ?
If somebody know how to get this available space or how to make this script.
I hope you want to tell me about this.
Thanks you so much for your cooperation.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|