(this is an on-demand video)
Sponsored by - Quest
Join Jason Hall and Anat Dror for a repeat performance of their PASS Summit 2016 session to learn insightful tips on what to monitor, when to use it and how best to leverage the data it is collecting.
With SQL Server 2016, Microsoft introduced the Query Store, which promised to track statement performance over time, pinpoint regressed queries and provide a more effective way to tune. In this informative and insightful session we will look at the good, the bad and the ugly of Query Store. How well does it actually work? What if your database is read only? What if you have lots of databases to monitor? How does it handle plan changes due to schema changes? Join Anat Dror and Jason Hall, Quest SQL Server experts to explore both the limitations and the sweet spot for using Query Store and discover insightful tips on what to monitor, when to use it and how best to leverage the data it is collecting.
Peter O Connell will then demonstrate how you can use Spotlight Developer and its newly released Tuning Pack to deliver a stress free route to SQL tuning. The Plan Viewer charts the route that SQL Server has chosen for you and highlights any congestion points in the plan by pointing out the most expensive nodes. The all new Tuning Pack takes this a step further and acts as your GPS to automatically scan all the possible “routes” that could be taken and recommends the ultimate path to complete your query in the fastest time possible.
Register for this webcast today and receive the free Spotlight Developer plugin for SQL Server Management Studio. AND - all attendees will get a free six month subscription to the new Tuning Pack!
Jason Hall is a Solutions Architect for Dell Software focusing on database management and business intelligence solutions. Specific area’s of expertise include monitoring, diagnostics, disaster recovery, high availability, and performance tuning. Jason has worked with hundreds of customers to help architect and implement database driven solutions and has been a frequent presenter at various user groups and conferences.
To access materials please fill out the form below.