• mark (1/6/2009)


    Or do something sane and calculate the maximum amount of wait time your users are willing to tolerate, determine the amount of space Sql Server can initialize in that time, and set the value appropriately.

    Or, better yet, monitor the free space and growth of the DB and grow it manually during maintenance time before the auto-grow kicks in.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass