© Benjamin Nevarez 2021
B. NevarezHigh Performance SQL Serverhttps://doi.org/10.1007/978-1-4842-6491-1_11

11. SQL Server Storage

Benjamin Nevarez1  
Santa Clarita, CA, USA

This chapter covers storage from the SQL Server point of view, and although other factors such as availability and recoverability play a very important role in selecting and configuring storage, we focus mostly on performance. Disk is traditionally the slowest component in a database system, so tuning storage for performance is essential and usually comes in two high-level areas: directly tuning the storage and tuning the components to make efficient use of the storage. The first area refers to tuning and configuring the storage hardware itself, while the second one relates ...

Get High Performance SQL Server: Consistent Response for Mission-Critical Applications now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.