Troubleshooting Overview
In a perfect world, your database application is well designed; the hardware configuration that it is running on meets or exceeds the demands of the workload; you have full control on the environment; applications and users interact with SQL Server using well-formed Transact-SQL queries and don’t make mistakes. However, that is rarely the case. A large numbers of IT shops run independent software vendor (ISV) applications and have almost no control over its design. Over time, the workload outgrows the hardware capacity. Many applications may run on the same hardware and may interfere with SQL Server. Workload may change drastically over a short period of time. And finally, a user mistake, like dropping an index, may ...
Get Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization 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.
