Monitoring SQL Server in a SharePoint Environment

SharePoint administrators need to know how to proficiently monitor SQL Server performance and storage in SharePoint 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 impacted. This section walks administrators though a range of monitoring tools they should be aware of to efficiently and powerfully monitor, maintain, and troubleshoot SQL Server in SharePoint environments. Topics include WMI, Event Logs, Dynamic Management Views, Reliability and Performance Monitor, Activity Monitor, and Management Data Warehouse. ...

Get Microsoft SharePoint 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.