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