Analyzing Query Plans

SQL Server 2016    |    Intermediate
  • 9 videos | 50m 24s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 44 users Rating 4.6 of 44 users (44)
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

  • 8m 15s
    In this video, you will capture query plans using extended events and traces. FREE ACCESS
  • 4m 34s
    After completing this video, you will be able to describe logical operators and how to use them. FREE ACCESS
  • Locked
    3.  Physical Operators
    6m 53s
    After completing this video, you will be able to describe physical operators and how to use them. FREE ACCESS
  • Locked
    4.  Query Store Best Practices
    6m 53s
    After completing this video, you will be able to recognize best practices to follow with the Query Store. FREE ACCESS
  • Locked
    5.  Query Store Usage Scenarios
    3m 12s
    Upon completion of this video, you will be able to describe when and where to use the Query Store. FREE ACCESS
  • Locked
    6.  Query Performance Troubleshooting
    2m 38s
    In this video, you will learn how to start query performance troubleshooting. FREE ACCESS
  • Locked
    7.  Query Plan Operator Performance
    3m 8s
    During this video, you will learn how to identify query plan operators that are not performing well. FREE ACCESS
  • Locked
    8.  Reviewing Query Results
    7m 22s
    Learn how to compare query plans and related metadata. FREE ACCESS
  • Locked
    9.  Azure SQL Database Performance Insight
    7m 29s
    Find out how to configure Azure SQL Database Performance Insight. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries
Book SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance, 6th Edition
Journey Analyze Data with SQL
Rating 4.8 of 12 users Rating 4.8 of 12 users (12)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Designing & Implementing Views
Rating 4.6 of 70 users Rating 4.6 of 70 users (70)
Course Database Instance Performance
Rating 4.7 of 47 users Rating 4.7 of 47 users (47)
Course Isolation Levels
Rating 4.5 of 31 users Rating 4.5 of 31 users (31)