Professional SQL server 2012 internals and troubleshooting /
Bolton, Christian
Professional SQL server 2012 internals and troubleshooting / Christian Bolton [et..al] - Indiana : John Wiley & Sons Inc. ; 2013. - xxxviii, 536 pages : ill. ; 24cm.
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.
9781118177655
QA76.9 / .I59B6 2013
Professional SQL server 2012 internals and troubleshooting / Christian Bolton [et..al] - Indiana : John Wiley & Sons Inc. ; 2013. - xxxviii, 536 pages : ill. ; 24cm.
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.
9781118177655
QA76.9 / .I59B6 2013