SQL Server Performance


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

  1. Jackson New Member

    Can somebody tell that how many data file can we assign to TEMPDB Database?
  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