內容簡介
《深入解析SQL Server 2008(英文版)》是講述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
……