• Hi,

    The transaction log has to be configured well too. Growing files is pretty expensive operation.

    Do you care about the VLFs count? The following link can help you configure it well - http://www.sqlskills.com/blogs/kimberly/transaction-log-vlfs-too-many-or-too-few/

    Check the following link too: http://www.sqlskills.com/blogs/kimberly/8-steps-to-better-transaction-log-throughput/

    Regards,

    Igor

    Igor Micev,My blog: www.igormicev.com