Home Forums SQL Server 2012 SQL 2012 - General Splitting TempDB - What's your experience? RE: Splitting TempDB - What's your experience?

  • May 21, 2015 at 7:57 am

    #1799682

    TheSQLGuru (5/21/2015)

    Since it wasn't mentioned in the original post I had assumed that temp object allocation wasn't an issue.

    These are brand new (and very beefy) servers for upgrading SQL 2008 to 2012. Our corporate servers current have tempdb split into multiple files, but then corporate installed these servers and their ways are Strange and Mysterious.

    We now have our own servers and are installing them ourselves. I want to make sure we get it right, but my boss is against the idea of splitting tempdb up unless we absolutely have to. I'm hoping I can use Gail's recommendation and explanation to discuss this more fully.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.