Phil,

If you suspect errors, you may want to run dbcc updateusage on your database.

On the other hand, on my play system here, the size of the DB is given in MB and the reserved, etc, is given in KB. - So - when converting, you need to remember that there are 1024 KB in a MB. Sometimes people forget that there are not just 1000 KB in a MB. This along with rounding errors (they only show to 2 decimal places) may account for the descrepencies. If you want to mail out the output of the sp_spaceused (changing the DB name to protect the innocent), I'd be happy to have a look but I suspect that I will not do too much more than what I mentioned above.

At any rate, the short answer is that I have not seen this problem.

. . . Tom

Tom Zeblisky

On 02/19/2002 06:50:23 AM Phil Shuttleworth wrote:
> Could anyone answer this question, please?
>
> I'm running the stored procedure sp_spaceused on a complete database on a
> weekly basis.
>
> As the 'data' and 'index' sizes increase, the 'unused' amount maintains
> about 10% of 'data plus index', as I've got it set on automatic increase at
> 10%. Therefore, the 'reserved' amount increases, as would be expected.
>
> The number of Mb set for the 'database size' remains constant, so the
> 'unallocated space' reduces, which would also be expected.
>
> The questiion is:
>
> By subtracting the 'reserved' number of Mb from the 'database size',
> I get an answer which varies by 2 to 2.5 % les than the 'unallocated
> space' each week.
>
> I'm wondering if there is a bug somwhere, and would be interested if anyone
> else has encountered this problem.
>
> Phil Shuttleworth, DBA, IT Services, UCE.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed] Visit our Internet site at http://www.reuters.com

Any views expressed in this message are those of the individual
sender, except where the sender specifically states them to be
the views of Reuters Ltd.
MS Sql Server LazyDBA home page