SQL Server's Best Kept Secret, Query Store
- This session explores the SQL Server Query Store feature with a focus on performance tuning, configuration, and best practices.
- It is aimed at database professionals or operators seeking to troubleshoot and optimize their query performance.
- Attendees will learn practical tips and advanced techniques to enhance their use of Query Store.
About this event
Query Store is one of the best performance tuning features in SQL Server, yet many organizations still aren't using it. Whether you're completely new to Query Store or already have it enabled, there's a lot more to it than just capturing query history.
Amy Abel will cover the pros and cons of Query Store, configuration options, and best practices for getting the most value from it. You'll learn how Query Store can help you troubleshoot performance issues faster, identify problem queries, and track plan changes over time.
Already using Query Store? I'll also share some lesser-known tips and tricks, hidden gems, and practical techniques that many SQL Server professionals don't realize exist.
If you've never used Query Store, you'll leave knowing why you should. If you already use it, you'll leave knowing how to use it even better.