PearlJammer1 (11/28/2014)
The other reason for this question is that I currently only have 1 TEMPDB file and I need to increase the number to reduce TEMPDB contention - and I believe that the marker for the amount required starts with the logical cpu count.
It does not.
That it does is a myth based on a not-great Microsoft recommendation from about 10 years ago.
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