Database Server
-
Microsoft SQL Server
NOTE: Use Table Partitioning (requires SQL Server version that supports Table Partitioning, such as Enterprise, Azure or SQL Standard version 2017 or higher)
-
Transaction logs and data at a minimum should be stored on separate drives to spread I/O across drives. For more advanced configurations and improved throughput, create additional File Groups to spread I/O across devices.