Microsoft SQL Server 2016: Monitoring Database Activity and Queries

Database administrators and database professionals

Prerequisite
None

Expected Duration
130 minutes

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.

Objective

Monitoring Database Activity

  • 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

Working with the Data Collector

  • 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

Monitoring Queries

  • 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

Practice: Monitoring Database Activity

  • monitor database activity in SQL Server 2016

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.