SQLskills IEQS - SQL Server 2019
Issued by
SQLskills
This badge shows attendance of the SQLskills Immersion Event on Solving Common Performance Problems with Query Store. Query Store is a game-changer for data professionals; this course shows you how to stop reacting and make query store work for you. Topics covered: query store fundamentals, understanding query store data, finding performance issues, forcing plans, automatic tuning, query store performance, visualizing query store data, and other uses for query store data.
- Type Learning
- Level Advanced
- Time Days
- Cost Paid
Skills
- Analyzing Query Performance
- Appropriate Use Of Query Store For Analyzing Query Quality
- Benefits And Pitfalls Of Plan Forcing With Query Store
- Compare And Contrast Runtime V. Wait Statistics For Query Store Data
- Configuration Of Query Store In SQL Server
- Configuring And Controlling Data Captured By Query Store In SQL Server
- Detecting And Resolving Various Common Performance Issues And Patterns
- Differentiating Between Caching And Statistics Problems And Solving Them Appropriately
- Finding And Troubleshooting Performance Issues Using Query Store
- Identify And Monitor Your Workload Characteristics And Query Store Performance
- Knowledge Of I/O Concepts And I/O Subsystems For SQL Server
- Leverage The Data In Query Store To Find Patterns In Code
- Leverage The Data In Query Store To Find Potential Problems Tied To Query Plans And Cardinality Estimation
- Leverage The Data In Query Store To Mitigate Upgrade Issues
- Optimizing Procedural Code And Resolving Parameter Sensitivity Problems
- Requirements Of Query Store In SQL Server
- Resolving Statement Execution Caching Problems
- SQL Server Internals
- Using Intelligent Database: Automatic Index Management
- Using Intelligent Database: Automatic Plan Correction
- Visualizing Query Store Data