没有合适的资源?快使用搜索试试~ 我知道了~
首页《SQL Server 2008查询性能优化》英文[PDF]
《SQL Server 2008查询性能优化》英文[PDF]
需积分: 10 32 下载量 187 浏览量
更新于2023-03-16
评论 1
收藏 9.45MB PDF 举报
《SQL Server 2008查询性能优化》通过大量实例,详细介绍了SQL Server数据库系统优化的各种方法和技巧。内容涵盖了数据库应用系统中各种性能瓶颈的表现形式及其发生的根源和解决方法,从硬件瓶颈到查询、索引设计以及数据库管理等,贯穿了数据库系统知识的各个方面。最后以一个实际的工作负载将所有技巧联系起来,并且提供了“宝典”式的最佳实践列表。 《SQL Server 2008查询性能优化》适合于关心数据库应用系统性能的开发人员和数据库管理人员阅读。通过阅读《SQL Server 2008查询性能优化》,不仅可以学习到数据库性能管理的许多知识和技巧,还有助于养成良好的编程习惯,为实现高性能的数据库应用系统打下基础。 作者简介 · · · · · · 为FM Global(一家行业领先的工程和保险公司)工作,担任首席DBA。他使用各种语言(如VB、C#和Java等)开发了许多大规模的应用程序,从版本6.0开始使用SOL Server。他曾经为3家失败的.com公司担任财务和咨询工作,还是Dissecting SQL Server Execution Plans一书的作者。 达姆拥有位于印度班加罗尔的印度理工学院的计算机科学技术硕士学位,并且使用微软技术超过16年。他已经在设计数据库应用和管理软件开发方面拥有了很广泛的背景。Sajal还在从前端网页到后端数据库的基于微软技术的应用程序上,具备了故障定位和性能优化的大量经验。他有许多为《财富》500强公司设计可伸缩的数据库解决方案和最大化数据库环境性能的经验。
资源详情
资源评论
资源推荐
SQL Server 2008 Query
Performance Tuning
Distilled
Grant Fritchey and Sajal Dam
SQL Server 2008 Query Performance Tuning Distilled
Copyright © 2009 by Grant Fritchey and Sajal Dam
All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means,
electronic or mechanical, including photocopying, recording, or by any information storage or retrieval
system, without the prior written permission of the copyright owner and the publisher.
ISBN-13 (pbk): 978-1-4302-1902-6
ISBN-13 (electronic): 978-1-4302-1903-3
Printed and bound in the United States of America 9 8 7 6 5 4 3 2 1
Trademarked names may appear in this book. Rather than use a trademark symbol with every occurrence
of a trademarked name, we use the names only in an editorial fashion and to the benefit of the trademark
owner, with no intention of infringement of the trademark.
Lead Editor: Jonathan Gennick
Development Editor: Douglas Pundick
Technical Reviewer: Joseph Sack
Editorial Board: Clay Andres, Steve Anglin, Mark Beckner, Ewan Buckingham, Tony Campbell,
Gary Cornell, Jonathan Gennick, Michelle Lowman, Matthew Moodie, Jeffrey Pepper, Frank Pohlmann,
Ben Renow-Clarke, Dominic Shakeshaft, Matt Wade, Tom Welsh
Project Manager: Richard Dal Porto
Copy Editor: Kim Wimpsett
Associate Production Director: Kari Brooks-Copony
Production Editor: Kelly Winquist
Compositor: Patrick Cunningham
Proofreader: April Eddy
Indexer: John Collin
Artist: April Milne
Cover Designer: Kurt Krames
Manufacturing Director: Tom Debolski
Distributed to the book trade worldwide by Springer-Verlag New York, Inc., 233 Spring Street, 6th Floor,
New York, NY 10013. Phone 1-800-SPRINGER, fax 201-348-4505, e-mail kn`ano)ju<olnejcan)o^i*_ki, or
visit dppl6++sss*olnejcankjheja*_ki.
For information on translations, please contact Apress directly at 2855 Telegraph Avenue, Suite 600,
Berkeley, CA 94705. Phone 510-549-5930, fax 510-549-5939, e-mail ejbk<]lnaoo*_ki, or visit dppl6++sss*
]lnaoo*_ki.
Apress and friends of ED books may be purchased in bulk for academic, corporate, or promotional use.
eBook versions and licenses are also available for most titles. For more information, reference our Special
Bulk Sales–eBook Licensing web page at dppl6++sss*]lnaoo*_ki+ejbk+^qhgo]hao.
The information in this book is distributed on an “as is” basis, without warranty. Although every precau-
tion has been taken in the preparation of this work, neither the author(s) nor Apress shall have any liability
to any person or entity with respect to any loss or damage caused or alleged to be caused directly or indi-
rectly by the information contained in this work.
The source code for this book is available to readers at dppl6++sss*]lnaoo*_ki.
iii
Contents at a Glance
About the Author .................................................................xix
About the Technical Reviewer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxi
Acknowledgments ...............................................................xxiii
Introduction .................................................................... xxv
CHAPTER 1 SQL Query Performance Tuning ..................................1
CHAPTER 2 System Performance Analysis ..................................17
CHAPTER 3 SQL Query Performance Analysis ...............................61
CHAPTER 4 Index Analysis ................................................101
CHAPTER 5 Database Engine Tuning Advisor ...............................151
CHAPTER 6 Bookmark Lookup Analysis ....................................163
CHAPTER 7 Statistics Analysis .............................................175
CHAPTER 8 Fragmentation Analysis .......................................209
CHAPTER 9 Execution Plan Cache Analysis .................................241
CHAPTER 10 Stored Procedure Recompilation ...............................283
CHAPTER 11 Query Design Analysis .........................................313
CHAPTER 12 Blocking Analysis .............................................351
CHAPTER 13 Deadlock Analysis .............................................401
CHAPTER 14 Cursor Cost Analysis ..........................................415
CHAPTER 15 Database Workload Optimization ...............................439
CHAPTER 16 SQL Server Optimization Checklist .............................475
INDEX .......................................................................497
v
Contents
About the Author .................................................................xix
About the Technical Reviewer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxi
Acknowledgments ...............................................................xxiii
Introduction .................................................................... xxv
CHAPTER 1 SQL Query Performance Tuning .............................1
The Performance-Tuning Process ..................................2
The Core Process ............................................2
Iterating the Process .........................................4
Performance vs. Price .............................................7
Performance Targets .........................................7
“Good Enough” Tuning .......................................7
Performance Baseline .............................................8
Where to Focus Efforts ............................................9
SQL Server Performance Killers ...................................10
Poor Indexing ..............................................11
Inaccurate Statistics ........................................11
Excessive Blocking and Deadlocks ............................11
Non-Set-Based Operations ...................................12
Poor Query Design ..........................................12
Poor Database Design .......................................12
Excessive Fragmentation ....................................13
Nonreusable Execution Plans .................................13
Poor Execution Plans ........................................13
Frequent Recompilation of Execution Plans ....................14
Improper Use of Cursors .....................................14
Improper Configuration of the Database Log ...................14
Excessive Use or Improper Configuration of tempdb .............14
Summary .......................................................15
剩余544页未读,继续阅读
hychieftain
- 粉丝: 317
- 资源: 255
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- 2023年中国辣条食品行业创新及消费需求洞察报告.pptx
- 2023年半导体行业20强品牌.pptx
- 2023年全球电力行业评论.pptx
- 2023年全球网络安全现状-劳动力资源和网络运营的全球发展新态势.pptx
- 毕业设计-基于单片机的液体密度检测系统设计.doc
- 家用清扫机器人设计.doc
- 基于VB+数据库SQL的教师信息管理系统设计与实现 计算机专业设计范文模板参考资料.pdf
- 官塘驿林场林防火(资源监管)“空天地人”四位一体监测系统方案.doc
- 基于专利语义表征的技术预见方法及其应用.docx
- 浅谈电子商务的现状及发展趋势学习总结.doc
- 基于单片机的智能仓库温湿度控制系统 (2).pdf
- 基于SSM框架知识产权管理系统 (2).pdf
- 9年终工作总结新年计划PPT模板.pptx
- Hytera海能达CH04L01 说明书.pdf
- 数据中心运维操作标准及流程.pdf
- 报告模板 -成本分析与报告培训之三.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0