zhongziso种子搜
首页
功能
磁力转BT
BT转磁力
使用教程
免责声明
关于
zhongziso
搜索
[pluralsight-training.net] SQL Server - Performance Troubleshooting Using Wait Statistics
magnet:?xt=urn:btih:99e4833c185d84f316417f2b5a67936217dcbf67&dn=[pluralsight-training.net] SQL Server - Performance Troubleshooting Using Wait Statistics
磁力链接详情
Hash值:
99e4833c185d84f316417f2b5a67936217dcbf67
点击数:
276
文件大小:
488.76 MB
文件数量:
122
创建日期:
2017-10-21 20:57
最后访问:
2024-12-27 00:43
访问标签:
pluralsight-training
net
SQL
Server
-
Performance
Troubleshooting
Using
Wait
Statistics
文件列表详情
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
其他位置