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