TorBT - Torrents and Magnet Links Search Engine
Latest Searches: %e8%bf%aa%e4%b8%bd%e7%83%ad%e5%b7%b4%2f, rough%2f, prompt, rippy, riccardino/, holiday:+a+soldier+is+never+off+duty, revit+mechanical, toshiba, the last of us s02e01, reportages

[pluralsight-training.net] SQL Server - Performance Troubleshooting Using Wait Statistics

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