请输入您要查询的百科知识:

 

词条 深入解析SQLServer2008
释义

《深入解析SQL Server 2008(英文版)》是讲述SQL Server关系数据库引擎内部机理和架构的权威指南。书中详细阐述了SQL Server处理查询、管理数据的相关内容,包括SQL Server架构和配置、跟踪/扩展事件、日志和恢复、索引、表格、查询优化、事务/并发以及DBCC。

图书信息

书 名: 深入解析SQLServer2008

作 者:(美国)德莱尼

出版社: 人民邮电出版社

出版时间: 2009年09月

ISBN: 9787115211439

开本: 16开

定价: 99.00 元

内容简介

《深入解析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

……

随便看

 

百科全书收录4421916条中文百科知识,基本涵盖了大多数领域的百科知识,是一部内容开放、自由的电子版百科全书。

 

Copyright © 2004-2023 Cnenc.net All Rights Reserved
更新时间:2025/1/9 8:23:46