Chapter 22. Performance Tuning and Troubleshooting SQL Server 2005
Performance and troubleshooting in SQL Server 2005 go hand in hand for database administrators. Most often, troubleshooting a SQL Server comes down to troubleshooting performance issues.
Performance tuning and troubleshooting performance issues are iterative processes consisting of monitoring, troubleshooting, adjusting, and repeating. When you’re troubleshooting performance, it is helpful to have a goal in mind, such as having a specific query execute in less than X seconds.
Performance tuning and troubleshooting can be viewed as a layered model. The layers consist of the hardware, operating system, SQL Server, database, and application. Each layer is dependent on the layers ...
Get Microsoft® SQL Server 2005 Management and Administration now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
