Home Forums SQL Server 2005 Administering how many additional tempdb files can we add [max limit of tempd files ] RE: how many additional tempdb files can we add [max limit of tempd files ]

  • August 30, 2016 at 4:57 am

    #1898261

    The max number of TempDB files is 32767.

    Why are you considering increasing the number of TempDB files? What problems are you trying to address?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass