Troubleshooting the Performance of a SQL Server Solution
Troubleshooting the performance problems of a SQL Server 2005 solution can be a time-consuming process. When deciding on a troubleshooting performance, you can basically take two approaches:
Proactive approach With a proactive approach, you typically monitor your SQL Server solution on a regular basis and try to preempt performance issues when you notice that your database solution is reaching some resource or capacity limit.
Reactive approach With a reactive approach, you respond to a certain event, such as users complaining about poor query performance or end-of-day batch processes taking too long.
In most cases, from a pragmatic point of view, the workweek has only 40 hours (at least ...
Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide 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.
