question

sakuraime avatar image
0 Votes"
sakuraime asked TomPhillips-1744 answered

tempdb file number for many logical processor

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 ????


19658-image.png




sql-server-general
image.png (53.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered NishitaNambiar-0547 commented

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


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @sakuraime ,

Any update for this thread? Did the reply could help you? If the response helped, do "Accept Answer" .

Best regards,
Cathy

0 Votes 0 ·

Thank you for the comment

0 Votes 0 ·
TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered

This is only important if you are having tempdb contention.

Are you having tempdb contention?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.