Managing Azure SQL Server Database Performance
Managing and tuning SQL database performance requires expertise and can be time-consuming. This course will explain to you how you can leverage Azure services and features to perform these tasks in a smooth, effortless, and easy way.
What you'll learn
When we talk about managing and tuning database performance, we know that these tasks used to require expertise and used to be time-consuming. Sometimes we would not achieve the best results in our first, or even second, or third attempt to fix the performance issue. In this course, Managing Azure SQL Server Database Performance, you will gain the ability to leverage Azure services and features to help you to manage and tune the performance of your Azure SQL databases without requiring expertise and significant efforts from you. These services and features are leveraging Azure Engineers team and artificial intelligence to perform these tasks for you and remove the responsibility from you to perform them. First, you will discover the different hosting options you have available in Azure to host your SQL databases. Next, you will learn the different services and features you have available to allow you to monitor and troubleshoot issues in your databases. Finally, you will explore how to use features, such as Performance Recommendations and Automatic Tuning. When you’re finished with this course, you will have the skills and knowledge of using Azure services and features to manage and tune the performance of your Azure SQL databases.
Table of contents
- Introduction 1m
- On-premises vs. PaaS Model for Database Monitoring and Troubleshooting 3m
- Metrics and Diagnostics Logging 7m
- Using Query Performance Insight for Basic Monitoring 2m
- Demo: Using Query Performance Insights 3m
- Using Azure SQL Analytics for Advanced Monitoring 6m
- Demo: Using Azure SQL Analytics 6m
- Overview 1m