深入解析SQLServer2008
图书信息
书 名: 深入解析SQLServer2008
作者：(美国)德莱尼
出版社：人民邮电出版社
出版时间： 2009年09月
ISBN: 9787115211439
开本： 16开
定价: 99.00 元
内容简介《深入解析SQL Server 2008(英文版)》是讲述SQL Server关系数据库引擎内部机理和架构的权威指南。书中详细阐述了SQL Server处理查询、管理数据的相关内容，包括SQL Server架构和配置、跟踪/扩展事件、日志和恢复、索引、表格、查询优化、事务/并发以及DBCC。
《深入解析SQL Server 2008(英文版)》适合中高级数据库开发人员阅读。
作者简介Kalen Delanay世界知名的SQL Server专家。微软SQLSewer MVP。从1 987年供职Sybase时与微软合作开发最早的SQL Server版本算起。她的SQL Sewer研发经验已达20多年。她本人以对SQL Server底层技术的精湛造诣享誉业内。所著Inside Microsoft SQL Server系列（本书前身）长期以来被奉为圣经级著作。
图书目录1 SQL Server 2008 Architecture and Configuration
SQL Server Editions
SQL Server Metadata
Compatibility Views
Catalog Views
Other Metadata
Components of the SQL Server Engine
Observing Engine Behavior
Protocols
The Relational Engine
The Storage Engine
The SQLOS
NUMA Architecture
The Scheduler
SQL Server Workers
Binding Schedulers to CPUs
The Dedicated Administrator Connection (DAC)
Memory
The Buffer Pool and the Data Cache
Access to In-Memory Data Pages
Managing Pages in the Data Cache
The Free Buffer List and the Lazywriter
Checkpoints
Managing Memory in Other Caches
Sizing Memory
Sizing the Buffer Pool
SQL Server Resource Governor
Resource Governor Overview
Resource Governor Controls
Resource Governor Metadata
SQL Server 2008 Configuration
Using SQL Server Configuration Manager
Configuring Network Protocols
Default Network Configuration
Managing Services
SQL Server System Configuration
Operating System Configuration
Trace Flags
SQL Server Configuration Settings
The Default Trace
Final Words
2 Change Tracking, Tracing, and Extended Events
The Basics: Triggers and Event Notifi cations
Run-Time Trigger Behavior
Change Tracking
Change Tracking Configuration
Change Tracking Run-Time Behavior
Tracing and Profiling
SQL Trace Architecture and Terminology
Security and Permissions
Getting Started: Profi ler
Server-Side Tracing and Collection
Extended Events
Components of the XE Infrastructure
Event Sessions
Extended Events DDL and Querying
Summary
……