没有合适的资源?快使用搜索试试~ 我知道了~
首页Pro SQL Server 2012 Practices
Pro SQL Server 2012 Practices is an anthology of high-end wisdom from a group of accomplished database administrators who are quietly but relentlessly pushing the performance and feature envelope of Microsoft SQL Server 2012. With an emphasis upon performance—but also branching into release management, auditing, and other issues—the book helps you deliver the most value for your company’s investment in Microsoft’s flagship database system. Goes beyond the manual to cover good techniques and best practices Delivers knowledge usually gained only by hard experience Focuses upon performance, scalability, reliability Helps achieve the predictability needed to be in control at all times
资源详情
资源评论
资源推荐
Ball, et. al.
Shelve in
Databases / MS SQL Server
User level:
Intermediate–Advanced
www.apress.com
SOURCE CODE ONLINE
BOOKS FOR PROFESSIONALS BY PROFESSIONALS
®
Pro SQL Server 2012 Practices
Become a top-notch database administrator (DBA) or database programmer with Pro
SQL Server 2012 Practices. Led by a group of accomplished DBAs, you’ll discover
how to take control of, plan for, and monitor performance; troubleshoot effectively
when things go wrong; and be in control of your SQL Server environment.
Each chapter tackles a specific problem, technology, or feature set and provides
you with proven techniques and best practices. You’ll learn how to
• Select and size the server for SQL Server 2012
• Migrate to the new, Extended Events framework
• Automate tracking of key performance indicators
• Manage staged releases from development to production
• Design performance into your applications
• Analyze I/O patterns and diagnose resource problems
• Back up and restore using availability groups
Don’t let your database manage you! Instead turn to Pro SQL Server 2012 Practices
and learn the knowledge and skills you need to get the most from Microsoft’s flagship
database system.
RELATED
For your convenience Apress has placed some of the front
matter material after the index. Please use the Bookmarks
and Contents at a Glance links to access them.
Download from Wow! eBook <www.wowebook.com>
iv
Contents at a Glance
About the Authors...............................................................................................................xiv
About the Technical Reviewers .......................................................................................... xix
Acknowledgments .............................................................................................................. xxi
Introduction ......................................................................................................................xxiii
Chapter 1: Be Your Developer’s Best Friend .........................................................................1
Chapter 2: Getting It Right: Designing the Database for Performance ..............................17
Chapter 3: Hidden Performance Gotchas ...........................................................................43
Chapter 4: Dynamic Management Views ............................................................................71
Chapter 5: From SQL Trace to Extended Events ...............................................................101
Chapter 6: The Utility Database ........................................................................................135
Chapter 7: Indexing Outside the Bubble ...........................................................................161
Chapter 8: Release Management ......................................................................................197
Chapter 9: Compliance and Auditing ................................................................................221
Chapter 10: Automating Administration ...........................................................................235
Chapter 11: The Fluid Dynamics of SQL Server Data Movement .....................................271
Chapter 12: Windows Azure SQL Database for DBAs ......................................................293
Chapter 13: I/O: The Untold Story ....................................................................................313
Chapter 14: Page and Row Compression .........................................................................335
Chapter 15: Selecting and Sizing the Server ....................................................................361
Chapter 16: Backups and Restores Using Availability Groups ........................................375
Chapter 17: Big Data for the SQL Server DBA ..................................................................395
Chapter 18: Tuning for Peak Load .....................................................................................429
Index ..................................................................................................................................465
v
Contents
About the Authors...............................................................................................................xiv
About the Technical Reviewers .......................................................................................... xix
Acknowledgments .............................................................................................................. xxi
Introduction ......................................................................................................................xxiii
Chapter 1: Be Your Developer’s Best Friend .........................................................................1
My Experience Working with SQL Server and Developers .....................................................1
Reconciling Different Viewpoints Within an Organization .......................................................2
Preparing to Work with Developers to Implement Changes to a System ...............................3
Step 1: Map Your Environment ...............................................................................................3
Step 2: Describe the New Environment ..................................................................................5
Step 3: Create a Clear Document ...........................................................................................7
Step 4: Create System-Management Procedures ..................................................................7
Step 5: Create Good Reporting .............................................................................................10
Ensuring Version Compatibility .............................................................................................11
Setting Limits .......................................................................................................................12
Logon Triggers ..............................................................................................................................................12
Policy-Based Management ...........................................................................................................................15
Logging and Resource Control......................................................................................................................15
Next Steps ............................................................................................................................15
Chapter 2: Getting It Right: Designing the Database for Performance ..............................17
Requirements .......................................................................................................................18
Table Structure .....................................................................................................................20
A Really Quick Taste of History .....................................................................................................................20
■ contents
vi
Why a Normal Database Is Better Than an Extraordinary One ...................................................................21
Physical Model Choices ................................................................................................................................33
Design Testing ......................................................................................................................40
Conclusion ............................................................................................................................41
Chapter 3: Hidden Performance Gotchas ...........................................................................43
Predicates ............................................................................................................................43
Residuals ..............................................................................................................................59
Spills .....................................................................................................................................65
Conclusion ............................................................................................................................70
Chapter 4: Dynamic Management Views ............................................................................71
Understanding the Basics ....................................................................................................71
Naming Convention ......................................................................................................................................72
Groups of Related Views ...............................................................................................................................72
Varbinary Hash Values ..................................................................................................................................73
Common Performance-Tuning Queries ................................................................................74
Retrieving Connection Information ...............................................................................................................74
Showing Currently Executing Requests ........................................................................................................75
Locking Escalation ........................................................................................................................................77
Finding Poor Performing SQL .......................................................................................................................78
Using the Power of DMV Performance Scripts .............................................................................................80
Divergence in Terminology ...........................................................................................................................82
Optimizing Performance ...............................................................................................................................82
Inspecting Performance Stats ......................................................................................................................85
Top Quantity Execution Counts .....................................................................................................................86
Physical Reads .............................................................................................................................................87
Physical Performance Queries .............................................................................................87
Locating Missing Indexes .............................................................................................................................87
Partition Statistics ........................................................................................................................................92
System Performance Tuning Queries ...................................................................................93
What You Need to Know About System Performance DMVs .........................................................................93
Sessions and Percentage Complete .............................................................................................................93
Conclusion ............................................................................................................................99
Chapter 5: From SQL Trace to Extended Events ...............................................................101
SQL Trace ............................................................................................................................101
Trace rowset provider .................................................................................................................................103
剩余493页未读,继续阅读
hychieftain
- 粉丝: 317
- 资源: 255
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- 27页智慧街道信息化建设综合解决方案.pptx
- 计算机二级Ms-Office选择题汇总.doc
- 单链表的插入和删除实验报告 (2).docx
- 单链表的插入和删除实验报告.pdf
- 物联网智能终端项目设备管理方案.pdf
- 如何打造品牌的模式.doc
- 样式控制与页面布局.pdf
- 武汉理工Java实验报告(二).docx
- 2021线上新品消费趋势报告.pdf
- 第3章 Matlab中的矩阵及其运算.docx
- 基于Web的人力资源管理系统的必要性和可行性.doc
- 基于一阶倒立摆的matlab仿真实验.doc
- 速运公司物流管理模式研究教材
- 大数据与管理.pptx
- 单片机课程设计之步进电机.doc
- 大数据与数据挖掘.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0