I am not sure what does it means :
for example, currently I have 8 tempdb files and I have 16Cores , when I see contention on tempdb , i need to set 32 (8x4) tempdb files ????

I am not sure what does it means :
for example, currently I have 8 tempdb files and I have 16Cores , when I see contention on tempdb , i need to set 32 (8x4) tempdb files ????

Hi sakuraime,
No. If your system has more than 8 logical processors, start with 8 data files and monitor your server’s workload to determine if more data files would be beneficial. If you do find that an increase is warranted, add 4 data files at a time, but do not add more than the number of logical processors. Please refer to How Many tempdb Data Files Should My SQL Server Have?
The current best advice around adding tempdb data files is enshrined in KB article 2154845.
If the response helped, do "Accept Answer" and upvote it.
Best regards,
Cathy
Hi @sakuraime ,
Any update for this thread? Did the reply could help you? If the response helped, do "Accept Answer" .
Best regards,
Cathy
This is only important if you are having tempdb contention.
Are you having tempdb contention?
2 people are following this question.