SQL Server Performance

TempDB

Discussion in 'Performance Tuning for DBAs' started by Jackson, Sep 6, 2008.

  1. Jackson New Member

    HI,
    Can somebody tell that how many data file can we assign to TEMPDB Database?
    Thanks
  2. Luis Martin Moderator

    There is no absolutes.If you have space, I suggest 2GB.
  3. preethi Member

    My Suggestion would be MAX(Number of CPUs, Number of Hard disks). Some suggest to go one less than the value. Again there is no absolute value. It depends mainly on the operational need.

Share This Page