PASS logo

November 15-18

Seattle & online

2021 Summit video library

Virtual SQL Server Performance for the DBA

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.