O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Managing a storage system for analyzing bottlenecks

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required