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.