CONTENTS
Chapter 1: SQL Server Architecture
SQL Server’s Execution Model and the SQLOS
Chapter 2: Demystifying Hardware
How Workload Affects Hardware and Storage Considerations
Choosing and Configuring Hardware for Redundancy
Chapter 3: Understanding Memory
Optimizing SQL Server Memory Configuration
Chapter 5: Query Processing and Execution
Chapter 6: Locking and Concurrency
Chapter 7: Latches and Spinlocks
Understanding Latches and Spinlocks
Monitoring Latches and Spinlocks
Part II: Troubleshooting Tools and Lessons From The Field
Chapter 9: Troubleshooting Methodology and Practices
Validating and Implementing Resolution
Chapter 10: Viewing Server Performance with Perfmon and The PAL Tool
Getting More from Performance Monitor
Other PerfMon Log Analysis Tools
Chapter 11: Consolidating Data Capture with SQLdiag
An Approach to Data Collection
Using SQLdiag Configuration Manager
Chapter 12: Bringing It All Together with SQL Nexus
Getting Familiar with SQL Nexus
Chapter 13: Diagnosing SQL Server 2012 Using Extended Events
Introduction to Extended Events
Getting Familiar with Extended Events
Why you should be Using Extended Events
Creating Extended Events Sessions in SQL Server 2012
Viewing Data Captured by Extended Events
Chapter 14: Enhancing Your Troubleshooting Toolset with Powershell
Getting Started with PowerShell
Using PowerShell to Investigate Server Issues
Proactively Tuning SQL Server Performance with PowerShell
Chapter 15: Delivering A SQL Server Health Check
The Importance of a SQL Server Health Check
Chapter 16: Delivering Manageability and Performance
Improve Efficiency with SQL Server Manageability Features
Manageability Enhancements in SQL Server 2012
Other Microsoft Tools for Managing SQL Server
Chapter 17: Running SQL Server in A Virtual Environment
The Shift to Server Virtualization
Common Virtualization Products
Extended Features of Virtualization
Identifying Candidates for Virtualization
Architecting Successful Virtual Database Servers