Professional SQL server 2008 internals and troubleshooting

The book shows how to approach troubleshooting SQL Server 2008 from a thorough understanding of both the SQL Server database architecture and internals as well as Windows OS internals. It shows how to master the use of specific troubleshooting tools, and how to interpret their output to quickly identify and resolve any performance issue on any server running SQL Server. Part 1 discusseshow to develop a methodology for troubleshooting based on an understanding ofSQL Server and Windows internals. It covers the core technical topics required to understand how SQL Server and Windows should be working. Best practices are discussed so you know how to pro-actively monitor and avoid problems. Part 2 deals with the tools of the trade detailing all the free and proprietary tools that professionals use to very quickly gather, analyze and pin down the source of a system wide performance issue. The book uniquely covers both SQL Server and Windows technologies that are necessary for ensuring effective performance of SQL Server processing.

• ISBN: 978-0-470-48428-9
• Editorial: John Wiley & Sons
• Encuadernacion: Rústica
• Páginas: 624
• Fecha Publicación: 13/01/2010
• Nº Volúmenes: 1
• Idioma: Inglés