I see the different size of db | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

I see the different size of db

When I click on the property window I see the different size of db.Say if space allocated for data and log file are 2 MB each.then the tolal size of db should be 4,But I can see different size of db.The size always show in decimal.But I have never set the space allocated ever in decimal.
total db shize as per my knowlege should be the sum of space allocated for data and log file.Pls suggest all about the "size " thing in the server
Try running DBCC UPDATEUSAGE (0) and refresh your view. The size information in sysindexes sometimes get out of sync.
And its better take consideration from running statements like SP_SPACEUSED instead of viewing the contents from Enterprise Manager, as it meant to be flaky sometimes. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>