Azure SQL Database: Diagnosing Performance Issues with DMVs

Focused View

Glenn Berry

1:30:24

47 View

1 - Course Overview

01 - Course Overview.mp4

01:25

2 - Introduction

02 - Introduction and DMV Queries.mp4

01:39

03 - Diagnosing Issues and Benefits of DMV Queries.mp4

01:59

04 - Course Details and Module Summary.mp4

01:47

3 - Diagnosing Database-level Configuration Issues

05 - Introduction and Database Properties.mp4

02:25

06 - Demo - Database Properties.mp4

01:39

07 - File Sizes and Space.mp4

00:58

08 - Demo - File Sizes and Space.mp4

00:47

09 - Database-scoped Configurations.mp4

01:29

10 - Demo - Database-scoped Configurations.mp4

01:00

11 - Table Properties.mp4

00:48

12 - Demo - Table Properties.mp4

00:46

13 - Query Store Options.mp4

01:30

14 - Demo - Query Store Options.mp4

00:58

15 - Automatic Tuning Options.mp4

01:38

16 - Demo - Automatic Tuning Options.mp4

01:13

17 - Module Summary.mp4

00:31

4 - Diagnosing CPU-related Issues

18 - Introduction and CPU Utilization by Database.mp4

02:04

19 - Demo - CPU Utilization by Database.mp4

00:35

20 - Top Worker Time Queries.mp4

01:36

21 - Demo - Top Worker Time Queries.mp4

01:31

22 - SP Worker Time.mp4

01:44

23 - Demo - SP Worker Time.mp4

01:16

24 - High Aggregate CPU Queries.mp4

01:51

25 - Demo - High Aggregate CPU Queries.mp4

01:11

26 - Module Summary.mp4

00:32

5 - Diagnosing Activity-related Issues

27 - Introduction and Lock Waits.mp4

02:35

28 - Demo - Lock Waits.mp4

00:59

29 - Scalar UDF Statistics.mp4

01:40

30 - Demo - Scalar UDF Statistics.mp4

01:09

31 - Input Buffer.mp4

01:23

32 - Demo - Input Buffer.mp4

00:52

33 - Query Execution Counts.mp4

01:52

34 - Demo - Query Execution Counts.mp4

01:20

35 - SP Execution Counts.mp4

01:58

36 - Demo - SP Execution Counts.mp4

01:03

37 - SP Average Elapsed Time.mp4

02:19

38 - Demo - SP Average Elapsed Time.mp4

01:17

39 - Bad Nonclustered Indexes.mp4

01:34

40 - Demo - Bad Nonclustered Indexes.mp4

01:12

41 - Missing Indexes.mp4

02:32

42 - Demo - Missing Indexes.mp4

02:42

43 - Missing Index Warnings.mp4

01:52

44 - Demo - Missing Index Warnings.mp4

00:53

45 - Overall Index Usage - Reads.mp4

01:43

46 - Demo - Overall Index Usage - Reads.mp4

00:57

47 - Overall Index Usage - Writes.mp4

01:30

48 - Demo - Overall Index Usage - Writes.mp4

00:50

49 - Volatile Indexes.mp4

01:27

50 - Demo - Volatile Indexes.mp4

00:54

51 - Recent Resource Usage.mp4

01:44

52 - Demo - Recent Resource Usage.mp4

00:52

53 - Module Summary.mp4

00:31

6 - Diagnosing Storage and Memory-related Issues

54 - Introduction and Buffer Usage.mp4

02:32

55 - Demo - Buffer Usage.mp4

00:51

56 - SP Logical Reads.mp4

01:34

57 - Demo - SP Logical Reads.mp4

01:06

58 - I O Statistics by File.mp4

01:25

59 - Demo - I O Statistics by File.mp4

00:52

60 - SP Physical Reads.mp4

01:35

61 - Demo - SP Physical Reads.mp4

00:47

62 - SP Logical Writes.mp4

01:29

63 - Demo - SP Logical Writes.mp4

00:48

64 - Top I O Statements.mp4

01:23

65 - Demo - Top I O Statements.mp4

00:36

66 - Module and Course Summaries.mp4

00:54

Description

Learn how to easily query Azure SQL Database for performance and configuration information to help identify and fix issues that can affect performance and stability. This course is applicable to anyone responsible for Azure SQL Database.

What You'll Learn?

It is very common for Azure SQL Databases to have workload performance problems. In this course, Azure SQL Database: Diagnosing Performance Issues with DMVs, you will learn how to use a variety of DMV queries to find performance and configuration information in Azure SQL Database. First, you will see how to diagnose and fix configuration issues at the database level. Next, you will discover how to diagnose and fix performance issues related to CPU and workload activity. Finally, you will explore how to find and fix issues related to storage and memory. When you are finished with this course, you will have the skills and knowledge to use these DMV queries to increase the performance and stability of your workload on Azure SQL Database.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

SQL Server

Microsoft Azure

Glenn Berry

Instructor's Courses

Glenn works as a Principal Consultant at SQLskills.com. He has been a SQL Server MVP since 2007, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, and performance tuning. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He has completed the Master Teacher Program at Denver University - University College. He is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQL Saturdays, and the PASS Community Summit. He is the author of the book SQL Server Hardware (Redgate 2011), and he wrote chapters for SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2 books.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.