March 13, 2014 at 3:21 am
I have a DB (SQL Server 2005)
Here are the result from sp_spaceused:
database_namedatabase_sizeunallocated space
MYDB 45285.50 MB36.28 MB
reserved data index_sizeunused
45226400 KB43036096 KB2162968 KB27336 KB
Weekly maintenance on this database includes using a sql server builtin maintence plan with 2 tasks: rebuild indexes (reorganize pages with default amount of free space) and an update statistic task.
This database has had an unusual growth spurt and I am trying to determine if there is any space that can be reclaimed back to the file system. can anyone help?
March 13, 2014 at 3:31 am
As per the data provided everything looks OK; as only 36 MB unallocated space is reflecting out of 45 GB.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 13, 2014 at 4:20 am
Thanks. That is how I read it too!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply