The biggest session of this conference for me is presenting a full-day preconference training session called â€œAdvanced Virtual SQL Server Performanceâ€œ as part of the Architecture stream.
Session Abstract: Virtualization is the new norm in datacenters. Even the ubiquitous â€œcloudâ€ is nothing more than virtualized servers in someone elseâ€™s datacenter with advanced automation on top of it. However, just because itâ€™s everywhere doesnâ€™t mean it is implemented and managed correctly. Done incorrectly, your SQL Server performance can take a massive dive. Are your SQL Servers running at their best possible performance?
This full-day boot camp covers all aspects of performance engineering for virtualized SQL Servers. We will review critical topics such as virtualization layers, VM construction, NUMA, resource scheduling, query parallelization and physical server alignment, â€œright-sizing,â€ and storage performance-oriented presentation. Availability and disaster recovery guidelines will also be reviewed. Most importantly, this seminar informs you on methods and terminology to help you work better with your infrastructure team to streamline your critical SQL Server performance. You will understand how to review your critical SQL Servers for both their performance and availability as they relate to the virtualization and physical compute layers underneath, and work with your infrastructure team to implement and streamline any of your findings.
In addition to the preconference training day, I am presenting an abridged technical fire hose session on key topics in a session called â€œVirtual SQL Server Performance Deep Diveâ€œ.Â This session is designed to ramp up attendees on critical (and silent) performance killers in both cloud and on-premises virtual SQL Servers.
Session Abstract: Your business-critical SQL Servers should not suffer from virtualization-related bottlenecks. When properly architected and managed, the principal bottleneck of 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. Items such as CPU scheduling, storage queueing, and memory overcommitment can all penalize database performance, and are tough to identify.
This session is packed with many live examples of tips and tricks gained from years of experience in getting the most performance from your virtual SQL Servers. The major roadblocks to performance will be discussed, and tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.
If youâ€™ve never attended the PASS Summit before, I urge you to go. This conference is the best Microsoft data-platform-centric conference there is, and the information you will gain is second to none. Just look at this list of sessions! The friends you make last a lifetime. The sessions are certain to improve your career and your job. I know wonâ€™t miss it, and I hope to see you there! If you want to meet up and talk shop for a bit, or just hang out, let me know!