troubleshootingsql.com
Misconceptions around –T1118
There has been a lot on debate on whether having the same number of tempdb data files as the number of physical cores help a SQL instance in case you are facing Latch Contention issues on tempdb. T…