没有合适的资源?快使用搜索试试~ 我知道了~
Professional SQL Server 2008 Internals and Troubleshooting
5星 · 超过95%的资源 需积分: 10 86 下载量 57 浏览量
2010-03-03
10:16:06
上传
评论 2
收藏 14.05MB PDF 举报
温馨提示
试读
621页
Professional SQL Server 2008 Internals and Troubleshooting
资源推荐
资源详情
资源评论
Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Steven Wort
Wrox Programmer to Programmer™
Join the discussion @ p2p.wrox.com
Professional
SQL Server
®
2008
Internals and Troubleshooting
$59.99 USA
$71.99 CAN
When faced with a variety of SQL Server issues, you need to be able
to troubleshoot SQL Server as well as its underlying operating system.
To that end, this author group of SQL Server experts presents you with
invaluable advice that brings together—and simplifies—practical internal
information concerning SQL Server along with troubleshooting
techniques and methodologies. Packed with real-world examples of
ways to effectively use troubleshooting tools, this book shows you how
to efficiently and accurately determine the root of your SQL Server
problem so you can successfully resolve it.
• Escorts you through the lifecycle of a query to establish an under-
standing of the fundamental concepts and architectures
• Examines the use of memory including the physical components, Windows
memory management, and SQL Server’s own memory architecture
• Reviews SQL Server wait types and how to monitor them with
Extended Events
• Equips you with the knowledge to confidently specify and monitor
your storage performance requirements
• Details SQL Server’s locking model, the internal use of latches,
and row versioning
• Shows you how to use SQLDiag, RML Utilities, SQL Nexus, the
Management Data Warehouse, and how to build your own SQL
Server Management Studio reports
Christian Bolton is coauthor of Professional SQL Server 2005 Performance Tuning
and Technical Director for Coeo Ltd.
Justin Langford is coauthor of Professional SQL Server 2005 Performance Tuning
and leads the Managed Support team for Coeo Ltd.
Brent Ozar is a SQL Server expert for Quest Software.
James Rowland-Jones is an advisory consultant for EMC Consulting.
Steven Wort is a developer in the Windows Division at Microsoft.
Wrox guides are crafted to make learning programming languages and
technologies easier than you think. Written by programmers for programmers,
they provide a structured, tutorial format that will guide you through all the
techniques involved.
Database Management / General
An in-depth look at SQL Server and
best practices for troubleshooting
wrox.com
Programmer
Forums
Join our Programmer to
Programmer forums to ask
and answer programming
questions about this book,
join discussions on the
hottest topics in the industry,
and connect with fellow
programmers from around
the world.
Code Downloads
Take advantage of free code
samples from this book, as
well as code samples from
hundreds of other books, all
ready to use.
Read More
Find articles, ebooks, sample
chapters and tables of contents
for hundreds of books, and
more reference resources on
programming topics that matter
to you.
Bolton, Langford,
et al.
Professional
SQL Server
®
2008
Internals and Troubleshooting
Get more out of
wrox.com
Programmer to Programmer
™
Interact
Take an active role online by participating in our
P2P forums @ p2p.wrox.com
Wrox Online Library
Hundreds of our books are available online
through Books24x7.com
Wrox Blox
Download short informational pieces and code
to keep you up to date and out of trouble!
Join the Community
Sign up for our free monthly newsletter at
newsletter.wrox.com
Browse
Ready for more Wrox? We have books and
e-books available on .NET, SQL Server, Java,
XML, Visual Basic, C#/ C++, and much more!
Contact Us.
We always like to get feedback from our readers. Have a book idea?
Need community support? Let us know by e-mailing wrox-partnerwithus@wrox.com
PROFESSIONAL
SQL SERVER
®
2008 INTERNALS
AND TROUBLESHOOTING
INTRODUCTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxv
CHAPTER 1 SQL Server Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1
CHAPTER 2 Understanding Memory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
CHAPTER 3 SQL Server Waits and Extended Events . . . . . . . . . . . . . . . . . . . . . . . . . . 59
CHAPTER 4 Working with Storage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95
CHAPTER 5 CPU and Query Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .137
CHAPTER 6 Locking and Latches . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185
CHAPTER 7 Knowing Tempdb . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 269
CHAPTER 8 Defi ning Your Approach To Troubleshooting . . . . . . . . . . . . . . . . . . . . . 305
CHAPTER 9 Viewing Server Performance with PerfMon and the PAL Tool . . . . . . 329
CHAPTER 10 Tracing SQL Server with SQL Trace and Profi ler . . . . . . . . . . . . . . . . . . 369
CHAPTER 11 Consolidating Data Collection with SQLDiag and the
PerfStats Script . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 437
CHAPTER 12 Introducing RML Utilities for Stress Testing and Trace
File Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 459
CHAPTER 13 Bringing It All Together with SQL Nexus . . . . . . . . . . . . . . . . . . . . . . . . . 481
CHAPTER 14 Using Management Studio Reports and the Performance
Dashboard . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .505
CHAPTER 15 Using SQL Server Management Data Warehouse . . . . . . . . . . . . . . . . . 539
CHAPTER 16 Shortcuts to E cient Data Collection and Quick Analysis . . . . Wrox.com
INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 555
84289ffirs.indd i84289ffirs.indd i 11/23/09 1:35:42 PM11/23/09 1:35:42 PM
84289ffirs.indd ii84289ffirs.indd ii 11/23/09 1:35:42 PM11/23/09 1:35:42 PM
PROFESSIONAL
SQL Server
®
2008 Internals
and Troubleshooting
84289ffirs.indd iii84289ffirs.indd iii 11/23/09 1:35:42 PM11/23/09 1:35:42 PM
剩余620页未读,继续阅读
资源评论
- neverland_832012-07-09不错,对深入学习sqlserver有帮助。
- liuyuxiang212012-12-25英文版的 看不懂
qq465881818
- 粉丝: 64
- 资源: 52
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功