Idera SharePoint Performance Monitor: Complete Setup and Configuration Guide

Idera SharePoint Performance Monitor: Key Metrics to Track for Faster Sites

1) SharePoint application & IIS metrics

• Request/sec (IIS): sustained high rates or long-running requests indicate app bottlenecks.
• Request execution time (ms): track average and p95/p99 to spot slow pages.
• Worker process (w3wp) CPU & memory: sustained growth -> memory leak or app pool issues.
• HTTP error rates (4xx/5xx): rising errors point to broken code or auth issues.

2) SQL Server (SharePoint DB) metrics

• SQL CPU (%) and Signal Waits: high values suggest CPU pressure or inefficient queries.
• Wait statistics (PAGEIOLATCH, LCKM*): identify I/O or locking/blocking bottlenecks.
• Transactions/sec & Batch Requests/sec: correlate workload spikes with user impact.
• Buffer cache hit ratio / Page Life Expectancy: memory pressure causing extra disk reads.
• Disk latency (ms) for data and log files: >10–20 ms often degrades SharePoint responsiveness.

3) Storage and I/O metrics

• Disk throughput (MB/sec) and IOPS: ensure backend can sustain SharePoint workload.
• Disk queue length: long queues indicate overloaded storage.
• I/O wait time: correlates with slow page loads and SQL waits.

4) OS and host-level metrics

• CPU utilization (host): sustained >80% requires capacity or tuning.
• Available memory / paging: frequent paging hurts SQL and app performance.
• Network throughput and packet loss: latency or drops cause