Home Forums SQL Server 2005 Administering Provisioning SQL disk on a Compellent SAN RE: Provisioning SQL disk on a Compellent SAN

  • May 27, 2011 at 6:48 pm

    #1331275

    Michael Valentine Jones (5/27/2011)

    Paul Randal address the whole tempdb data file per processor core story here:

    A SQL Server DBA myth a day: (12/30) tempdb should always have one data file per processor core

    http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(1230)-tempdb-should-always-have-one-data-file-per-processor-core.aspx

    Been there, done that. It's one of many, many articles out there on this subject.

    The truth is, just about every database server can benefit from a few TempDb data files. How many? How big? On different LUNs or disks?

    It all depends. You have to experiment.

    LC