Monitoring Queries

SQL 2016
  • 9 Videos | 1h 3m 52s
  • Includes Assessment
  • Earns a Badge
Likes 28 Likes 28
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

  • Playable
    1. 
    The Query Store
    7m 42s
    UP NEXT
  • Playable
    2. 
    Query Store Usage
    6m 7s
  • Locked
    3. 
    Monitoring Performance Using Extended Events
    5m 16s
  • Locked
    4. 
    Creating an Extended Events Session
    8m 23s
  • Locked
    5. 
    Troubleshooting with Extended Events
    7m 3s
  • Locked
    6. 
    SQL Trace
    6m 10s
  • Locked
    7. 
    Using SQL Trace
    6m 16s
  • Locked
    8. 
    Identifying Execution Plan Issues
    7m 26s
  • Locked
    9. 
    Exercise: Monitoring Activity in SQL Server 2016
    5m 27s

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

COURSE Auditing
Likes 39 Likes 39  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 75 Likes 75  
Likes 27 Likes 27  
Likes 49 Likes 49