Posted by Robert Klemme on 12/29/07 17:49

On 29.12.2007 10:53, Erland Sommarskog wrote:
> Neil (nospam@nospam.net) writes:
>> So this gets back to my original question. If there is about 1 GB of
>> data in the db; and the database is showing 2.5 GB of data; then where's
>> that other 1.5 GB of data coming from? Fragmentation seems to have been
>> reduced greatly. So what is that other 1.5 GB that is being reported?
>> This is very strange.
>
> I'm afraid that by now I have exhausted all ideas. With the drastic
> reduction of CustomerMerges, one would expect to see a big increase in
> unallocated space. 226661 pages is 1.8 GB. I suspect that the number
> 226661 is bogus somehow.
>
> The only thing I can suggest is that you create a new database from scripts,
> and the load it with data from the current database. It may not be worth
> the hassle though.

But if Neil switches SQL Server versions during the process (he is still
on 7 with two newer versions) it might still be worthwhile (proper
licenses available of course). Or would you rather disregard that
option for compatibility reasons?

Kind regards

robert

[Back to original message]