Professional SQL Server 2008 Internals and Troubleshooting (Paperback)

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

  • 出版商: Wrox Press
  • 出版日期: 2010-01-01
  • 售價: $2,170
  • 貴賓價: 9.5$2,062
  • 語言: 英文
  • 頁數: 624
  • 裝訂: Paperback
  • ISBN: 0470484284
  • ISBN-13: 9780470484289
  • 相關分類: MSSQLSQL
  • 已過版

買這商品的人也買了...

商品描述

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.