Monitor and optimize operational resources in Azure SQL
- Offered byMicrosoft
Monitor and optimize operational resources in Azure SQL at Microsoft Overview
Duration | 2 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Monitor and optimize operational resources in Azure SQL at Microsoft Course details
- Describe performance monitoring
- Configure SQL Server resources for optimal performance
- Configure databases for optimal performance
- Configure hardware and server resources for optimum performance after establishing a baseline
- Identify sources of performance problems
- This learning path helps prepare you for Exam DP-300: Administering Microsoft Azure SQL Solutions
- Implement tasks for both IaaS and PaaS to maintain indexes, and statistics
Monitor and optimize operational resources in Azure SQL at Microsoft Curriculum
Describe performance monitoring
Introduction
Describe performance monitoring tools
Describe critical performance metrics
Establish baseline metrics
Explore extended events
Describe Azure SQL Insights
Explore Query Performance Insight
Exercise: Isolate problems with monitoring
Knowledge check
Summary
Configure SQL Server resources for optimal performance
Introduction
Explain how to optimize Azure storage for SQL Server virtual machines
Describe virtual machine resizing
Optimize database storage
Control SQL Server resources
Knowledge check
Summary
Configure databases for optimal performance
Introduction
Explore database maintenance checks
Describe database scoped configuration options
Describe automatic tuning
Describe intelligent query processing
Exercise: Detect and correct fragmentation issues
Knowledge check
Summary
Monitor and optimize operational resources in Azure SQL at Microsoft Entry Requirements
- Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.Experience creating and configuring resources using the Azure portalExperience using Windows Performance Monitor to monitor system components such as CPU, I/O, network trafficKnowledge of purpose of SQL Server system databases: master, tempdb, msdbBasic understanding of SQL Server file storageBasic understanding of structure and usage of SQL Server indexes
- Not mentioned
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?