Auto Close and Auto Shrink - Just Don't

  • Robert W Marda

    SSChampion

    Points: 13413

    Most of our databases in production use auto shrink. None of them use auto close.

    I suspect the reason we have not noticed much in the way of a performance hit is because it is rare to have large amounts of data deleted during peak hours. Whenever a customer issues a delete command what really happens is a delete column is flagged as deleted. Some months later this data is moved to an archive table in the same database. So all our databases are gradually growing which means the auto shrink probably doesn't often try to shrink our databases.

    Robert W. Marda

    SQL Programmer

    bigdough.com

    The world’s leading capital markets contact database and software platform.

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

  • shew

    SSChampion

    Points: 11310

    Robert,

    I suspect that is why we do not tend to see problems with Auto Shrink as well. "Purge" does not seem to be in our Developers' vocabulary. The majority of our databases tend to grow steadily so there is little to shrink, except for the log files.

    Jon

  • tim-142151

    SSC Veteran

    Points: 219

    yeh.. um.. ok, there must be times where you have to auto-shrink!  Isn't there? or is it completely dud and useless?

     

  • colin-815699

    Valued Member

    Points: 67

    If auto-shrink is turned on , is there any possible side effects on the database if you turn it off ?

Viewing 4 posts - 16 through 19 (of 19 total)

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