Microsoft SQL Server 2016: Monitoring SQL Server Instances

Course Overview

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

Learning Objectives

• 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