• TheSQLGuru (1/7/2011)


    Good luck with the testing. Don't forget to size tempdb appropriately and not wait for autogrowths to size it for you.

    Yep. It's happening Saturday night and there's no better way I could think of spending my Saturday night than watching transaction logs grow.

    I set the tempdb log equivalent to the largest log growth for the admin database and will keep an eye on usage during the maintenance.

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.