Tempdb file sizing

  • Need some recommendation on sizing of tempdb files for the following specs:

    •Two SAN drives - 400gb each have been assigned for the tempdb files.

    •8 Intel XEON core process – E7- 8870

    •10 databases

    •Big database size is approximately 581 gb.

  • Not enough information.

    How much TempDB space does the application that uses those databases require? That's the minimum that TempDB should be.

    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
  • Thanks Shaw for the tip. I will try that out.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply