2005 Disk Usage Report

[sendba]

All,

In 2005 whenever I use the SQL Server Disk Usage report. I get some weird numbers. Can some one tell me is this a normal behavior or anything to be concerned.

Total Space Usage : 261,900 MB
Datafile Space usage : 394,950 MB
Transaction log space usage : 11,900 MB

Data file Space usage (%)
It shows

Index : 24%
Data : 36%
Unused : 40%


My Question is what is the unused Space why it shows 40%.

Please let me know.

Thanks
Sen

 

[mrdenny]

Sounds like your metadata about your database is out of date.

Run this and it should correct the metadata.

use MyDatabase
GO
exec sp_spaceused @updateusage='true'
GO

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog