Titulo: Professional SQL Server 2012 Internals and Troubleshooting
Autor: Christian Bolton, Justin Langford, Glenn Berry, Gavin Payne, Amit Banerjee, Rob Farley
Editorial: Wrox
Nro Paginas: 580
Capítulos:
PART I INTERNALS
CHAPTER 1 SQL Server Architecture
CHAPTER 2 Demystifying Hardware
CHAPTER 3 Understanding Memory
CHAPTER 4 Storage Systems
CHAPTER 5 Query Processing and Execution
CHAPTER 6 Locking and Concurrency
CHAPTER 7 Latches and Spinlocks
CHAPTER 8 Knowing Tempdb
PART II T ROUBLESHOOTING TOOLS AND LESSONS
FROM THE FIELD
CHAPTER 9 Troubleshooting Methodology and Practices
CHAPTER 10 Viewing Server Performance with PerfMon and the PAL Tool
CHAPTER 11 Consolidating Data Capture with SQLdiag
CHAPTER 12 Bringing It All Together with SQL Nexus
CHAPTER 13 Diagnosing SQL Server 2012 Using Extended Events
CHAPTER 14 Enhancing Your Troubleshooting Toolset with PowerShell
CHAPTER 15 Delivering a SQL Server Health Check
CHAPTER 16 Delivering Manageability and Performance
CHAPTER 17 Running SQL Server in a Virtual Environment
Descarga:
Professional_SQLServer2012_Internals_Troubleshooting
