These best practices apply to creating the Microsoft SQL Server database layer:
- Use multiple data files on different virtual disks within the same filegroup.
- Allocate multiple tempdb data files to address tempdb contention issues. For more information, see Recommendations to reduce allocation contention in Microsoft SQL Server tempdb database. For our study, we allocated eight files that were dedicated for tempdb.
- Segregate database data files and database log files on separate drives that are mapped to dedicated virtual disks. For our study, we created three data files and one log file on dedicated drives.