March 26, 2018 at 10:56 am
Is there any truth that you should have one file per cpu for tempdb? if yes what is this actually buying me?
March 26, 2018 at 12:23 pm
keanyukas - Monday, March 26, 2018 10:56 AMIs there any truth that you should have one file per cpu for tempdb? if yes what is this actually buying me?
It used to be the recommendation on SQL 2000. Things have changed but the recommendation is still often repeated and not necessarily correct.
The following article explains it more:
A SQL Server DBA myth a day: (12/30) tempdb should always have one data file per processor core
Sue
March 26, 2018 at 12:28 pm
Sue_H - Monday, March 26, 2018 12:23 PMkeanyukas - Monday, March 26, 2018 10:56 AMIs there any truth that you should have one file per cpu for tempdb? if yes what is this actually buying me?It used to be the recommendation on SQL 2000. Things have changed but the recommendation is still often repeated and not necessarily correct.
The following article explains it more:
A SQL Server DBA myth a day: (12/30) tempdb should always have one data file per processor coreSue
Thanks much
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply