• Online, Self-Paced
Course 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.

Learning Objectives

Database Instance Performance

  • 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

Azure SQL Database

  • 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

Monitoring Database Instances

  • 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

Practice: SQL Server Monitoring

  • demonstrate how to use the SQL Server Monitor

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.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.