Discussion in 'Performance Tuning for DBAs' started by Jackson, Sep 6, 2008.
Can somebody tell that how many data file can we assign to TEMPDB Database?
There is no absolutes.If you have space, I suggest 2GB.
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.
Separate names with a comma.