Administering Relational Databases on Microsoft Azure (DP-300) Cert Prep: 2 Azure Data Optimization and Automation

Learn the skills to help you pass the Azure and SQL Server components of the Microsoft DP-300 certification exam.

Introduction

• Optimize and automate Azure databases
• What you should know

1. Monitoring Azure Resources

• Review VM performance with Azure Monitor
• Connect to a VM with Remote Desktop
• Create an automated alert
• Collect performance data with Azure Intelligent Insights

2. Optimizing Azure Performance

• Storage configurations for Azure Virtual Machines
• Resizing a virtual machine
• Allocate resources with Resource Governor

3. Optimizing SQL Server Performance

• Database-level performance options
• Intelligent query processing
• Rebuild and reorganize indexes
• Maintain up-to-date statistics

4. Optimizing Query Performance

• Estimated and actual query plans
• Reading a query plan
• Retrieve performance data from the Query Store
• Leverage dynamic management views
• Wait statistics, locks, and blocks
• Automatic index tuning

5. Automate Tasks with SQL Server Agent

• Create an automated maintenance plan
• Automate notifications and alerts
• Monitor queries with extended events

6. Automate Resource Deployment

• Azure Resource Manager templates
• Create a template
• Deploy a template
• Automate with Bicep, PowerShell, and the Azure CLI

Conclusion

• Next steps