Analyzing Query Plans

SQL Server 2016    |    Intermediate
  • 9 Videos | 54m 54s
  • Includes Assessment
  • Earns a Badge
Likes 21 Likes 21
Optimizing queries can improve the amount of time they take to execute. Discover how to analyze and troubleshoot query plans in SQL Server 2016, and examine Query Store usage scenarios and best practices.

WHAT YOU WILL LEARN

  • capture query plans using extended events and traces
    describe logical operators and how they are used
    describe physical operators and how they are used
    recognize best practices to follow with the Query Store
    describe when and where to use the Query Store
  • determine how to start query performance troubleshooting
    identify underperforming query plan operators
    compare query plans and related metadata
    configure the Azure SQL Database Performance Insight

IN THIS COURSE

  • Playable
    1. 
    Capturing Query Plans
    8m 15s
    UP NEXT
  • Playable
    2. 
    Logical Operators
    4m 34s
  • Locked
    3. 
    Physical Operators
    6m 53s
  • Locked
    4. 
    Query Store Best Practices
    6m 53s
  • Locked
    5. 
    Query Store Usage Scenarios
    3m 12s
  • Locked
    6. 
    Query Performance Troubleshooting
    2m 38s
  • Locked
    7. 
    Query Plan Operator Performance
    3m 8s
  • Locked
    8. 
    Reviewing Query Results
    7m 22s
  • Locked
    9. 
    Azure SQL Database Performance Insight
    7m 29s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 16 Likes 16  
Likes 22 Likes 22  
Likes 40 Likes 40  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Triggers
Likes 32 Likes 32  
COURSE Functions
Likes 26 Likes 26  
Likes 33 Likes 33