Professional SQL Server 2012 Internals and Troubleshooting

CONTENTS

Part I: Internals

Chapter 1: SQL Server Architecture

Introduction

Database Transactions

The Life Cycle of a Query

SQL Server’s Execution Model and the SQLOS

Summary

Chapter 2: Demystifying Hardware

The Importance of Hardware

How Workload Affects Hardware and Storage Considerations

Processor Vendor Selection

Choosing and Configuring Hardware for Redundancy

Hardware Comparison Tools

Summary

Chapter 3: Understanding Memory

Introduction

Physical and Virtual Memory

SQL Server Memory

Optimizing SQL Server Memory Configuration

Summary

Chapter 4: Storage Systems

Introduction

SQL Server I/O

Storage Technology

Measuring Performance

Summary

Chapter 5: Query Processing and Execution

Introduction

Query Processing

Query Optimization

Query Plans

Executing Your Queries

Summary

Chapter 6: Locking and Concurrency

Overview

Transactions

Database Transactions

The Dangers of Concurrency

Locks

Lock Escalation

Deadlocks

Isolation Levels

Summary

Chapter 7: Latches and Spinlocks

Overview

Symptoms

Susceptible Systems

Understanding Latches and Spinlocks

Latch Types

Latch Modes

SuperLatches/Sublatches

Monitoring Latches and Spinlocks

Latch Contention Examples

Summary

Chapter 8: Knowing Tempdb

Introduction

Overview and Usage

Troubleshooting Common Issues

Configuration Best Practices

Summary

Part II: Troubleshooting Tools and Lessons From The Field

Chapter 9: Troubleshooting Methodology and Practices

Introduction

Approaching Problems

Defining the Problem

Data Collection

Data Analysis

Validating and ...