SQL Server Space Related Query

[snapjack123]

Hi,

I executed sp_spaceused on a SQL Server database and got the below results.

database_size : 16125.00 MB
unallocated space : 2593.04 MB

reserved : 10759128 KB
data : 8290296 KB
index_size : 2321744 KB
unused:147088 KB

The unallocated space is about 2.5 GB. The unused space shows 147.088 MB.

Does this mean that when 147 MB of the allocated unused space gets used up, space will be automatically taken up from the unallocated space (2.5 GB)? Or is it the case that some command has to be executed to allocate some space from the 2.5GB.

Thanks

 

[JayKusch]

I beleive you are correct in saying that the 147MB "Unused" value corresponds to the "total amount of space reserved for objects in the database, but not yet used"

The 2.5GB "unallocated space" is the "space in the database that has not been reserved for database objects".

Thus when the 147MB is exhausted by further database growth, futher useable allocations will be pulled from the unallocated space.

If I am mistaken, I am sure someone will correct me - lol.

Thanks

J. Kusch

 

[mrdenny]

Jay's got it correct.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog