{"product_id":"9781484211397","title":"Pro SQL Server Wait Statistics","description":"\u003cp\u003e    \u003c\/p\u003e\u003cp\u003e\u003cem\u003ePro SQL Server Wait Statistics\u003c\/em\u003e 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 of how wait statistics are generated and what they can mean for your SQL Server’s performance. \u003c\/p\u003e\u003cp\u003eBesides the most common wait types, \u003cem\u003ePro SQL Server Wait Statistics\u003c\/em\u003e 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, \u003cem\u003ePro SQL Server Wait Statistics \u003c\/em\u003ehelps you gain practical knowledge of why and how specific wait times increase or decrease, and how they impact your SQL Server’s performance.\u003c\/p\u003e\u003cp\u003e\u003cem\u003e\u003c\/em\u003e\u003c\/p\u003e         What you’ll learn\u003cul\u003e\n\u003cli\u003eHow wait Statistics are generated by SQL Server\u003c\/li\u003e\n\u003cli\u003eScript examples for analyzing and tuning wait statistics\u003c\/li\u003e\n\u003cli\u003eHow to lower, or even eliminate, wait times that hurt performance\u003c\/li\u003e\n\u003cli\u003eHow to query wait statistics information from Dynamic Management Views\u003c\/li\u003e\n\u003cli\u003eHow to build reliable and solid wait statistics baselines from which to detect performance issues\u003c\/li\u003e\n\u003c\/ul\u003eWho this book is for      \u003cp\u003e     \u003cem\u003ePro SQL Server Wait Statistics\u003c\/em\u003e is the perfect guide for SQL Server DBAs wanting to troubleshoot and optimize SQL Server database installations. The book is also of interest to database developers who are serious about developing highly-performant applications and reporting systems.      \u003c\/p\u003e     Table of Contents\u003cp\u003eIntroduction\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePart I: Foundations of Wait Statistics Analysis\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003e1. How Wait Statistics are Generated\u003c\/p\u003e\u003cp\u003e2. Querying Wait Statistics\u003c\/p\u003e\u003cp\u003e3. Building a Solid Baseline\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePart II: Wait Types\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003e\u003c\/strong\u003e4. CPU Wait Types\u003c\/p\u003e\u003cp\u003e5. I\/O Wait Types\u003c\/p\u003e\u003cp\u003e6. Backup Wait Types\u003c\/p\u003e\u003cp\u003e7. Lock Wait Types\u003c\/p\u003e\u003cp\u003e8. Latch Wait Types\u003c\/p\u003e\u003cp\u003e9. High-Availability and Disaster Recovery Wait Types\u003c\/p\u003e\u003cp\u003e10: Preemptive Wait Types\u003c\/p\u003e\u003cp\u003e11: Background and Miscellaneous Wait Types\u003c\/p\u003e\u003cp\u003e12. Chapter 12\u003c\/p\u003e\u003cp\u003e13: Appendix A\u003c\/p\u003e\u003cp\u003e14. Appendix B\u003c\/p\u003e\u003cp\u003e15. Appendix C\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47136249446640,"sku":"9781484211397","price":39.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781484211397_p0.jpg?v=1763632319","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781484211397","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}