Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
catparks
Starting Member
18 Posts |
 Posted - 2005-05-06 : 10:45:18
|
I recently purchased a database monitoring tool, which shows total space, free space, and used space for the database and log files. It shows an alert on database and log files that have more than 90% used. Most of the databases are more than 90% used and some even show a negative amount of free space. I ran the sp_spaceused stored procedure and do not clearly understand what "unallocated space" is, or how to keep space unused above 90% for the databases. They are set to autogrow 10%. Any help or insight is appreciated.Catparks  |
|
|
|
|
|
Unallocated Space?