Post reply

File growth setting -Percent or MB

  • January 15, 2019 at 1:39 am

    #376819

    Hi Experts
    Compliments of the New year!
    What is the best file growth setting for a database that grows with about 6GB a week?Currently it is set to 50mb ,autogrowth on and maximum file size = unlimited.Is this proper?

    Thank you and enjoy your day

    T

  • January 15, 2019 at 1:44 am

    #2018904

    Hi,
    never use %, set some value that fits to your database size.
    But the best way, do not use autogrowth. Calculate the size of the database per year, and avoid autogrowth.
    If you know, that your database will grow every week 6 gb, why do you not set the correct size till the end of the year.
    You did not know, when your autogrowth will happen, or?
    Kind regards,
    Andreas

    PS: and check, if IFI is active,

  • January 15, 2019 at 1:53 am

    #2018905

    Also make sure you have instant file initialization on so that autogrowth events are as non-disruptive as possible.

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

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