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 ]

  • we are currently having 8 tempdb files ,

    we feel that database performance issues happening and alternative for this to solve by adding more tempdb and reduce the load on the server

    -- what we want to know is for 64 core cpus machine how many number of tempdb files is max suggestable

    Thanks
    Naga.Rohitkumar