O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide by Andy Warren, J. Steven Jones, Marilyn Miller-White, Victor Isakov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required