Tag: CPU Cores
-
T-SQL Script to Split Tempdb Data Files with Alignment of the Number of CPU Cores
“One tempdb date file per core” is proved to be a myth by Paul Randal and quoted from his blog it is a conlusion that : “If you have > 8 cores, use 8 files and if you’re seeing in-memory contention, add 4 more files at a time.” Therefore the following script will never set…