Database Instances


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


Overview/Description
SQL Server Resource Governor is a feature used to manage SQL Server workloads and resource consumption by specifying limits on resources such as CPU, IO, and memory. This course covers the Resource Governor and the cloud database service, Microsoft Azure Cloud SQL Database. In addition, monitoring and troubleshooting database instances is also covered. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.

Target Audience
Database professionals responsible for implementing and maintaining SQL Server 2016.

Prerequisites
None

Expected Duration (hours)
2.2

Lesson Objectives

Database Instances

  • start the course
  • describe workloads
  • manage workloads and system resource consumption using Resource Governor
  • enable Resource Governor
  • configure Resource Governor properties
  • create a resource pool
  • create a workload group
  • disable Resource Governor
  • optimize memory configuration
  • describe service tiers
  • describe common service tier use cases
  • describe elastic database pools
  • describe elastic scaling
  • optimize tempdb configuration files
  • demonstrate how to create an Azure SQL Server 2016 database
  • demonstrate how to connect to an Azure SQL Server 2016 database
  • describe the data collector service for monitoring SQL Server 2016 databases
  • enable and configure a management data warehouse for the data collector service
  • configure a data collection
  • monitor and diagnose scheduling and wait statistics using dynamic management objects
  • troubleshoot storage, IO, and cache issues
  • demonstrate how to monitor Azure SQL Database query plans
  • demonstrate how to use the SQL Server Monitor

    • Course Number:
    df_sqld_a09_it_enus

    Expertise Level
    Intermediate