• Tim Jacobs-356724 (1/10/2012)


    Ninja, I don't want them to grow bad just trying to understand if the 3% is even revelant at this time given the free space. Some literature suggest never using autogrowth but monitor and adjust accordingly. I do appreciate the guidance from you and John.

    Never RELY on autogrow. It's an insurrance against unforseen data spikes or other problems.

    You should set it to 500 to 2000 mb and move on to your next task. That way the db(s) won't break (running out of space does that, no more transactions can happen, but read is ok).