EMs Database Space Available Wrong

Anyone ever see a case where the Space Available number
reported in Enterprise Manager's General Database
Properties tab is wrong?
My database has the following characteristics:
-1- Has a Daily Backup Maintenance plan (no other
optimizations such as data reorg and such)
-2- Simple Recovery Model
-3- Auto Update Statistics = on
-4- Auto Create Statistics = on
-5- All other settings on Options tab = off
I went and increased the data file to 500 MB larger than
the current size and still do not see Available space
increase. It's sitting at 0.
Any explanations/assistance would be greatly
appreciated. Thanks, Bob
See DBCC UPDATEUSAGE in SQL Server 2000 Books Online.
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Bob Albert" <bob.albert@.quest.com> wrote in message
news:4d7b01c524de$84e83fc0$a501280a@.phx.gbl...
> Anyone ever see a case where the Space Available number
> reported in Enterprise Manager's General Database
> Properties tab is wrong?
> My database has the following characteristics:
> -1- Has a Daily Backup Maintenance plan (no other
> optimizations such as data reorg and such)
> -2- Simple Recovery Model
> -3- Auto Update Statistics = on
> -4- Auto Create Statistics = on
> -5- All other settings on Options tab = off
> I went and increased the data file to 500 MB larger than
> the current size and still do not see Available space
> increase. It's sitting at 0.
> Any explanations/assistance would be greatly
> appreciated. Thanks, Bob
|||That's worked! Thank you so much!
Bob
>--Original Message--
>See DBCC UPDATEUSAGE in SQL Server 2000 Books Online.
>--
>Vyas, MVP (SQL Server)
>SQL Server Articles and Code Samples @.
http://vyaskn.tripod.com/[vbcol=seagreen]
>
>"Bob Albert" <bob.albert@.quest.com> wrote in message
>news:4d7b01c524de$84e83fc0$a501280a@.phx.gbl...
than
>
>.
>
|||> Anyone ever see a case where the Space Available number
> reported in Enterprise Manager's General Database
> Properties tab is wrong?
Yes, Enterprise Manager is often wrong because it relies on cached data for
a lot of its values. If you want a reliable space used report, use EXEC
sp_spaceused in Query Analyzer, not Enterprise Manager. Also check into the
@.updateusage parameter. (sp_spaceused is well documented in Books Online).
Aaron
|||Narayana had the answer. I was actuallly originally
using sp_spaceused. I executed DBCC UPDATEUSAGE (0) on
the database in question and it corrected the issue.
Thanks for responding so quickly! Bob
>--Original Message--
>Yes, Enterprise Manager is often wrong because it relies
on cached data for
>a lot of its values. If you want a reliable space used
report, use EXEC
>sp_spaceused in Query Analyzer, not Enterprise Manager.
Also check into the
>@.updateusage parameter. (sp_spaceused is well
documented in Books Online).
>Aaron
>
>.
>
|||> using sp_spaceused. I executed DBCC UPDATEUSAGE (0) on
> the database in question and it corrected the issue.
Note that if you want to use the EM view, you're going to have to open QA to
execute the DBCC command every time anyway. Why not just use QA, then you
can save a script with EXEC sp_spaceused withthe @.updateusage parameter and
never wonder if your space used report is really up to date.