Chapter 15. Monitoring SQL Server 2012
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 any SQL Server 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, there are many ...
Get Microsoft® SQL Server 2012 Management and Administration, Second Edition 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.
