MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

SQL Server 2014 DMV Diagnostic Queries - Part 2

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 Syllabus

    - 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 47s
    Instance-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 53s
    Instance-Level Performance Queries Part 2
    - 27m 46s

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url