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
Specialty Areas
- Data Administration
- Systems Administration
- Systems Development
Feedback
If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.