SQLskills IEPTO2 - SQL Server 2019
Issued by
SQLskills
This badge shows attendance of the SQLskills Immersion Event on Performance Tuning and Optimization – Part 2. This course dives into workload analysis, troubleshooting, and tuning. Topics covered: wait statistics, query store, troubleshooting caching / statistics, CPU troubleshooting, memory troubleshooting, analyzing query performance, extended events, and troubleshooting I/O. IEPTO2 gives you the understanding of what tool to use for the job and to figure out what's *REALLY* going on!
- Type Learning
- Level Advanced
- Time Days
- Cost Paid
Skills
- Analyzing And Troubleshooting SQL Server Deadlocks
- Analyzing Query Performance
- Appropriate Use Of Query Store For Analyzing Query Quality
- Detecting And Resolving Various Common Performance Issues And Patterns
- Differentiating Between Caching And Statistics Problems And Solving Them Appropriately
- Effectively Using Dynamic Management Views (DMVs) For Troubleshooting
- Knowledge Of I/O Concepts And I/O Subsystems For SQL Server
- Knowledge Of SQLOS Scheduling And CPU Performance Tuning
- Optimizing Procedural Code And Resolving Parameter Sensitivity Problems
- Resolving Statement Execution Caching Problems
- SQL Server Database Structures
- SQL Server Internals
- SQL Server Locking
- Using Extended Events For Extracting And Analyzing SQL Server Activity Efficiently
- Using Wait Statistics For Troubleshooting