March 28, 2003 at 9:47 am
Here's sp_spaceused on database "Hawk"
database_name: HAWK
database_size 4877.06mb
unallocated space: 2344.38mb
reserved: 2593464KB
data: 1064912KB
index size: 1527656KB
unused 896KB
It appears we have over 2GB unallocated. This is a lot of space and I don't know what is using it or why that much is being used on the first place. Also, I don't know what the "reserved" column means but is that the source of our space loss? Bottom line: what can I do to get the space back?
TIA,
Bill
March 28, 2003 at 9:54 am
Check in the db options the autogrowth property and also the Mb or % on incremental size. Maybe there is to big and the db size increase to much for your needs. Could be also that you initially create the db with too much space.
When initially create the db, SQL fills the pages to allocate as much space as you specify. Wether you use it with data or not, it belongs to SQL, so be carefull with the size you use for your db.
You can shrink the db, with the Command DBCC ShrinKDB or ShrinkFile or with Enterprise Manager.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply