CHAPTER 13Maintenance Tools

In this chapter, you will learn about:

• System Monitor

• SQL Server Agent

• The Maintenance Plan Wizard

• SQL Server Profiler and SQL Trace

You can't control what you can't measure.

—Tom DeMarco

In a perfect database, nothing ever goes wrong. Then again, if nothing ever went wrong, there wouldn't be much need for database administrators (DBAs) and database developers. Thankfully, there's no such thing as a perfect database and things do go wrong. Successful database administrators and database developers know the tools available help us measure, monitor, and troubleshoot a database application when things do go wrong.

The tools in this chapter will help you measure and monitor your databases. And with proper metrics, ...

Get MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442) now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.