Want to split the TempDB to match with my SQL server configuration. I have two quad-core processors and split it with 1 .mdf file and 7 .ndf files. However, what's the best place to place this file and the size for each file ?
Current the SQL
OS ( 2 x RAID1 15000RPM)
SQL Log (4 x RAID10 15000RPM)
SQL Database ( 6 x RAID 10 SSD)