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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy