O'Reilly logo

Microsoft by Hilary Cotter, Ross Mistry

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

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