- This event has passed.
PASS Summit 2016
October 26, 2016 - October 28, 2016
In addition to the all-day preconference training session prior to the main event, Heraflux is proud to present two general sessions in this year’s PASS Summit.
The first general session is a rapid-fire deep-dive on the virtualization topic for those that cannot make the precon session, entitled “Virtual SQL Servers. Actual Performance.”
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.
More and more Database Professionals are tasked with performing testing and validation of storage devices and surrounding infrastructure to be used for database workloads they support. In this session we will give you all the tools you need to be effective at performing such testing and validation. We will argue pros and cons of synthetic testing. Tools like DiskSpd and VDBench will be discussed, along with SQL Server-specific tools to test real workloads like Distributed Replay and RML utilities. Links to tools and pre-packaged scripts will be provided.