SQL Server Performance Tuning and Optimization

SQH08 Virtual SQL Servers Actual Performance

12/06/2018

1:00pm - 2:15pm

Level: Intermediate to Advanced

David Klee

Founder

Heraflux Technologies

Virtualizing your business-critical SQL Servers shouldn't imply that they'll run slower than if they were physical, either on-premises or in the cloud. When properly architected and managed, virtual SQL Servers should be equally as fast as their physical counterparts, if not faster. However, if not properly constructed, silent and seemingly random performance killers can strike and significantly hurt your database performance.

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.

You will learn:

  • How to discuss performance optimization topics with sysadmins, perform a best-practices check of your virtualized infrastructure and demonstrate the performance improvements when the best practices are applied
  • How to perform a best practices review of your SQL Server to check for top performance -- metrics and methods will be presented that allow DBAs to measure the performance improvements
  • How to construct a virtualized SQL Server template that contains all of the presented best practices in a ready-to-deploy format to ensure that all future SQL Server VM deployments are configured optimally