SQL Server Performance Settings

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

---

Overview/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.

Target Audience
SQL Server database administrators and application developers

Prerequisites
None

Expected Duration (hours)
1.3

Lesson Objectives

SQL Server 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

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

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

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

optimize SQL Server 2016 database performance

Course Number:
df_sqlp_a07_it_enus

Expertise Level
Intermediate