August 1, 2018 at 3:39 am
hi ,
my queation is if want to configre temp db file to cpu 1 to 1 ( just for testing... best prectice is 8 as i know)
i read this sentence : tempdb should always have one data file per processor core from this link :
https://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1230-tempdb-should-always-have-one-data-file-per-processor-core/
what will be the correct value from the attach files for this current server ?? ... its little bit confused me 🙂
thank you vary much .
August 1, 2018 at 5:31 am
As Paul said, don't ever configure 1 file for 1 core by default. Read that blog post, it's still pretty much what's recommended.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply