• Split SQL TempDB per number of Processor Core

    To achieve optimal tempdb performance, create multiple tempdb data file per processor core and limit the number of tempdb data files up to 8 if you have more than 8 CPU core. Key benefit of creating multiple tempdb per core is it enables SQL to split the I/O transactions across each data files and also […]
    • by
    • 5 Years ago
    • 1