Microsoft SQL Server 2016: Monitoring Database Activity and Queries
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level
Overview/Description
An enterprise database infrastructure has a lot of moving pieces, and it's crucial that they be monitored. This course focuses on managing and monitoring SQL Server database activity and queries. Covered topics include monitoring current sessions, identifying sessions that cause blocking activity or consume tempdb resources, configuring a data collector, and creating a utility control point. In addition, it covers query monitoring activities such as managing the Query Store, configuring Extended Events and trace events, identifying problematic execution plans, and troubleshooting server health using Extended Events. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.
Target Audience
Database administrators and database professionals
Prerequisites
None
Expected Duration (hours)
2.2
Lesson Objectives
Microsoft SQL Server 2016: Monitoring Database Activity and Queries
df_sqla_a07_it_enus
Expertise Level
Intermediate