Your SQL Server virtual machines, whether in your own datacenter or in the cloud, should perform as fast as a bare metal server. If not properly constructed and managed, however, the performance of these critical servers can suffer. The different areas of the VM architecture and performance, such as virtual CPU architecture and NUMA, disk presentation and configuration, memory management, and differences between cloud and on-prem SQL Server VMs, will be explored in this demo-packed session.
This session is packed with many tips and tricks gained from years of experience for getting the most performance from your virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure engineers so you can optimize the system stack for performance. Tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.
David Klee is a Microsoft MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise are virtualization and performance, datacenter architecture, and risk mitigation through high availability and disaster recovery. When he is not geeking out on technologies, David is an aspiring amateur photographer. You can read his blogs at heraflux.com and davidklee.net, and reach him on Twitter at @kleegeek.