Cpt_Picard (3/30/2015)
The OS can only read one data file per core.
This is not true. Any thread on any core can issue an IO request to any file. Please DO NOT go the path of splitting a user database into a number of files = processor cores
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