Post reply

Autogrowth - Unrestricted

  • June 8, 2009 at 12:27 am

    #134842

    I had created a database with size of 20 MB (Data file - 10 MB & Log file - 10 MB).

    Please let me know, in Autogrowth if i specify 'by 10 percent, unristricted growth' upto what size this will extend its size?

    Thanks in advance.

  • June 8, 2009 at 12:47 am

    #1005916

    It might eat up all of disk space available. While considering this option you should analyze your database growth which depends on numerous factors. Which mainly depens on the capacity planning for your Database.

    Would suggest you to look into MS article about setting this option and also read on capacity planning for your database.

    http://support.microsoft.com/kb/940945

    "More Green More Oxygen !! Plant a tree today"

  • June 8, 2009 at 2:57 am

    #1005966

    Thansk for your information that really helps.

  • January 13, 2010 at 5:46 pm

    #1103374

    You can set autogrowth to a specific size and depending on the database grow you may want to add extra files on the same filegroup but on a different disk.



    My blog

  • January 14, 2010 at 7:57 am

    #1103609

    You want to be careful using a fixed % since as you file gets bigger soon 10% is a huge chunk to get allocated at one time.

  • January 14, 2010 at 8:04 am

    #1103618

    Better use auto growth in MB rather that %.

    Also, see that you have given enough space for the database as auto grow is a costly operation!

    Pavan.

Viewing 6 posts - 1 through 5 (of 5 total)

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