Pluralsight - SQL Server Performance Troubleshooting Using Wait Statistics (2012)

1. 5. Troubleshooting Patterns/8. Demo - CXPACKET Waits.wmv 22.40 MB
2. 5. Troubleshooting Patterns/43. Demo - FGCB_ADD_REMOVE Latches.wmv 21.02 MB
3. 5. Troubleshooting Patterns/23. Demo - LCK_M_XX Waits.wmv 19.32 MB
4. 5. Troubleshooting Patterns/27. Demo - Examining Call Stacks with Extended Events.wmv 18.42 MB
5. 5. Troubleshooting Patterns/16. Demo - WRITELOG Waits.wmv 16.48 MB
6. 3. Waits/16. Demo - Using Extended Events.wmv 16.05 MB
7. 3. Waits/11. Demo - sys.dm_os_wait_stats.wmv 15.64 MB
8. 3. Waits/8. Demo - sys.dm_os_waiting_tasks.wmv 13.40 MB
9. 3. Waits/14. Demo - Clearing Wait Statistics.wmv 12.45 MB
10. 5. Troubleshooting Patterns/41. Demo - ACCESS_METHODS_XX Latches.wmv 10.09 MB
11. 2. SQL Server Threading Model/20. Demo - Examining Threads on Schedulers.wmv 7.82 MB
12. 4. Latches and Spinlocks/13. Demo - sys.dm_os_spinlock_stats.wmv 7.68 MB
13. 5. Troubleshooting Patterns/31. Demo - PREEMPTIVE_OS_CREATEFILE Wait.wmv 7.60 MB
14. 5. Troubleshooting Patterns/20. Demo - PAGELATCH_XX Waits.wmv 7.54 MB
15. 1. Introduction/6. Demo - Explaining the Workload Mechanism.wmv 6.33 MB
16. 5. Troubleshooting Patterns/35. Demo - BACKUPXX Waits.wmv 5.18 MB
17. 5. Troubleshooting Patterns/9. PAGEIOLATCH_XX Wait.wmv 5.07 MB
18. 5. Troubleshooting Patterns/13. Demo - ASYNC_NETWORK_IO Waits.wmv 4.73 MB
19. 6. Summary/7. Real-World Example - Root-Causes.wmv 4.61 MB
20. 5. Troubleshooting Patterns/7. CXPACKET Wait Solutions.wmv 4.59 MB
21. 2. SQL Server Threading Model/9. Demo - sys.dm_os_schedulers.wmv 4.59 MB
22. 5. Troubleshooting Patterns/22. LCK_M_XX Wait Solutions.wmv 4.56 MB
23. 4. Latches and Spinlocks/6. Tempdb Latch Contention Example.wmv 4.56 MB
24. 3. Waits/15. Using Extended Events.wmv 4.15 MB
25. 5. Troubleshooting Patterns/12. ASYNC_NETWORK_IO Wait.wmv 4.06 MB
26. 4. Latches and Spinlocks/8. Demo - sys.dm_os_latch_stats.wmv 4.06 MB
27. 4. Latches and Spinlocks/2. What are Latches.wmv 3.97 MB
28. 4. Latches and Spinlocks/4. B-tree Page Split Example.wmv 3.93 MB
29. 6. Summary/10. Summary.wmv 3.88 MB
30. 6. Summary/3. Methodology - No Historical Data.wmv 3.81 MB
31. 5. Troubleshooting Patterns/24. SOS_SCHEDULER_YIELD Wait.wmv 3.80 MB
32. 3. Waits/10. Filtering Benign Waits.wmv 3.79 MB
33. 1. Introduction/4. Is the Symptom the Root Cause.wmv 3.71 MB
34. 5. Troubleshooting Patterns/14. WRITELOG Wait.wmv 3.61 MB
35. 1. Introduction/5. Interpreting the Data.wmv 3.61 MB
36. 5. Troubleshooting Patterns/42. FGCB_ADD_REMOVE Latch.wmv 3.54 MB
37. 2. SQL Server Threading Model/16. Special Case - Resource Governor.wmv 3.44 MB
38. 4. Latches and Spinlocks/10. Spinlock Internals.wmv 3.42 MB
39. 3. Waits/7. sys.dm_os_waiting_tasks DMV.wmv 3.40 MB
40. 5. Troubleshooting Patterns/37. HADR_XX Waits.wmv 3.37 MB
41. 3. Waits/4. Waits and Queues Methodology.wmv 3.36 MB
42. 5. Troubleshooting Patterns/40. ACCESS_METHODS_XX Latches.wmv 3.31 MB
43. 5. Troubleshooting Patterns/29. PREEMPTIVE_OS_XX Waits.wmv 3.30 MB
44. 6. Summary/6. Real-World Example - Analysis.wmv 3.28 MB
45. 5. Troubleshooting Patterns/26. Using Extended Events to Examine Call Stacks.wmv 3.27 MB
46. 5. Troubleshooting Patterns/4. CXPACKET Wait Explanation.wmv 3.21 MB
47. 4. Latches and Spinlocks/11. Spinlock Contention.wmv 3.21 MB
48. 6. Summary/4. Methodology - Historical Data.wmv 3.17 MB
49. 5. Troubleshooting Patterns/15. WRITELOG Wait Solutions.wmv 3.16 MB
50. 1. Introduction/3. Doctor, Doctor... My Knee Hurts!.wmv 3.15 MB