suggested amount of tempdb


  • Hello,

    I got the new Server with 10 Core processor and have to install the SQL 2016 on it.
    Can somebody clarify for me how many Tempdb files should I create for the best performance? I read several articles. Some of them suggests setup to quantity of cores (10 in my case), some suggests to start with no more than 8 files and suggest start with ½ cores if amount of core exceed 8 (5 in my case)

    Can somebody clarify me with suggested amount of tempdb files?

    Thank you in advance.

    • Edited by alilbas Monday, April 10, 2017 2:58 PM
    Monday, April 10, 2017 2:55 PM

All replies