SQL Server 2014 DMV Diagnostic Queries - Part 3
Pluralsight
Course Summary
Learn how to easily query SQL Server for database-level information to help identify and solve performance problems. This course is applicable to anyone who is responsible for SQL Server databases, with all topics also applicable to SQL Server 2012 and earlier versions.
-
+
Course Description
It is very common for SQL Server databases 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 database performance information and identify problems. This course is perfect for anyone who is responsible for SQL Server databases, with all topics also applicable to SQL Server 2012 and earlier versions.
-
+
Course Syllabus
Introduction- 10m 20s
—Title and Introduction 1m 21s
—How Can You Find Performance Problems? 1m 20s
—DMV Queries to the Rescue 1m 24s
—DMV Diagnostic Query History 1m 2s
—Why Use DMV Diagnostic Queries? 1m 7s
—Diagnostic and Corrective Process 1m 24s
—Database-Level Performance Queries 1m 13s
—Summary and Course Structure 1m 24sDatabase-Level Performance Queries Part 1- 29m 8s
—Introduction 1m 3s
—File Sizes and Space 0m 47s
—Demo: File Sizes and Space 1m 22s
—I/O Stats by File 1m 11s
—Demo: I/O Stats by File 1m 30s
—Query Execution Counts 0m 59s
—Demo: Query Execution Counts 0m 53s
—Stored Procedure Execution Counts 1m 31s
—Demo: Stored Procedure Execution Counts 1m 40s
—Stored Procedure Average Elapsed Time 1m 9s
—Demo: Stored Procedure Average Elapsed Time 1m 34s
—Stored Procedure Average Elapsed Variable Time 1m 6s
—Demo: Stored Procedure Average Elapsed Variable Time 1m 12s
—Stored Procedure Total Worker Time 1m 7s
—Demo: Stored Procedure Total Worker Time 1m 0s
—Stored Procedure Total Logical Reads 1m 18s
—Demo: Stored Procedure Total Logical Reads 1m 31s
—Stored Procedure Total Physical Reads 1m 20s
—Demo: Stored Procedure Total Physical Reads 1m 8s
—Stored Procedure Total Logical Writes 1m 25s
—Demo: Stored Procedure Total Logical Writes 1m 4s
—Top I/O Statements 1m 0s
—Demo: Top I/O Statements 0m 41s
—Summary and What Is Next? 1m 26sDatabase-Level Performance Queries Part 2- 28m 57s