Virtual SQL Server Performance Tuning by David Klee

Your business-critical SQL Servers should not suffer from infrastructure-related bottlenecks, no matter if it’s on-premises or in the cloud. When properly architected and managed, the principal bottleneck to performance of these SQL Servers should be only limited by code. However, if not properly constructed, silent and seemingly random performance killers can strike and significantly hurt your database performance. Layers like virtualization, cloud IaaS, storage, and networking can all detract from database performance, and they are tough to identify.

This back-to-basics session is packed with many live examples of tips and tricks gained from years of experience for getting the most performance from your physical and virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure teams 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 passion for the convergence of infrastructure, cloud, and database technologies. David spends his days handling performance and HA/DR architecture of mission-critical SQL Servers as the Founder of Heraflux Technologies. His areas of expertise are cloud / virtualization and performance, datacenter architecture, and risk mitigation through high availability and disaster recovery. You can read his blog at davidklee.net, and reach him on Twitter at @kleegeek.