• Don't use percent growth. 10% of 150 GB is 15 GB.

    While the database grows by 15 GB, performance degrades awfully.

    Use fixed size instead.

    I usually set data file growth to 100 Mb and log file growth to 50 Mb.

    -- Gianluca Sartori