Monitoring Queries

SQL 2016    |    Intermediate
  • 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
    FREE ACCESS
  • Locked
    4. 
    Creating an Extended Events Session
    8m 23s
    FREE ACCESS
  • Locked
    5. 
    Troubleshooting with Extended Events
    7m 3s
    FREE ACCESS
  • Locked
    6. 
    SQL Trace
    6m 10s
    FREE ACCESS
  • Locked
    7. 
    Using SQL Trace
    6m 16s
    FREE ACCESS
  • Locked
    8. 
    Identifying Execution Plan Issues
    7m 26s
    FREE ACCESS
  • Locked
    9. 
    Exercise: Monitoring Activity in SQL Server 2016
    5m 27s
    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 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 Azure Data Fundamentals: Azure SQL Querying Techniques
Likes 0 Likes 0  
COURSE Auditing
Likes 39 Likes 39  
COURSE Microsoft Azure Architect Design: Azure Monitoring
Likes 31 Likes 31  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Backup Management
Likes 75 Likes 75  
COURSE Log Shipping & High Availability
Likes 34 Likes 34  
COURSE Data Security & Azure SQL Database Options
Likes 49 Likes 49