Event Logs

An additional aspect of monitoring that is often disregarded by some administrators is monitoring the various log files available. SQL Server logs certain system events and user-defined events to the SQL Server error log and the Microsoft Windows application log.

Administrators can use information in the SQL Server error log to troubleshoot problems related to SQL Server. In fact, browsing the SQL Server logs for irregular entries is an essential administration task; preferably, it should be carried out on a daily basis to help administrators spot current or potential problem areas. An application-aware solution, such as Microsoft’s System Center Operations Manager (SCOM), helps to automate the process of monitoring SQL (and Lync Server) ...

Get Microsoft® Lync Server 2010 Unleashed 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.