I am so excited to announce that I am presenting a full day of Query Store Training, in-person, this September in Lisbon, Portugal! The SQLskills team will be in London for two weeks in September for a set of Immersion Events (IEPTO1, IEAzure, IECAG, and IEPTO2). After I’ve finished my teaching for IEPTO2 I’m heading over to Lisbon for a full day (Friday, September 21, 2018) on Query Store in advance of SQLSaturday Portugal.
This workshop has continued to evolve since its first inception at the PASS Summit last fall – specifically, I’ve added more content around performance and workload analysis, but every time I get asked a new question that I think is relevant or interesting, it gets added into a slide or demo. You can read the full abstract below, and can purchase your ticket here, and if you have any questions about the workshop please email me or post a comment!
*Note: If you’re interested in the Immersion Events listed above, please know that we probably won’t offer them in Europe again until 2020, so if you’re interested please talk to your manager and get signed up. We would love to see you!
Using Query Store to Easily Troubleshoot and Stabilize Your Workload
– Have you upgraded to SQL Server 2016 or higher, but still have databases using the old Cardinality Estimator?
– Do you know that you have queries with inconsistent performance, but you’re just not sure how to find them, or fix them, quickly?
– Are you tired of flailing around in SQL Server, querying DMV after DMV to figure out the *real* problem with performance?
Query Store can help.
We’ll cover Query Store end-to-end in this full day workshop built using real-world examples based on customer issues resolved over the last two years. You’ll understand how to configure it, what data it captures, and how to use it to analyze performance, find regressions, and force plans. The demos will teach you how to find common patterns in query performance using T-SQL, and how to understand your workload.
This class is applicable for those running SQL Server 2016 or higher (or planning to upgrade), or Azure SQL Database, and will provide practical and applicable information you can use whether you’re a new or veteran DBA, a developer that has to troubleshoot query performance, or an application administrator just trying to keep the system afloat. You’ll learn how to find and leverage important information in Query Store to make solving common performance problems easier the moment you walk back into the office.