Post reply

Auto Shrink - When does the shrink db execute?

  • June 23, 2003 at 9:03 am

    #161812

    The shrink db process id was blocking other processes in a production environment recently, and I'm trying to track down when the job started.

    Any ideas on how to determine when the auto shrink actually executes (being and end)?

  • June 23, 2003 at 9:24 am

    #462639

    SQL Server will try to shrink the files when found out that the files has about 25% of free space during its periodic checks (checkpoints). It also reduces the Log files using the Tran Log Backup process.

    One suggestion though is to set the auto shrink to off. You may want to have more control when to shrink the file or not for performance issues.

  • June 23, 2003 at 9:28 am

    #462641

    One of the problems with Autoshrink is that it will run when you don't want it.

    Turn AutoShrink off and set up a nightly job to do database maintenance.

    Patrick

    Quand on parle du loup, on en voit la queue

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

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