The scalability and performance is guaranteed when the reliable storage is configured at the hardware level. In general, the storage configuration and management is handled by the Storage Administrators and it is a compulsory exercise for an organization to involve DBAs at configuration level that will shape up a well-built database server on hardware perspectives.
The reliability characteristics and performance implications depend on the RAID configuration, and in this chapter we will go through the best practice layout in configuring a server storage system for scalability. When deploying a new SQL Server instance or performing a scale-out exercise of an existing SQL Server platform, it is important to have an overall understanding of the key file types that are essential for a database. The file type's workload along with the database type and size enables both storage administrators and DBAs to establish necessary storage requirements...