The DBA will have a major influence for the design team given the deeper working knowledge of the SQL Server features beyond the core infrastructure. It is essential to understand the architecture for the storage system, hardware usage, and SQL Server abilities that will help us understand the business needs and design to meet the business requirements.
To reduce the bottle necks on the storage system, it is important to measure the disk throughput, which in turn helps the data transfer rate through an I/O subsystem. This is the main function for SQL Server scalability that manipulates data that resides in the memory or disk I/O, and any bottleneck on these areas will result in performance degradation of the SQL Server. There are many vendors available there to perform a certain level of benchmarking for their SAN products that can give us the benefit of required configuration for better performance.
In this recipe, we will go through the...