Azure SQL Database: Improving Performance Tuning with Automatic Tuning | Data Exposed: MVP Edition

From the creator

One of the performance benefits of using Azure SQL Database is the ability for Azure SQL Database to automatically add and remove indexes from the database, based on the workload that is running against the database. Join Denny Cherry as he shows you how to enable automatic tuning and when it won’t help you as much as you think that it will. 0:00 Introduction 1:25 Automatic tuning features 3:08 Indexes 3:40 Automatic tuning demo 4:40 When to use this feature 6:30 What indexes should be made ✔️ Resources: Enable automatic tuning in the Azure portal:https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-enable?WT.mc_id=dataexposed-c9-niner Email notifications for automatic tuning: https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-email-notifications-configure?WT.mc_id=dataexposed-c9-niner Find and apply performance recommendations: https://docs.microsoft.com/en-us/azure/azure-sql/database/database-advisor-find-recommendations-portal?WT.mc_id=dataexposed-c9-niner About Denny Cherry: Denny Cherry is the owner and principal consultant for Denny Cherry & Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related

Published 2020-11-24 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.