This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Server Performance: Root Cause Analysis with DMVs
Introduction
Course Introduction - Thoughts on DMVs (0:48)
Query Stats
Introduction to Query Stats (5:18)
Using sys.dm_exec_query_stats (4:01)
Get your hands dirty! (1:32)
Drilling Down on a Problem Query (10:47)
The Significance of Logical Reads (3:40)
Wait Types
Introduction to Wait Types (3:06)
sys.dm_os_wait_stats (8:27)
sys.dm_exec_requests (12:03)
sys.dm_exec_sessions (4:43)
sys.dm_exec_connections (5:32)
sys.dm_os_waiting_tasks (8:21)
Memory
Introduction to Memory DMVs (5:39)
dm_os_memory_clerks (5:16)
dm_os_memory_objects (5:18)
sys.dm_exec_cached_plans (6:45)
dm_exec_query_memory_grants (8:49)
What Does "Cost" Mean? (6:03)
Storage and IO
Intro to IO (3:35)
sys.dm_io_virtual_file_stats (7:47)
sys.dm_io_pending_io_requests (8:19)
Summary
Closing Remarks (1:56)
Addendum
sys.sysprocesses (7:55)
sys.dm_exec_cached_plans
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock