From caching to clustering, query processing to Service Broker, this book will help you address even the toughest problems with database engine operations. Each chapter begins with a brief architectural overview of a key SQL Server component, then drills down into the most common problems users encounter, offering specific guidance on investigating and resolving them. You'll find comprehensive, in-depth chapters on
- Waiting and blocking
- Data corruption and recovery
- Memory
- Procedure cache issues
- Query processing
- Server crashes and other critical failures
- Service Broker
- SQLOS and scheduling
- tempdb
- Clustering
