Jeff Kelly-310227 (12/5/2012)
Are there a recommended number of files per Filegroup –some mathematical formula to # of cores/etc…?We understand that typically multiple files are used to spread out the load across different disks but in our case all these disks are the same ‘set’.
This is a Tempdb optimisation technique and not really relevant here. As Gail has explained for better IO throughput you could use multiple files per filegroup, but you have to remember that SQL server will attempt to stripe the files and has to switch between these files and maintain fill stats to support the proportional fill algorithm. As you stated, you don't have the disk setup to support this. In my opinion it's totally unnecessary.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉