SQL Server 2017: Diagnosing Performance Issues with DMVs

Focused View

Glenn Berry

2:43:29

38 View

01 - Course Overview

01 - Course Overview.mp4

01:21

02 - Introduction

02 - Introduction and DMV Performance Queries.mp4

02:52

03 - Course Objective and Structure.mp4

01:10

04 - Module Summary.mp4

00:40

03 - Diagnosing Activity-related Instance Issues

05 - Introduction and Version Information.mp4

02:23

06 - Demo - Version Information.mp4

02:03

07 - Hardware Information.mp4

01:33

08 - Demo - Hardware Information.mp4

01:46

09 - Average Task Counts.mp4

01:41

10 - Demo - Average Task Counts.mp4

01:28

11 - Top Waits.mp4

01:42

12 - Demo - Top Waits.mp4

03:06

13 - Detect Blocking.mp4

01:13

14 - Demo - Detect Blocking.mp4

01:55

15 - Version Store Space Usage.mp4

01:21

16 - Demo - Version Store Space Usage.mp4

00:50

17 - Top Average Elapsed Time Queries.mp4

02:08

18 - Demo - Top Average Elapsed Time Queries.mp4

01:29

19 - UDF Statistics by Database.mp4

01:40

20 - Demo - UDF Statistics by Database.mp4

01:23

21 - Missing Indexes for All Databases.mp4

01:58

22 - Demo - Missing Indexes for All Databases.mp4

03:45

23 - Connection Counts by IP Address.mp4

01:27

24 - Demo - Connection Counts by IP Address.mp4

00:57

25 - Module Summary.mp4

00:35

04 - Diagnosing Storage-related Instance Issues

26 - Introduction and I O Usage by Database.mp4

02:16

27 - Demo - I O Usage by Database.mp4

01:13

28 - Volume Information.mp4

01:32

29 - Demo - Volume Information.mp4

00:45

30 - Drive-level Latency.mp4

01:40

31 - Demo - Drive-level Latency.mp4

01:16

32 - I O Metrics by File.mp4

01:30

33 - Demo - I O Metrics by File.mp4

01:22

34 - I O Warnings.mp4

02:20

35 - Demo - I O Warnings.mp4

01:32

36 - Module Summary.mp4

00:35

05 - Diagnosing Memory-related Instance Issues

37 - Introduction and System Memory.mp4

03:01

38 - Demo - System Memory.mp4

00:56

39 - Process Memory.mp4

01:21

40 - Demo - Process Memory.mp4

01:15

41 - Total Buffer Usage by Database.mp4

01:51

42 - Demo - Total Buffer Usage by Database.mp4

00:52

43 - PLE by NUMA Node.mp4

01:41

44 - Demo - PLE by NUMA Node.mp4

01:19

45 - Memory Grants Pending.mp4

01:04

46 - Demo - Memory Grants Pending.mp4

00:42

47 - Memory Clerk Usage.mp4

01:40

48 - Demo - Memory Clerk Usage.mp4

01:31

49 - Ad Hoc Queries.mp4

01:24

50 - Demo - Ad Hoc Queries.mp4

01:30

51 - Top Logical Reads Queries.mp4

01:20

52 - Demo - Top Logical Reads Queries.mp4

01:59

53 - Module Summary.mp4

00:34

06 - Diagnosing CPU-related Instance Issues

54 - Introduction and Processor Description.mp4

02:14

55 - Demo - Processor Description.mp4

00:42

56 - CPU Utilization History.mp4

01:54

57 - Demo - CPU Utilization History.mp4

01:19

58 - CPU Utilization by Database.mp4

01:12

59 - Demo - CPU Utilization by Database.mp4

00:45

60 - Top Worker Time Queries.mp4

01:36

61 - Demo - Top Worker Time Queries.mp4

01:59

62 - SP Worker Time.mp4

02:00

63 - Demo - SP Worker Time.mp4

01:30

64 - High Aggregate CPU Queries.mp4

02:01

65 - Demo - High Aggregate CPU Queries.mp4

02:02

66 - Module Summary.mp4

00:41

07 - Diagnosing Activity-related Database Issues

67 - Introduction and Lock Waits.mp4

02:42

68 - Demo - Lock Waits.mp4

01:08

69 - Scalar UDF Statistics.mp4

01:24

70 - Demo - Scalar UDF Statistics.mp4

01:22

71 - Input Buffer.mp4

01:04

72 - Demo - Input Buffer.mp4

01:14

73 - Query Execution Counts.mp4

01:38

74 - Demo - Query Execution Counts.mp4

01:35

75 - SP Execution Counts.mp4

01:16

76 - Demo - SP Execution Counts.mp4

01:27

77 - SP Average Elapsed Time.mp4

01:59

78 - Demo - SP Average Elapsed Time.mp4

01:29

79 - Bad Nonclustered Indexes.mp4

02:00

80 - Demo - Bad Nonclustered Indexes.mp4

01:25

81 - Missing Indexes.mp4

02:08

82 - Demo - Missing Indexes.mp4

02:53

83 - Missing Index Warnings.mp4

01:48

84 - Demo - Missing Index Warnings.mp4

01:24

85 - Overall Index Usage - Reads.mp4

01:43

86 - Demo - Overall Index Usage - Reads.mp4

01:33

87 - Overall Index Usage - Writes.mp4

01:25

88 - Demo - Overall Index Usage - Writes.mp4

01:18

89 - Volatile Indexes.mp4

01:45

90 - Demo - Volatile Indexes.mp4

01:28

91 - Module Summary.mp4

00:37

08 - Diagnosing Storage and Memory-related Database Issues

92 - Introduction and Buffer Usage.mp4

02:43

93 - Demo - Buffer Usage.mp4

01:07

94 - SP Logical Reads.mp4

01:14

95 - Demo - SP Logical Reads.mp4

01:22

96 - High Aggregate Logical Reads Queries.mp4

01:20

97 - Demo - High Aggregate Logical Reads Queries.mp4

01:40

98 - I O Statistics by File.mp4

01:43

99 - Demo - I O Statistics by File.mp4

01:50

100 - SP Physical Reads.mp4

01:43

101 - Demo - SP Physical Reads.mp4

01:06

102 - SP Logical Writes.mp4

01:32

103 - Demo - SP Logical Writes.mp4

00:56

104 - Top I O Statements.mp4

01:26

105 - Demo - Top I O Statements.mp4

00:40

106 - Module and Course Summary.mp4

01:00

Description

Learn how to easily query SQL Server 2017 for performance information to help identify and fix issues that can affect performance and stability. This course is applicable to anyone responsible for SQL Server 2017 and earlier versions.

What You'll Learn?

It is very common for SQL Server instances to have workload performance problems in one or more ways. In this course, SQL Server 2017: Diagnosing Performance Issues with DMVs, you will see more than 45 DMV queries you can use to easily examine performance information related to your workload, instance health, and storage health. First, you will learn how to detect and correct many common performance issues related to the overall activity on the SQL Server instance and around the storage subsystem. Next, you will be shown how to investigate memory and CPU issues at the instance level. Finally, you will see how to drill into the database level and investigate performance issues there. By the end of this course, you will be able to find and correct the most common SQL Server performance issues. This course is perfect for anyone who is responsible for a SQL Server 2017 instance, with most topics also applicable to SQL Server 2016 and earlier versions.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Database Programming

Microsoft SQL

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.