Abstract
At SDC-2011 we announced the new SQL Server version code-named ‘Denali’, and showed the engineering work involved in getting SQL Server to run over a file access protocol like SMB. A year later, we have lots of additional information to share on the application and data workloads that SQL Server generates. We’ll discuss how you can use this data to design your storage products, regardless of whether they are SAN-attached block storage arrays or file servers accessed via the SMB 3.0 protocol. We will demonstrate SQL Server running in various configurations to show scale-up, scale-out, and fail-over capabilities. The latter part of this presentation will show significant performance data from SQL Server running on various systems, with emphasis on SMB 3.0 and SMB-Direct (RDMA).
Learning Objectives
Understand the application workload characteristics of SQL Server.
Understand how SQL Server accesses file-based storage, using the SMB protocol family.
Understand how SQL Server performance data can help you design storage systems that are more performant with this important workload.