TY - BOOK AU - Bolton, Christian AU - Farley, Rob AU - Banerjee, Amit AU - Payne, Gavin AU - Berry, Glenn AU - Langford, Justin TI - Professional SQL server 2012 internals and troubleshooting SN - 9781118177655 AV - QA76.9 .I59B6 2013 PY - 2013/// CY - Indiana PB - John Wiley & Sons Inc. N1 - SQL server architecture -- Demystifying hardware -- Understanding memory -- Storage systems -- Query processing and execution -- Locking and concurrency -- Latches and spinlocks -- Knowing TEMPDB -- Troubleshooting methodology and practices -- Viewing server performance with perfmon and the pal tool -- Consolidating data recapture with SQLDIAG -- Bringing it all together with SQL nexus -- Diagnosis SQL server 2012 using extended events -- Enhancing your troubleshooting toolset with powershell -- Delivering an SQL server health check -- Delivering manageability and performance -- Running SQL server in a virtual environment ER -