Wrox.Professional.SQL.Server.2012.Internals.and.Troubleshooting.Oct.2012.pdf

(13198 KB) Pobierz
996882607.038.png
996882607.039.png 996882607.040.png 996882607.041.png 996882607.001.png 996882607.002.png 996882607.003.png 996882607.004.png 996882607.005.png 996882607.006.png 996882607.007.png
PROFESSIONAL
SQL SERVER® 2012 INTERNALS AND TROUBLESHOOTING
INTRODUCTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxix
PART I
INTERNALS
CHAPTER 1
SQL Server Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
CHAPTER 2
Demystifying Hardware . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29
CHAPTER 3
Understanding Memory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53
CHAPTER 4
Storage Systems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77
CHAPTER 5
Query Processing and Execution . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111
CHAPTER 6
Locking and Concurrency. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149
CHAPTER 7
Latches and Spinlocks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181
CHAPTER 8
Knowing Tempdb . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 211
PART I
TROUBLESHOOTING TOOLS AND LESSONS
FROM THE FIELD
CHAPTER 9
Troubleshooting Methodology and Practices. . . . . . . . . . . . . . . . . . . . . 241
CHAPTER 10
Viewing Server Performance with PerfMon and the PAL Tool . . . . . . 259
CHAPTER 11
Consolidating Data Capture with SQLdiag . . . . . . . . . . . . . . . . . . . . . . . 295
CHAPTER 12
Bringing It All Together with SQL Nexus . . . . . . . . . . . . . . . . . . . . . . . . . 325
CHAPTER 13
Diagnosing SQL Server 2012 Using Extended Events . . . . . . . . . . . . . 349
CHAPTER 14
Enhancing Your Troubleshooting Toolset with PowerShell . . . . . . . . . 379
CHAPTER 15
Delivering a SQL Server Health Check . . . . . . . . . . . . . . . . . . . . . . . . . . 405
CHAPTER 16
Delivering Manageability and Performance . . . . . . . . . . . . . . . . . . . . . . 445
CHAPTER 17
Running SQL Server in a Virtual Environment . . . . . . . . . . . . . . . . . . . . 469
INDEX. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 509
996882607.008.png 996882607.009.png 996882607.010.png 996882607.011.png 996882607.012.png 996882607.013.png 996882607.014.png 996882607.015.png 996882607.016.png 996882607.017.png
996882607.018.png 996882607.019.png 996882607.020.png 996882607.021.png 996882607.022.png 996882607.023.png 996882607.024.png 996882607.025.png 996882607.026.png 996882607.027.png
PROFESSIONAL
SQL Server ® 2012
Internals and Troubleshooting
996882607.028.png 996882607.029.png 996882607.030.png 996882607.031.png 996882607.032.png 996882607.033.png 996882607.034.png 996882607.035.png 996882607.036.png 996882607.037.png

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin