【2015】 Pro SQL Server Wait Statistics

Book 图书名称： Pro SQL Server Wait Statistics
Author 作者： Enrico van de Laar
Publisher 出版社： Apress
Page 页数： 336
Publishing Date 出版时间： Aug 26, 2015
Language 语言： English
Size 大小： 6 MB
Format 格式： pdf 文字版
ISBN: 1484211405, 9781484211403
Edition: 第1版 搜索过论坛，没有该文档


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 of 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.

What you’ll learnHow wait Statistics are generated by SQL ServerScript examples for analyzing and tuning wait statisticsHow to lower, or even eliminate, wait times that hurt performanceHow to query wait statistics information from Dynamic Management ViewsHow to build reliable and solid wait statistics baselines from which to detect performance issuesWho this book is for
Pro SQL Server Wait Statistics 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.

== Table of contents ==
Table of Contents
Introduction
Part I: Foundations of Wait Statistics Analysis
1. How Wait Statistics are Generated
2. Querying Wait Statistics
3. Building a Solid Baseline
Part II: Wait Types
4. CPU Wait Types
5. I/O Wait Types
6. Backup Wait Types
7. Lock Wait Types
8. Latch Wait Types
9. High-Availability and Disaster Recovery Wait Types
10: Preemptive Wait Types
11: Background and Miscellaneous Wait Types
12. Chapter 12
13: Appendix A
14. Appendix B
15. Appendix C


== 回帖见免费下载 ==
[hide]
[/hide]
声明： 本资源仅供学术研究参考之用，发布者不负任何法律责任，敬请下载者支持购买正版。
提倡免费分享！ 我发全部免费的，分文不收 来看看 ...
你也可关注我马上加关注