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