Pro SQL Server Wait Statistics
Pro SQL Server Wait Statistics is a practical guide for analyzing and troubleshooting SQL Server performance using wait statistics. Whether you are new to wait statistics, or already familiar with them, this book will help you gain a deeper understanding on how wait statistics are generated and what...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress
2015.
|
| Edición: | 1st ed. 2015. |
| Colección: | Expert's voice in SQL server.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629713006719 |
Tabla de Contenidos:
- Contents at a Glance; Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Part I: Foundations of Wait Statistics Analysis ; Chapter 1: Wait Statistics Internals; A Brief History of Wait Statistics; The SQLOS; Schedulers, Tasks, and Worker Threads; Sessions; Requests; Tasks; Worker Threads; Schedulers; Putting It All Together; Wait Statistics; Summary; Chapter 2: Querying SQL Server Wait Statistics; Sys.dm_os_wait_stats; Sys.dm_os_waiting_tasks; Querying sys.dm_os_waiting_tasks; Sys.dm_exec_requests; Querying sys.dm_exec_requests
- Combining DMVs to Detect Waits Right Now Viewing Wait Statistics Using Perfmon; Capturing Wait Statistics Using Extended Events; Capture Wait Statistics Information for a Specific Query; Summary; Chapter 3: Building a Solid Baseline; What Are Baselines?; Visualizing Your Baselines; Baselines Types and Statistics; Baseline Pitfalls; Too Much Information; Know Your Metrics; Focus on the Big Measurement Changes; Use Fixed Intervals; Building a Baseline for Wait Statistics Analysis; Reset Capture Method; Delta Capture Method; Using SQL Server Agent to Schedule Measurements
- Wait Statistics Baseline Analysis Summary; Part II: Wait Types ; Chapter 4: CPU-Related Wait Types; CXPACKET; What Is the CXPACKET Wait Type?; Lowering CXPACKET Wait Time by Tuning the Parallelism Configuration; Lowering CXPACKET Wait Time by Resolving Skewed Workloads; CXPACKET Summary; SOS_SCHEDULER_YIELD; What Is the SOS_SCHEDULER_YIELD Wait Type?; Lowering SOS_SCHEDULER_YIELD Waits; SOS_SCHEDULER_YIELD Summary; THREADPOOL; What Is the THREADPOOL Wait Type?; THREADPOOL Example; Gaining Access to Our SQL Server during THREADPOOL Waits
- Lowering THREADPOOL Waits Caused by Parallelism Lowering THREADPOOL Waits Caused by User Connections; THREADPOOL Summary; Chapter 5: IO-Related Wait Types; ASYNC_IO_COMPLETION; What Is the ASYNC_IO_COMPLETION Wait Type?; ASYNC_IO_COMPLETION Example; Lowering ASYNC_IO_COMPLETION Waits; ASYNC_IO_COMPLETION Summary; ASYNC_NETWORK_IO; What Is the ASYNC_NETWORK_IO Wait Type?; ASYNC_NETWORK_IO Example; Lowering ASYNC_NETWORK_IO Waits; ASYNC_NETWORK_IO Summary; CMEMTHREAD; What Is the CMEMTHREAD Wait Type?; Lowering CMEMTHREAD Waits; CMEMTHREAD Summary; IO_COMPLETION
- What Is the IO_COMPLETION Wait Type? IO_COMPLETION Example; Lowering IO_COMPLETION Waits; IO_COMPLETION Summary; LOGBUFFER & WRITELOG; What Are the LOGBUFFER & WRITELOG Wait Types?; LOGBUFFER & WRITELOG Example; Lowering LOGBUFFER & WRITELOG Waits; LOGBUFFER & WRITELOG Summary; RESOURCE_SEMAPHORE; What Is the RESOURCE_SEMAPHORE Wait Type?; RESOURCE_SEMAPHORE Example; Lowering RESOURCE_SEMAPHORE Waits; RESOURCE_SEMAPHORE Summary; RESOURCE_SEMAPHORE_QUERY_COMPILE; What Is the RESOURCE_SEMAPHORE_QUERY_ COMPILE Wait Type?; RESOURCE_SEMAPHORE_QUERY_COMPILE Example
- Lowering RESOURCE_SEMAPHORE_QUERY_ COMPILE Waits
