Monitor and optimize operational resources in SQL Server
- Offered byMicrosoft
Monitor and optimize operational resources in SQL Server at Microsoft Overview
Duration | 3 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 SQL Server at Microsoft Highlights
- Understand how SQL Server and Azure SQL manage currency by locking and blocking, or by using snapshots
- Explore Intelligent Query Processing. Configure Open Source databases for optimum performance
- Explore the automatic tuning features of Azure SQL Database
Monitor and optimize operational resources in SQL Server at Microsoft Course details
- Describe performance monitoring
- Explore causes of performance issues
- Configure SQL Server resources for optimal performance
- Configure databases for performance
- Describe performance-related maintenance tasks in SQL Server
- Hardware and server resources for optimum performance after establishing a baseline
- Understand the purpose of a baseline for comparative analysis
- Explore the Query Store for tracking down problematic queries
- Identify sources of performance problems
Monitor and optimize operational resources in SQL Server at Microsoft Curriculum
MODULE: 1
Describe performance monitoring tools
Describe critical performance metrics
Establish baseline metrics
Describe Azure Intelligent Insights
Exercise: Isolate problems with monitoring
MODULE: 2
Describe SQL Server Query Store
Describe blocking and locking in SQL Server
Describe data file fragmentation
Exercise: Identify and resolve blocking issues
MODULE: 3
Explain how to optimize Azure storage for SQL Server virtual machines
Describe virtual machine resizing
Optimize database storage
Control SQL Server resources
MODULE: 4
Describe database scoped configuration options
Describe intelligent query processing
Describe query store in Azure Database for MySQL and PostgreSQL
Knowledge check
MODULE: 5
Maintain indexes
Maintain statistics
Describe automatic tuning
Exercise: Detect and correct fragmentation issues
Monitor and optimize operational resources in SQL Server at Microsoft Entry Requirements
- Prerequisites: 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 portal
- Experience using Windows Performance Monitor to monitor system components such as CPU, I/O, network traffic
- Knowledge of purpose of SQL Server system databases: master, tempdb, msdb
- Basic understanding of SQL Server file storage
- Basic 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?