Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
- Describe performance monitoring
After completing this module, you will be able to:
- Review potential performance issues.
- Identify critical Azure metrics.
- Learn how to collect metrics for an established baseline.
- Use extended events for performance analysis.
- Understand database watcher for Azure SQL Database and Azure SQL Managed Instance.
- Configure SQL Server resources for optimal performance
After completing this module, you will be able to:
- Understand your options for configuration of Azure storage
- Learn how to configure TempDB data files in SQL Server
- Learn how to choose the right type of VM for SQL Server workloads
- Understand the use cases and configuration of Resource Governor in SQL Server
- Configure databases for optimal performance
After completing this module, you will be able to:
- Understand database scoped configuration options
- Understand maintenance tasks related to indexing and statistics
- Understand the features of Intelligent Query Processing (IQP)
- Explore the automatic tuning feature in Azure
