Azure SQL Database: Improving Performance Tuning with Automatic Tuning

Data Exposed (Audio) - Channel 9

Content provided by Data Exposed (Audio) - Channel 9. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Data Exposed (Audio) - Channel 9 or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

4y ago 8:19

MP3•Episode home

Archived series ("Inactive feed" status)

When? This feed was archived on February 22, 2021 15:08 (3+ y ago). Last successful fetch was on January 21, 2021 22:26 (3+ y ago)

Why? Inactive feed status. Our servers were unable to retrieve a valid podcast feed for a sustained period.

What now? You might be able to find a more up-to-date version using the search function. This series will no longer be checked for updates. If you believe this to be in error, please check if the publisher's feed link below is valid and contact support to request the feed be restored or if you have any other concerns about this.

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.
[01:25] Automatic tuning features
[03:08] Indexes
[03:40] Automatic tuning demo
[04:40] When to use this feature
[06:30] What indexes should be made

Resources:
Enable automatic tuning in the Azure portal
Email notifications for automatic tuning
Find and apply performance recommendations

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 to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.

About MVPs:
Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram

43 episodes

#SQL Server #montserrat #Cloud IT #Tech #Industries #Data Science #Science