Monitor and optimize operational resources in Azure SQL | DP-300 | Video 9 скачать в хорошем качестве

Monitor and optimize operational resources in Azure SQL | DP-300 | Video 9

Episode 9 of 15 For the full video series, click here: https://aka.ms/DP-300onYouTube Configure hardware and server resources for optimal performance after establishing a baseline. Identify sources of performance problems. Troubleshoot using Azure SQL Intelligent Insights. Walk through a lab where you’ll learn how to monitor and troubleshoot Azure SQL Database performance. We’ll guide you through reviewing CPU utilization in the Azure portal and identifying high-CPU queries to keep your database running efficiently. Then, in another lab, you’ll learn how to boost database performance by detecting and fixing index fragmentation issues. We’ll guide you through investigating fragmentation, rebuilding indexes, and validating performance improvements for optimal efficiency. Learn more about this course and take the certification exam to test your new skills: https://aka.ms/DP-300onLearn Chapters 00:00 Video start 00:23 Describe performance monitoring ​00:26 Objectives 19:59 Knowledge check 20:45 Demo: Isolate performance problems through monitoring 31:40 Configure SQL Server resources for optimal performance​ 31:49 Objectives 44:16 Knowledge check 45:31 Configure databases for optimal performance 45:37 Objectives 01:04:24 Knowledge check 01:05:13 Demo: Detect and correct fragmentation issues