This is only important if you are having tempdb contention.
Are you having tempdb contention?
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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 ????
This is only important if you are having tempdb contention.
Are you having tempdb contention?
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