Pluralsight training net SQL Server Performance Troubleshooting Using Wait Statistics

Pluralsight training net SQL Server Performance Troubleshooting Using Wait Statistics

Name	[pluralsight-training.net] SQL Server - Performance Troubleshooting Using Wait Statistics	DOWNLOAD Copy Link
Total Size	512.5 MB
Total Files	122
Hash	99E4833C185D84F316417F2B5A67936217DCBF67

/1. Introduction/
1. Introduction.wmv	2.6 MB
2. Where to Start Troubleshooting.wmv	2.9 MB
3. Doctor, Doctor... My Knee Hurts!.wmv	3.2 MB
4. Is the Symptom the Root Cause.wmv	3.8 MB
5. Interpreting the Data.wmv	3.7 MB
6. Demo - Explaining the Workload Mechanism.wmv	6.5 MB
7. Course Structure.wmv	2.0 MB
/2. SQL Server Threading Model/
1. Introduction.wmv	2.0 MB
10. Thread States.wmv	2.0 MB
11. Transition from RUNNING to SUSPENDED.wmv	1.3 MB
12. The Waiter List.wmv	2.1 MB
13. Special Case - Quantum Exhaustion.wmv	2.5 MB
14. Transition from SUSPENDED to RUNNABLE.wmv	2.0 MB
15. The Runnable Queue.wmv	2.2 MB
16. Special Case - Resource Governor.wmv	3.5 MB
17. Resource Governor Example.wmv	2.8 MB
18. Transition from RUNNABLE to RUNNING.wmv	1.1 MB
19. Putting It All Together.wmv	2.1 MB
2. What are Threads.wmv	3.1 MB
20. Demo - Examining Threads on Schedulers.wmv	8.0 MB
21. Summary.wmv	2.3 MB
3. Parallelism.wmv	3.1 MB
4. Parallel Threads Example.wmv	1.6 MB
5. Controlling Parallelism.wmv	3.2 MB
6. Thread Scheduling.wmv	2.7 MB
7. Components of a Scheduler.wmv	1.3 MB
8. Schedulers in SQL Server.wmv	2.8 MB
9. Demo - sys.dm_os_schedulers.wmv	4.7 MB
/3. Waits/
1. Introduction.wmv	1.7 MB
10. Filtering Benign Waits.wmv	3.9 MB
11. Demo - sys.dm_os_wait_stats.wmv	16.0 MB
12. Storing Wait Statistics.wmv	2.4 MB
13. Clearing Wait Statistics.wmv	1.6 MB
14. Demo - Clearing Wait Statistics.wmv	12.8 MB
15. Using Extended Events.wmv	4.3 MB
16. Demo - Using Extended Events.wmv	16.4 MB
17. Summary.wmv	1.9 MB
2. What are Waits.wmv	2.9 MB
3. What are Queues.wmv	2.8 MB
4. Waits and Queues Methodology.wmv	3.4 MB
5. Wait Times Defined.wmv	2.2 MB
6. Graphical View of Wait Times.wmv	1.8 MB
7. sys.dm_os_waiting_tasks DMV.wmv	3.5 MB
8. Demo - sys.dm_os_waiting_tasks.wmv	13.7 MB
9. sys.dm_os_wait_stats DMV.wmv	2.1 MB
/4. Latches and Spinlocks/
1. Introduction.wmv	1.6 MB
10. Spinlock Internals.wmv	3.5 MB
11. Spinlock Contention.wmv	3.3 MB
12. sys.dm_os_spinlock_stats DMV.wmv	2.1 MB
13. Demo - sys.dm_os_spinlock_stats.wmv	7.9 MB
14. Clearing Latch and Spinlock Statistics.wmv	2.0 MB
15. Using Extended Events.wmv	1.8 MB
16. Transaction Log Example.wmv	2.0 MB
17. Summary.wmv	2.2 MB
2. What are Latches.wmv	4.1 MB
3. Types of Latches.wmv	2.2 MB
4. B-tree Page Split Example.wmv	4.0 MB
5. Latch Contention.wmv	3.2 MB
6. Tempdb Latch Contention Example.wmv	4.7 MB
7. sys.dm_os_latch_stats DMV.wmv	1.6 MB
8. Demo - sys.dm_os_latch_stats.wmv	4.2 MB
9. What are Spinlocks.wmv	3.0 MB
/5. Troubleshooting Patterns/
1. Introduction.wmv	1.9 MB
10. PAGEIOLATCH_XX Wait Solutions.wmv	2.2 MB
11. Demo - PAGEIOLATCH_XX Waits.wmv	2.9 MB
12. ASYNC_NETWORK_IO Wait.wmv	4.2 MB
13. Demo - ASYNC_NETWORK_IO Waits.wmv	4.8 MB
14. WRITELOG Wait.wmv	3.7 MB
15. WRITELOG Wait Solutions.wmv	3.2 MB
16. Demo - WRITELOG Waits.wmv	16.9 MB
17. PAGELATCH_XX Wait.wmv	2.2 MB
18. PAGELATCH_XX Wait Solutions.wmv	3.1 MB
19. PAGELATCH_XX Wait Solutions (part 2).wmv	3.2 MB
2. What is Relevant.wmv	2.2 MB
20. Demo - PAGELATCH_XX Waits.wmv	7.7 MB
21. LCK_M_XX Wait.wmv	2.7 MB
22. LCK_M_XX Wait Solutions.wmv	4.7 MB
23. Demo - LCK_M_XX Waits.wmv	19.8 MB
24. SOS_SCHEDULER_YIELD Wait.wmv	3.9 MB
25. SOS_SCHEDULER_YIELD Wait Solutions.wmv	2.3 MB
26. Using Extended Events to Examine Call Stacks.wmv	3.3 MB
27. Demo - Examining Call Stacks with Extended Events.wmv	18.9 MB
28. OLEDB Wait.wmv	2.0 MB
29. PREEMPTIVE_OS_XX Waits.wmv	3.4 MB
3. Top Wait Types Worldwide Survey.wmv	1.3 MB
30. PREEMPTIVE_OS_CREATEFILE Wait.wmv	3.1 MB
31. Demo - PREEMPTIVE_OS_CREATEFILE Wait.wmv	7.8 MB
32. PREEMPTIVE_OS_WRITEFILEGATHER Wait.wmv	3.2 MB
33. PREEMPTIVE_OS_WAITFORSINGLEOBJECT Wait.wmv	2.5 MB
34. BACKUPXX Waits.wmv	2.2 MB
35. Demo - BACKUPXX Waits.wmv	5.3 MB
36. DBMIRRORXX Waits.wmv	2.8 MB
37. HADR_XX Waits.wmv	3.5 MB
38. TRACEWRITE and SQLTRACE_XX Waits.wmv	2.2 MB
39. LATCH_XX Waits.wmv	2.1 MB
4. CXPACKET Wait Explanation.wmv	3.3 MB
40. ACCESS_METHODS_XX Latches.wmv	3.4 MB
41. Demo - ACCESS_METHODS_XX Latches.wmv	10.3 MB
42. FGCB_ADD_REMOVE Latch.wmv	3.6 MB
43. Demo - FGCB_ADD_REMOVE Latches.wmv	21.5 MB
44. DBCC_XX Latches.wmv	2.6 MB
45. Demo - DBCC_XX Latches.wmv	2.9 MB
46. Miscellaneous Wait Types.wmv	3.0 MB
47. More Miscellaneous Wait Types.wmv	3.0 MB
48. Miscellaneous Latch Classes.wmv	2.7 MB
49. Miscellaneous Spinlocks.wmv	2.9 MB
5. CXPACKET Wait Example of Non-Skewed Scan.wmv	1.6 MB
50. Summary.wmv	1.7 MB
6. CXPACKET Wait Example of Skewed Scan.wmv	2.6 MB
7. CXPACKET Wait Solutions.wmv	4.7 MB
8. Demo - CXPACKET Waits.wmv	22.9 MB
9. PAGEIOLATCH_XX Wait.wmv	5.2 MB
/6. Summary/
1. Introduction.wmv	1.2 MB
10. Summary.wmv	4.0 MB
2. Waits, Latches and Spinlocks.wmv	1.9 MB
3. Methodology - No Historical Data.wmv	3.9 MB
4. Methodology - Historical Data.wmv	3.2 MB
5. Real-World Example - Symptoms.wmv	3.1 MB
6. Real-World Example - Analysis.wmv	3.4 MB
7. Real-World Example - Root-Causes.wmv	4.7 MB
8. Real-World Example - Solution.wmv	3.0 MB
9. Resources.wmv	2.8 MB
Total files 122