• Online, Self-Paced
Course Description

SQL Server 2016 offers various tools to tune a SQL Server environment for peak performance. This course covers how to maximize database performance as well as the maximum amount of server memory. In addition, this course covers how to configure operators and alerts in SQL Server 2016. This course is one of a series of courses that cover the objectives for the 70-765: Provisioning SQL Databases exam.

Learning Objectives

Database Performance Settings

  • start the course
  • describe how to evaluate and tune database performance
  • demonstrate how to improve performance by changing service tiers
  • configure elastic database pools to scale resources automatically
  • configure the database scope in SQL Server 2016

Configuring Server Memory

  • demonstrate how to configure memory options including min server memory and max server memory
  • demonstrate how to configure and view memory options using T-SQL
  • describe the three approaches you can use to manage memory when running multiple instances of the database engine

Configuring SQL Server Operators

  • describe the role of operators in SQL Server 2016
  • demonstrate how to create an operator in SQL Server 2016
  • perform the necessary steps to delete an operator in SQL Server 2016
  • demonstrate how to configure operator availability in SQL Server 2016
  • edit an existing operator in SQL Server 2016
  • access and view operator information in SQL Server 2016
  • demonstrate how to designate a fail-safe operator in SQL Server 2016

Configuring Alerts in SQL Server 2016

  • configure alerts based on monitoring metrics in SQL Server 2016
  • create an alert rule on a metric within the Azure portal
  • assign alerts to an operator in SQL Server 2016
  • manage alerts in SQL Server 2016

Practice: Optimizing Performance

  • optimize SQL Server 2016 database performance

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.