Skip to main content

Professional SQL Server 2008 Internals and Troubleshooting

Professional SQL Server 2008 Internals and Troubleshooting

Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Jonathan Kehayias, Cindy Gross, Steven Wort

ISBN: 978-0-470-63388-5

Jun 2010

624 pages

$38.99

Description

A hands-on resource for SQL Server 2008 troubleshooting methods and tools

SQL Server administrators need to ensure that SQL Server remains running 24/7. Authored by leading SQL Server experts and MVPs, this book provides in-depth coverage of best practices based on a deep understanding of the internals of both SQL Server and the Windows operating system.

You'll get a thorough look at the SQL Server database architecture and internals as well as Windows OS internals so that you can approach troubleshooting with a solid grasp of the total processing environment. Armed with this comprehensive understanding, readers will then learn how to use a suite of tools for troubleshooting performance problems whether they originate on the database server or operating system side.

Topics Covered:

  • SQL Server Architecture
  • Understanding Memory
  • SQL Server Waits and Extended Events
  • Working with Storage
  • CPU and Query Processing
  • Locking and Latches
  • Knowing Tempdb
  • Defining Your Approach To Troubleshooting
  • Viewing Server Performance with PerfMon and the PAL Tool
  • Tracing SQL Server with SQL Trace and Profiler
  • Consolidating Data Collection with SQLDiag and the PerfStats Script
  • Introducing RML Utilities for Stress Testing and Trace File Analysis
  • Bringing It All Together with SQL Nexus
  • Using Management Studio Reports and the Performance Dashboard
  • Using SQL Server Management Data Warehouse
  • Shortcuts to Efficient Data Collection and Quick Analysis

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

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: DEFINING 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 PROFILER 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 EFFICIENT DATA COLLECTION AND QUICK ANALYSIS Wrox.com

INDEX 555

Read Me Download
Additional Code Download
Chapter 16 online only Download
25Error in Text,DDR3 RAM is 4 times (and not 8 times as is listed on page 25) the amount of consecutive data read or writes per operation compared to the original DDR1.3/15/10
354Error in Text,Memory : Pages/sec

the problem condition is less than 500

but it should be

greater than 500
1/11/10