Database Reference
In-Depth Information
Figure 6.52 SQL Server SQLIO multiple VM throughput scalability.
Figures 6.49 through 6.52 show different performance profiles of the Nutanix Virtual
Computing Platform for SQL Server VMs based on the “Nutanix SQL Best Practices”
white paper, which includes the detailed configuration and testing details as well as
individual IO pattern scenarios. Because most environments consist of mixed IO
workloads, you should baseline your environment and consider the impact of IO mix
and different IO sizes. The Nutanix platform can coexist with existing storage
investments and offload workloads from existing storage platforms, thus freeing up both
capacity and performance. It is a valid consideration for SQL Databases that fit within
the performance envelope of the scale-out platform.
Summary
Throughout this chapter, we have provided architecture examples based on real-world
projects that you can adapt for your purposes. We've tried to explain all the relevant
considerations and best practices you need to worry about when architecting your
environment for high-performance and critical SQL Server databases. We covered the
key aspects of SQL Server storage architecture for all environments as well as the
differences you need to understand when architecting storage specifically for virtual
SQL Server databases, such as the IO Blender Effect and the way IO queues work
across hosts on the same data store.
We provided guidance on important database storage design principles and a top-down
approach covering SQL Server Database and Guest OS design, Virtual Machine Storage
design, VMware vSphere Storage Design, and then down to the physical storage layers,
 
 
 
Search WWH ::




Custom Search