Professional SQL Server 2008 Internals and Troubleshooting
Wrox | 2010 | ISBN: 0470484284 | 624 pages | PDF | 10,1 MB
SQL Server administrators need to ensure that SQL Server remains running 24/7. Authored by leading SQL Server experts and MVPs, this book pres 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
