Post reply

DBCC SHRINKDATABASE causes table space to grow

  • February 23, 2003 at 11:27 pm

    #58831

    Hi,

    I just ran DBCC SHRINKDATABASE on a large database an noticed that the space used by the data grew quite a bit. Looking at DBCC SHOWCONTIG results the Extent Scan Density and Extent Switches went way up. Does anyone know why this happened?

  • February 24, 2003 at 4:31 pm

    #449657

    I forgot to mention that I'm on SQL 7.0 sp4 and the tables in question do not contain blob or text data.

    Any help would be greatly appreciated.

    Thanks

  • February 25, 2003 at 7:52 am

    #449692

    We had that problem, but it had blobs. MS recommended turning on Traceon 1180 (?). But it is specifically related to Blobs.

    KlK, MCSE


    KlK

  • February 25, 2003 at 9:54 am

    #449704

    Thanks. I lost 6GB of space to a table that has mostly varchar and int datatypes. I had just reindexed this table the week before so I'm still confused about why the Scan Density went from ~90% to 45% after DBCC Shrinkdatabase.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply