SESSION Details

Finding Problems and Stabilizing Performance with Query Store

As a data professional you often get pulled in to troubleshoot a drop in performance, and it can be stressful. Then, when you figure out the issue, people want you to fix it...immediately. But what if you need to change a query or the schema and you don't have direct code access? Or even if you do, you have to go through a change control process which can take hours or days, and you don't know when performance will tank again.

Did you know that Query Store can not only help you find problematic queries, but it can also help you manage query performance, *without* changing the schema or the code?
Whether you have SQL Server on-premises, in the cloud on a VM, or you use Azure SQL Database, Query Store is a tool you can use for troubleshooting and monitoring, as well as stabilizing query performance.

In this full day workshop, built using real-world examples based on customer issues resolved over the last 5 years, we will cover Query Story end to end, top to bottom. Topics include:

• Configuration best practices
• Considerations related to performance
• Using Query Store to find your problem queries
• Plan forcing (manual and automatic)
• How to leverage Query Store for upgrades
• How to determine if a different compatibility mode or Cardinality Estimator model benefits your workload, based on Query Store data
• How Query Store Hints and Intelligent Query Processing (IQP) features can stabilize query performance

Expect discussion, a lot of demos, and practical knowledge that you can apply to your environment the moment you turn on Query Store.

Feedback link: https://sqlb.it/?7154

Starts: 09:00 9th Mar 2022
Ends: 17:00 9th Mar 2022

Q&As

Short Description
- In this workshop you'll learn how to leverage Query Store to its full extent - from finding problems, forcing plans, and understanding all the new capabilities it will support in SQL Server 2022.
Should delegates bring a laptop with them?
- They can, if they want to try and follow along with demos, but it is not required.
If so what Spec?
- Optional: Whatever is needed to run SQL Server (4GB of memory, 2vCPU).
What software and licences do they need?
- Optional: SQL Server Developer Edition
What is the structure of the day?
- The workshop has teaching, demos, and discussion. The format is usually teaching, then a demo to illustrate what was taught, with time for questions during and after the demo (where discussion also occurs). Topic covered include: configuration, performance considerations, plan forcing (manual and automatic), QS hints, mining QS data, and anything new in 2022 that's shareable.
What internet requirements do the delegates have?
- None.
What will the delegates get out of the day?
- They will walk out armed with all they need to start using Query Store in their environment, including understanding the requirements based on their workload, how to configure it, performance considerations, how to find problems, how to force plans, how to mine all the data, and then anything I can share related to new functionality.

Speakers

Erin Stellato

Tags

AzureOn PremisesFuture DBAOperational DatabasesMonitoringOptimisingAzure SQL DatabaseDatabase EngineQuery StoreSQL 2019SQL 2022IntermediateHow

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference

Previous
Next

Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.