Monitoring SQL 2008 R2

Lync Server administrators need to know how to proficiently monitor SQL Server performance and storage in Lync Server environments. Understanding monitoring strategies and tools enables administrators to shift from reactively dealing with issues to proactively troubleshooting and fixing problems before the server gets to the point where end users are affected.

This section walks administrators through a range of monitoring tools to efficiently and powerfully monitor, maintain, and troubleshoot SQL Server in Lync Server environments. Topics in this section include

• WMI

• Event logs

• Dynamic management views

• Reliability and performance monitor

• Activity monitor

• Management data warehouse

With a vast range of monitoring tools available, choosing the right tool for the job is an important skill.