Monitoring Queries

SQL 2016    |    Intermediate
  • 9 videos | 59m 52s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 29 users Rating 4.4 of 29 users (29)
An enterprise database infrastructure has a lot of moving pieces, and it's crucial that they be monitored. Explore SQL Server database queries, including the Query Store, Extended Events, SQL Trace, and troubleshooting server health.

WHAT YOU WILL LEARN

  • Describe the purpose of the query store, its features, and configuration options
    Describe scenarios for using the query store
    Describe the features, benefits, and architecture of performance monitoring with extended events
    Create an extended events session
    Recognize how extended events can be used to troubleshoot performance issues
  • Describe the features, benefits, and architecture of sql trace
    Describe the uses of sql trace
    Identify issues with execution plans
    Monitor database activity in sql server 2016

IN THIS COURSE

  • 7m 42s
    After completing this video, you will be able to describe the purpose of the Query Store, its features, and its configuration options. FREE ACCESS
  • 6m 7s
    After completing this video, you will be able to describe scenarios for using the Query Store. FREE ACCESS
  • Locked
    3.  Monitoring Performance Using Extended Events
    5m 16s
    After completing this video, you will be able to describe the features, benefits, and architecture of performance monitoring with Extended Events. FREE ACCESS
  • Locked
    4.  Creating an Extended Events Session
    8m 23s
    In this video, you will learn how to create an Extended Events session. FREE ACCESS
  • Locked
    5.  Troubleshooting with Extended Events
    7m 3s
    After completing this video, you will be able to recognize how Extended Events can be used to troubleshoot performance issues. FREE ACCESS
  • Locked
    6.  SQL Trace
    6m 10s
    After completing this video, you will be able to describe the features, benefits, and architecture of SQL Server Trace. FREE ACCESS
  • Locked
    7.  Using SQL Trace
    6m 16s
    Upon completion of this video, you will be able to describe the uses of SQL Trace. FREE ACCESS
  • Locked
    8.  Identifying Execution Plan Issues
    7m 26s
    Find out how to identify issues with execution plans. FREE ACCESS
  • Locked
    9.  Exercise: Monitoring Activity in SQL Server 2016
    5m 27s
    Learn how to monitor database activity in SQL Server 2016. 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

Course Queries in Snowflake: Getting Started with Performance Optimizations
Rating 4.6 of 51 users Rating 4.6 of 51 users (51)
Course Working with Google Cloud SQL: An Introduction to Cloud SQL
Rating 4.7 of 37 users Rating 4.7 of 37 users (37)
Book Database Performance at Scale: A Practical Guide

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Loading & Visualization in Power BI: Getting Started
Rating 4.7 of 3 users Rating 4.7 of 3 users (3)
Course Policy-based Management & Performance Monitoring
Rating 4.7 of 15 users Rating 4.7 of 15 users (15)
Course Filtering Data
Rating 4.5 of 86 users Rating 4.5 of 86 users (86)