Professional SQL Server 2008 Internals and Troubleshooting [Wrox].pdf

(14433 KB) Pobierz
712727597 UNPDF
Join the discussion @ p2p.wrox.com
Wrox Programmer to Programmer™
SQL Server ® 2008
Internals and Troubleshooting
Professional
712727597.064.png 712727597.075.png 712727597.086.png 712727597.097.png 712727597.001.png 712727597.012.png 712727597.017.png 712727597.018.png 712727597.019.png 712727597.020.png 712727597.021.png 712727597.022.png 712727597.023.png 712727597.024.png 712727597.025.png 712727597.026.png 712727597.027.png 712727597.028.png 712727597.029.png 712727597.030.png 712727597.031.png 712727597.032.png
 
712727597.033.png 712727597.034.png 712727597.035.png 712727597.036.png 712727597.037.png 712727597.038.png 712727597.039.png 712727597.040.png 712727597.041.png 712727597.042.png 712727597.043.png 712727597.044.png 712727597.045.png 712727597.046.png
Programmer to Programmer ™
Get more out of
Interact
Take an active role online by participating in our
P2P forums @ p2p.wrox.com
Join the Community
Sign up for our free monthly newsletter at
newsletter.wrox.com
Wrox Online Library
Hundreds of our books are available online
through Books24x7.com
Browse
Ready for more Wrox? We have books and
e-books available on .NET, SQL Server, Java,
XML, Visual Basic, C#/ C++, and much more!
Wrox Blox
Download short informational pieces and code
to keep you up to date and out of trouble!
Contact Us.
We always like to get feedback from our readers. Have a book idea?
wrox.com
712727597.047.png 712727597.048.png
PROFESSIONAL
SQL SERVER ® 2008 INTERNALS
AND TROUBLESHOOTING
INTRODUCTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxv
CHAPTER 1 SQL Server Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
CHAPTER 2 Understanding Memory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
CHAPTER 3 SQL Server Waits and Extended Events . . . . . . . . . . . . . . . . . . . . . . . . . . 59
CHAPTER 4 Working with Storage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95
CHAPTER 5 CPU and Query Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .137
CHAPTER 6 Locking and Latches . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185
CHAPTER 7 Knowing Tempdb . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 269
CHAPTER 8 Defi ning Your Approach To Troubleshooting . . . . . . . . . . . . . . . . . . . . . 305
CHAPTER 9 Viewing Server Performance with PerfMon and the PAL Tool . . . . . . 329
CHAPTER 10 Tracing SQL Server with SQL Trace and Profi ler . . . . . . . . . . . . . . . . . . 369
CHAPTER 11 Consolidating Data Collection with SQLDiag and the
PerfStats Script. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 437
CHAPTER 12 Introducing RML Utilities for Stress Testing and Trace
File Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 459
CHAPTER 13 Bringing It All Together with SQL Nexus . . . . . . . . . . . . . . . . . . . . . . . . . 481
CHAPTER 14 Using Management Studio Reports and the Performance
Dashboard . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 505
CHAPTER 15 Using SQL Server Management Data Warehouse. . . . . . . . . . . . . . . . . 539
CHAPTER 16 Shortcuts to E cient Data Collection and Quick Analysis . . . . Wrox.com
INDEX. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 555
712727597.049.png 712727597.050.png 712727597.051.png 712727597.052.png 712727597.053.png 712727597.054.png 712727597.055.png 712727597.056.png 712727597.057.png 712727597.058.png 712727597.059.png 712727597.060.png 712727597.061.png 712727597.062.png 712727597.063.png 712727597.065.png 712727597.066.png 712727597.067.png 712727597.068.png 712727597.069.png 712727597.070.png 712727597.071.png 712727597.072.png
712727597.073.png 712727597.074.png 712727597.076.png 712727597.077.png 712727597.078.png 712727597.079.png 712727597.080.png 712727597.081.png 712727597.082.png 712727597.083.png 712727597.084.png 712727597.085.png 712727597.087.png 712727597.088.png 712727597.089.png 712727597.090.png 712727597.091.png 712727597.092.png 712727597.093.png 712727597.094.png 712727597.095.png 712727597.096.png 712727597.098.png
PROFESSIONAL
SQL Server ® 2008 Internals
and Troubleshooting
712727597.099.png 712727597.100.png 712727597.101.png 712727597.102.png 712727597.103.png 712727597.104.png 712727597.105.png 712727597.106.png 712727597.107.png 712727597.002.png 712727597.003.png 712727597.004.png 712727597.005.png 712727597.006.png 712727597.007.png 712727597.008.png 712727597.009.png 712727597.010.png 712727597.011.png 712727597.013.png 712727597.014.png 712727597.015.png 712727597.016.png

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin