SQL Server 2014 DMV Diagnostic Queries - Part 2
Pluralsight
Course Summary
Learn how to easily query SQL Server for instance-level information to help identify and solve performance problems. This course is applicable to anyone who is responsible for a SQL Server instance, with most topics also applicable to SQL Server 2012 and earlier versions.
-
+
Course Description
It is very common for SQL Server instances to have performance problems, but it can be hard to know how to get the information necessary to figure out what the performance problems are. This course will describe and demonstrate more than 20 DMV queries you can use to easily examine SQL Server instance performance information and identify problems. This course is perfect for anyone who is responsible for a SQL Server instance, with most topics also applicable to SQL Server 2012 and earlier versions.
-
+
Course Syllabus
Introduction- 11m 31s
—Introduction 1m 14s
—How Can You Find Performance Problems? 2m 6s
—DMV Queries to the Rescue! 1m 24s
—DMV Diagnostic Query History 1m 21s
—Why Use DMV Diagnostic Queries? 1m 30s
—Diagnostic and Corrective Process 1m 10s
—Instance-Level Performance Queries 1m 9s
—Summary 0m 45s
—Course Structure 0m 47sInstance-Level Performance Queries Part 1- 38m 13s
—Introduction 1m 19s
—I/O Warnings 1m 50s
—Demo: I/O Warnings 1m 39s
—Drive-Level Latency 1m 34s
—Demo: Drive-Level Latency 1m 0s
—I/O Latencies by Database File 1m 37s
—Demo: I/O Latencies by Database File 1m 45s
—Database Properties 1m 19s
—Demo: Database Properties 2m 54s
—Missing Indexes for All Databases 1m 31s
—Demo: Missing Indexes for All Databases 5m 37s
—Getting VLF Counts 0m 46s
—Demo: Getting VLF Counts 2m 6s
—CPU Usage by Database 1m 6s
—Demo: CPU Usage by Database 0m 56s
—I/O Usage by Database 1m 10s
—Demo: I/O Usage by Database 0m 45s
—Total Buffer Usage by Database 1m 1s
—Demo: Total Buffer Usage by Database 0m 50s
—Top Waits 1m 33s
—Demo: Top Waits 2m 7s
—Signal Waits 0m 36s
—Demo: Signal Waits 1m 4s
—Summary 1m 4s
—What Is Next? 0m 53sInstance-Level Performance Queries Part 2- 27m 46s
