Home Forums SQL Server 2005 Administering Adding an extra file to TEMPDB RE: Adding an extra file to TEMPDB

  • February 28, 2013 at 11:04 am

    #1592123

    Robert Davis (2/28/2013)

    ScottPletcher (2/28/2013)

    Zero chance. I'd never disable autogrow on tempdb: you could slam your entire instance to a halt -- or worse, perhaps cause it to crash.

    If you've pre-sized the files to consume almost the entire drive, there's no room for auto-growth. Where are you expecting an autogrowth to expand to?

    So if tempdb now does need to grow for whatever reason, and it causes a SQL issue because it can't, you've guaranteed that there's no easy way to recover, since the current physical files absolutely can't be expanded?

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.