Post reply

Sql Autogrowth

  • December 18, 2019 at 8:26 am

    #3708702

    Hi All

    I am looking for the script that will tell me the recommended autogrowth in MB for data file and log file that can be applied to all databases

    your response is much appreciated

    thanks

     

     

     

     

  • December 18, 2019 at 9:51 am

    #3708725

    There's no such thing.  You should set the autogrowth for each database based on a number of factors, including, but not limited to:

    1. Whether you are content for autogrowth to occur naturally or whether you prefer to grow the files manually and rely on autogrowth only as a backstop;
    2. How fast you expect the database to grow;
    3. Whether you prefer a smaller number of large growth events, or a larger number of small growth events;
    4. In the case of log files, your knowledge of VLFs and their effect on recovery times, log reuse and so on.

    John

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

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