SQL Server Performance Settings

SQL Server database administrators and application developers

Prerequisite
None

Expected Duration
77 minutes

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 20765A: Provisioning SQL Databases exam.

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.