Fly Girl (7/9/2012)
From what I've been learning in my reluctant dba-dom on this contract, tempdb files equaling the count of processors/cores is in line with best practices.
Not really. On larger servers it's overkill usually. I like to start with 1/4 the number of cores (no more than 8) and that's assuming I've seen allocation contention and then increase as necessary.
It's one of those areas where everyone has their own 'best practice' and they usually don't agree with each other.
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass