- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
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 they can mean for your SQL Server's performance. Besides the most common wait types, Pro SQL Server Wait Statistics goes further into the more complex and performance threatening wait types. The different wait types are categorized by their area of impact, and include CPU, IO, Lock, and many more different wait type categories. Filled with clear examples, Pro SQL Server Wait Statistics helps you gain practical knowledge of why and how specific wait times increase or decrease, and how they impact your SQL Server's performance.
Contents
IntroductionPart I: Foundations of Wait Statistics Analysis1. How Wait Statistics are Generated2. Querying Wait Statistics3. Building a Solid BaselinePart II: Wait Types4. CPU Wait Types5. I/O Wait Types6. Backup Wait Types7. Lock Wait Types8. Latch Wait Types9. High-Availability and Disaster Recovery Wait Types10: Preemptive Wait Types11: Background and Miscellaneous Wait Types12. Chapter 1213: Appendix A14. Appendix B15. Appendix C
