Chapter 17 Monitoring SQL Server 2008 with Native Tools
The detection and resolution of anomalies within SQL Server will always be part of a DBA’s duty. As such, DBAs should be aware that the effectiveness of the detection technique, and the first step to a resolution, lies in the department’s commitment to monitoring. A strong commitment to monitoring is key for ensuring that a SQL Server 2008 system stays operational with as few unplanned interruptions as possible. When anomalies do occur, monitoring ensures that the issues are quickly identified and corrected. Without a strong commitment to monitoring, issues left unattended can quickly grow into major issues if not dealt with, eventually leading to a production outage.
For monitoring enthusiasts, ...
Get Microsoft® SQL Server 2008 Management and Administration 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.
