O'Reilly logo

All-In-One MCITP SQL Server 2005 Database Developer by Darril Gibson

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

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

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