|
Home > Archive > MS SQL Server > October 2006 > dbcc reports different size than shown in database properties
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
dbcc reports different size than shown in database properties
|
|
| JeremyGrand 2006-10-24, 6:37 pm |
| In sql 2k, I've been looking at size and autogrowth, and some issues have
come up.
In my database properties, general tab, I see size 9118mb, space avail
1372mb. However, when I run
dbcc showfilestats
I get an allocated size of 7808mb (TotalExtents*64/1024.00), and free space
of 189mb ((TotalExtents-UsedExtents)*24/1024). Why this huge discrepancy?
Perhaps the log is counted in the size, but surely that should not affect
space available.
Jeremy
| |
| Andrew J. Kelly 2006-10-24, 6:37 pm |
| Try running DBCC UPDATEUSAGE and see if that helps.
--
Andrew J. Kelly SQL MVP
"JeremyGrand" <jeremy@ninprodata.com> wrote in message
news:eUDnqux7GHA.1560@TK2MSFTNGP04.phx.gbl...
> In sql 2k, I've been looking at size and autogrowth, and some issues have
> come up.
>
> In my database properties, general tab, I see size 9118mb, space avail
> 1372mb. However, when I run
>
> dbcc showfilestats
>
> I get an allocated size of 7808mb (TotalExtents*64/1024.00), and free
> space of 189mb ((TotalExtents-UsedExtents)*24/1024). Why this huge
> discrepancy? Perhaps the log is counted in the size, but surely that
> should not affect space available.
>
> Jeremy
>
|
|
|
|
|