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 ...