Summary

This chapter talked about several tools used to monitor SQL Server: SQL Server Management Studio Activity Monitor, SQL Server Agent Monitoring and Alerting, SQL Server Profiler, and Microsoft Operations Manager (MOM) via SQL Server Management Pack. It also described some best practices and usage scenarios for each tool.