Microsoft SQL Server 2016: Monitoring Database Activity and Queries

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

start the course

recognize the types of activities that can be monitored using Activity Monitor

use Activity Monitor in SQL Server Management Studio to monitor database activity

identify blocks using Activity Monitor and stored procedures

describe the role of the data collector

describe the components that make up the data collection system

configure the data collector

use System Monitor to monitor resource usage

describe the purpose of utility control point and the requirements for its use

use the Create UCP wizard to create a SQL Server utility control point

complete the creation of a SQL Server utility control point

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

Course Number:
df_sqla_a07_it_enus

Expertise Level
Intermediate