Next Meeting: Thursday June 16, 2016
EDMPASS June 16, 2016 David Klee: Virtual SQL Servers, Actual Performance
Event Type: In-Person
Online Meeting URL: None
Virtual SQL Servers, Actual Performance
Category: General Session
Track: Enterprise Database Administration & Deployment
Summary: Virtualizing your SQL Servers should not imply that they will run slower than if they were physical. Properly architected, performance should be equal! Come learn tricks for ensuring that your virtual SQL Servers are performing as fast as possible.
Abstract: Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they were physical. 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.
PreReqs: Attendees should have a basic understanding of virtualization fundamentals, as well as basic knowledge of SQL Server performance benchmarking.
Session Goal 1: Attendees should be able to discuss performance optimization topics with their sysadmins, perform a best-practices check of their virtualized infrastructure, and demonstrate the performance improvements when the best practices are applied.
Session Goal 2: Attendees should be able to return to their own SQL Servers and perform a best practices review to check for top performance. Metrics and methods will be presented that allow the DBA to measure the performance improvements.
Session Goal 3: Attendees should be able 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.
Other Upcoming EDMPass events:
Interested in speaking? We are always looking for new speakers. Don't have a full presentation? Consider a "SQL lightning talk" 10-20 minutes on whatever you like. (ideally SQL, data or professional development related). contact firstname.lastname@example.org
10303 Jasper Avenue
Canadian Western Bank Place - Canadian Room