Microsoft SQL Server 2016: Monitoring SQL Server Instances

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description
Regularly monitoring your SQL Server instances helps you to identify and correct issues before they cause damage and provides valuable insight for performance tuning. This course teaches you about monitoring SQL Server 2016 instances, including creating and managing operators and SQL Server Agent alerts, defining custom alert actions and failure actions, configuring Database Mail and Policy-Based Management, and identifying available space on data volumes and performance degradation. 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.1

Lesson Objectives

Microsoft SQL Server 2016: Monitoring SQL Server Instances

start the course

describe Database Mail, mail profiles, and the importance of security

describe the logging levels and the need for a retention policy in Database Mail

configure Database Mail

recognize the features, benefits, and components of SQL Server Agent

describe the purpose of SQL Server Agent operators, the types of contact methods, and notifications

create a SQL Server Agent operator using SQL Server Management Studio

describe the purpose of SQL Server Agent alerts, how they are triggered, and what they can do

recognize the troubleshooting process for SQL Server Agent alerts and notifications

create SQL Server Agent alerts and configure their actions using SQL Server Management Studio

create alerts that respond to user-defined events

define actions a SQL Server Agent should take in the event of job failure

describe the purpose and components of Policy-Based Management

configure Policy-Based Management properties and failure notification alerts

create a Policy-Based Management policy using SQL Server Management Studio

recognize how to manage an existing Policy-Based Management policy

identify used and available space on data volumes

recognize what affects the performance of a server and when to use baseline measurements

recognize performance issues that may affect SQL Server

monitor instances in SQL Server 2016

Course Number:
df_sqla_a08_it_enus

Expertise Level
Intermediate