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
