• Online, Self-Paced
Course 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.

Learning Objectives

Configuring Database Mail

  • 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

Using SQL Server Agent

  • 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

Configuring Policy-based Management

  • 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

Monitoring Performance

  • 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

Practice: Monitoring Instances

  • monitor instances in SQL Server 2016

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.