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

wmv   Hot：283   Size：488.76 MB   Created：2017-08-27 18:25:35   Update：2021-12-13 11:58:02  

Download link

小提示：当迅雷提示“下载出错”或“无法下载”等字样时，并非资源有问题，请更换 bitcomet(比特彗星) 即可下载，或者使用迅雷5。

File List

  • 1. Introduction/1. Introduction.wmv 2.5 MB
    1. Introduction/2. Where to Start Troubleshooting.wmv 2.75 MB
    1. Introduction/3. Doctor, Doctor... My Knee Hurts!.wmv 3.08 MB
    1. Introduction/4. Is the Symptom the Root Cause.wmv 3.62 MB
    1. Introduction/5. Interpreting the Data.wmv 3.52 MB
    1. Introduction/6. Demo - Explaining the Workload Mechanism.wmv 6.18 MB
    1. Introduction/7. Course Structure.wmv 1.91 MB
    2. SQL Server Threading Model/1. Introduction.wmv 1.94 MB
    2. SQL Server Threading Model/10. Thread States.wmv 1.93 MB
    2. SQL Server Threading Model/11. Transition from RUNNING to SUSPENDED.wmv 1.21 MB
    2. SQL Server Threading Model/12. The Waiter List.wmv 1.98 MB
    2. SQL Server Threading Model/13. Special Case - Quantum Exhaustion.wmv 2.42 MB
    2. SQL Server Threading Model/14. Transition from SUSPENDED to RUNNABLE.wmv 1.93 MB
    2. SQL Server Threading Model/15. The Runnable Queue.wmv 2.11 MB
    2. SQL Server Threading Model/16. Special Case - Resource Governor.wmv 3.36 MB
    2. SQL Server Threading Model/17. Resource Governor Example.wmv 2.68 MB
    2. SQL Server Threading Model/18. Transition from RUNNABLE to RUNNING.wmv 1.07 MB
    2. SQL Server Threading Model/19. Putting It All Together.wmv 2.03 MB
    2. SQL Server Threading Model/2. What are Threads.wmv 3 MB
    2. SQL Server Threading Model/20. Demo - Examining Threads on Schedulers.wmv 7.63 MB
    2. SQL Server Threading Model/21. Summary.wmv 2.21 MB
    2. SQL Server Threading Model/3. Parallelism.wmv 2.98 MB
    2. SQL Server Threading Model/4. Parallel Threads Example.wmv 1.56 MB
    2. SQL Server Threading Model/5. Controlling Parallelism.wmv 3.07 MB
    2. SQL Server Threading Model/6. Thread Scheduling.wmv 2.61 MB
    2. SQL Server Threading Model/7. Components of a Scheduler.wmv 1.19 MB
    2. SQL Server Threading Model/8. Schedulers in SQL Server.wmv 2.64 MB
    2. SQL Server Threading Model/9. Demo - sys.dm_os_schedulers.wmv 4.48 MB
    3. Waits/1. Introduction.wmv 1.61 MB
    3. Waits/10. Filtering Benign Waits.wmv 3.7 MB
    3. Waits/11. Demo - sys.dm_os_wait_stats.wmv 15.28 MB
    3. Waits/12. Storing Wait Statistics.wmv 2.32 MB
    3. Waits/13. Clearing Wait Statistics.wmv 1.53 MB
    3. Waits/14. Demo - Clearing Wait Statistics.wmv 12.16 MB
    3. Waits/15. Using Extended Events.wmv 4.06 MB
    3. Waits/16. Demo - Using Extended Events.wmv 15.67 MB
    3. Waits/17. Summary.wmv 1.81 MB
    3. Waits/2. What are Waits.wmv 2.77 MB
    3. Waits/3. What are Queues.wmv 2.7 MB
    3. Waits/4. Waits and Queues Methodology.wmv 3.28 MB
    3. Waits/5. Wait Times Defined.wmv 2.09 MB
    3. Waits/6. Graphical View of Wait Times.wmv 1.7 MB
    3. Waits/7. sys.dm_os_waiting_tasks DMV.wmv 3.32 MB
    3. Waits/8. Demo - sys.dm_os_waiting_tasks.wmv 13.09 MB
    3. Waits/9. sys.dm_os_wait_stats DMV.wmv 2.04 MB
    4. Latches and Spinlocks/1. Introduction.wmv 1.57 MB
    4. Latches and Spinlocks/10. Spinlock Internals.wmv 3.34 MB
    4. Latches and Spinlocks/11. Spinlock Contention.wmv 3.13 MB
    4. Latches and Spinlocks/12. sys.dm_os_spinlock_stats DMV.wmv 1.98 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.89 MB
    4. Latches and Spinlocks/15. Using Extended Events.wmv 1.73 MB
    4. Latches and Spinlocks/16. Transaction Log Example.wmv 1.9 MB
    4. Latches and Spinlocks/17. Summary.wmv 2.09 MB
    4. Latches and Spinlocks/2. What are Latches.wmv 3.88 MB
    4. Latches and Spinlocks/3. Types of Latches.wmv 2.07 MB
    4. Latches and Spinlocks/4. B-tree Page Split Example.wmv 3.84 MB
    4. Latches and Spinlocks/5. Latch Contention.wmv 3.02 MB
    4. Latches and Spinlocks/6. Tempdb Latch Contention Example.wmv 4.45 MB
    4. Latches and Spinlocks/7. sys.dm_os_latch_stats DMV.wmv 1.55 MB
    4. Latches and Spinlocks/8. Demo - sys.dm_os_latch_stats.wmv 3.97 MB
    4. Latches and Spinlocks/9. What are Spinlocks.wmv 2.86 MB
    5. Troubleshooting Patterns/1. Introduction.wmv 1.85 MB
    5. Troubleshooting Patterns/10. PAGEIOLATCH_XX Wait Solutions.wmv 2.11 MB
    5. Troubleshooting Patterns/11. Demo - PAGEIOLATCH_XX Waits.wmv 2.78 MB
    5. Troubleshooting Patterns/12. ASYNC_NETWORK_IO Wait.wmv 3.97 MB
    5. Troubleshooting Patterns/13. Demo - ASYNC_NETWORK_IO Waits.wmv 4.62 MB
    5. Troubleshooting Patterns/14. WRITELOG Wait.wmv 3.53 MB
    5. Troubleshooting Patterns/15. WRITELOG Wait Solutions.wmv 3.09 MB
    5. Troubleshooting Patterns/16. Demo - WRITELOG Waits.wmv 16.09 MB
    5. Troubleshooting Patterns/17. PAGELATCH_XX Wait.wmv 2.1 MB
    5. Troubleshooting Patterns/18. PAGELATCH_XX Wait Solutions.wmv 2.99 MB
    5. Troubleshooting Patterns/19. PAGELATCH_XX Wait Solutions (part 2).wmv 3.03 MB
    5. Troubleshooting Patterns/2. What is Relevant.wmv 2.06 MB
    5. Troubleshooting Patterns/20. Demo - PAGELATCH_XX Waits.wmv 7.37 MB
    5. Troubleshooting Patterns/21. LCK_M_XX Wait.wmv 2.54 MB
    5. Troubleshooting Patterns/22. LCK_M_XX Wait Solutions.wmv 4.45 MB
    5. Troubleshooting Patterns/23. Demo - LCK_M_XX Waits.wmv 18.87 MB
    5. Troubleshooting Patterns/24. SOS_SCHEDULER_YIELD Wait.wmv 3.71 MB
    5. Troubleshooting Patterns/25. SOS_SCHEDULER_YIELD Wait Solutions.wmv 2.16 MB
    5. Troubleshooting Patterns/26. Using Extended Events to Examine Call Stacks.wmv 3.19 MB
    5. Troubleshooting Patterns/27. Demo - Examining Call Stacks with Extended Events.wmv 17.99 MB
    5. Troubleshooting Patterns/28. OLEDB Wait.wmv 1.9 MB
    5. Troubleshooting Patterns/29. PREEMPTIVE_OS_XX Waits.wmv 3.22 MB
    5. Troubleshooting Patterns/3. Top Wait Types Worldwide Survey.wmv 1.25 MB
    5. Troubleshooting Patterns/30. PREEMPTIVE_OS_CREATEFILE Wait.wmv 2.95 MB
    5. Troubleshooting Patterns/31. Demo - PREEMPTIVE_OS_CREATEFILE Wait.wmv 7.42 MB
    5. Troubleshooting Patterns/32. PREEMPTIVE_OS_WRITEFILEGATHER Wait.wmv 3.08 MB
    5. Troubleshooting Patterns/33. PREEMPTIVE_OS_WAITFORSINGLEOBJECT Wait.wmv 2.34 MB
    5. Troubleshooting Patterns/34. BACKUPXX Waits.wmv 2.08 MB
    5. Troubleshooting Patterns/35. Demo - BACKUPXX Waits.wmv 5.06 MB
    5. Troubleshooting Patterns/36. DBMIRRORXX Waits.wmv 2.7 MB
    5. Troubleshooting Patterns/37. HADR_XX Waits.wmv 3.29 MB
    5. Troubleshooting Patterns/38. TRACEWRITE and SQLTRACE_XX Waits.wmv 2.11 MB
    5. Troubleshooting Patterns/39. LATCH_XX Waits.wmv 2.02 MB
    5. Troubleshooting Patterns/4. CXPACKET Wait Explanation.wmv 3.14 MB
    5. Troubleshooting Patterns/40. ACCESS_METHODS_XX Latches.wmv 3.24 MB
    5. Troubleshooting Patterns/41. Demo - ACCESS_METHODS_XX Latches.wmv 9.85 MB
    5. Troubleshooting Patterns/42. FGCB_ADD_REMOVE Latch.wmv 3.46 MB
    5. Troubleshooting Patterns/43. Demo - FGCB_ADD_REMOVE Latches.wmv 20.53 MB
    5. Troubleshooting Patterns/44. DBCC_XX Latches.wmv 2.51 MB
    5. Troubleshooting Patterns/45. Demo - DBCC_XX Latches.wmv 2.76 MB
    5. Troubleshooting Patterns/46. Miscellaneous Wait Types.wmv 2.82 MB
    5. Troubleshooting Patterns/47. More Miscellaneous Wait Types.wmv 2.83 MB
    5. Troubleshooting Patterns/48. Miscellaneous Latch Classes.wmv 2.61 MB
    5. Troubleshooting Patterns/49. Miscellaneous Spinlocks.wmv 2.81 MB
    5. Troubleshooting Patterns/5. CXPACKET Wait Example of Non-Skewed Scan.wmv 1.51 MB
    5. Troubleshooting Patterns/50. Summary.wmv 1.63 MB
    5. Troubleshooting Patterns/6. CXPACKET Wait Example of Skewed Scan.wmv 2.51 MB
    5. Troubleshooting Patterns/7. CXPACKET Wait Solutions.wmv 4.49 MB
    5. Troubleshooting Patterns/8. Demo - CXPACKET Waits.wmv 21.87 MB
    5. Troubleshooting Patterns/9. PAGEIOLATCH_XX Wait.wmv 4.95 MB
    6. Summary/1. Introduction.wmv 1.14 MB
    6. Summary/10. Summary.wmv 3.79 MB
    6. Summary/2. Waits, Latches and Spinlocks.wmv 1.81 MB
    6. Summary/3. Methodology - No Historical Data.wmv 3.72 MB
    6. Summary/4. Methodology - Historical Data.wmv 3.1 MB
    6. Summary/5. Real-World Example - Symptoms.wmv 2.98 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.89 MB
    6. Summary/9. Resources.wmv 2.7 MB

Download Info

  • Tips

    “[pluralsight-training.net] SQL Server - Performance Troubleshooting Using Wait Statistics” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.

  • DMCA Notice and Takedown Procedure

    If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.