Tag: Tempdb Split

“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…