• Author:
  • Bolton, Christian
  • Langford, Justin
  • Ozar, Brent
  • Rowland-Jones, James
  • Wort, Steven
• Subject:
  Computer Communications & Networking
• Published by:
  John Wiley & Sons Inc (US)
• Published:
  18/12/2009
• Price:
  $89.99
• <  Buy this book  >

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.

• Shows how to develop a methodology for troubleshooting based on a thorough understanding of SQL Server 2008 and Windows OS internals
• Covers mastering specific troubleshooting tools and interpreting their output so that you can quickly identify and resolve any performance issue
• Details all the free and proprietary tools that allow you to analyze and determine the source of a system-wide performance problem
• Examines how it is critical for both SQL Server and Windows technologies to run smoothly in order to ensure effective SQL Server performance

This practical guide will help you pro-actively monitor and avoid SQL Server problems.

Christian Bolton is coauthor of Professional SQL Server 2005 Performance Tuning and Technical Director for Coeo Ltd.

Justin Langford is coauthor of Professional SQL Server 2005 Performance Tuning and leads the Managed Support team for Coeo Ltd.

Brent Ozar is a SQL Server expert for Quest Software.

James Rowland-Jones is an advisory consultant for EMC Consulting.

Steven Wort is a developer in the Windows Division at Microsoft.