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.
1000 Item Items
Warning: Last items in stock!
|AUTHOR||CHRISTIAN BOLTON, JUSTIN LANGFORD, BRENT OZAR, JAMES ROWLAND-JONES, STEVEN WORT|
|publisher||Wiley India Pvt Ltd|
|TITLE||PROFESSIONAL SQL SERVER 2008 INTERNALS AND TROUBLESHOOTING|
|Number of Page||620|
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 discusses how to develop a methodology for troubleshooting based on an understanding of SQL 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.