Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2003
    Posts
    7

    Unanswered: Effect of Shrinking a DB

    Just wondering, other than the effect of making the database smaller, how does the shrink call affect actual performance? Should I expect an performance increase after it is done? Thanks.

    ~piro

  2. #2
    Join Date
    Jul 2003
    Location
    London
    Posts
    26

    Re: Effect of Shrinking a DB

    Generally all shrink does it reduce the size of the database files, no real performance gain as far as I know. You have to ask your self why did they grow to that size in the first place, before shrinking them as it is a performance hit when they have to grow again.

  3. #3
    Join Date
    Aug 2003
    Posts
    7

    Re: Effect of Shrinking a DB

    Thank you for replying.

    So there really is no performance decrease when I shrink the database. The performance hit will come from db growth, which is normal. Do you know of any other commands or functions that are similar to Access's compact command?

    ~piro

  4. #4
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    Not sure what Access's compact command does, but DBCC SHRINKDATABASE can move all data to contiguous pages and remove any remaining unused space. This has the potential of reducing I/O since you would need to read fewer pages to access all data.
    Paul Young
    (Knowledge is power! Get some!)

  5. #5
    Join Date
    Jul 2003
    Location
    London
    Posts
    26
    Good point, forgot about the moving of data pages.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •