Documentation

Technical Reference

Performance Monitoring

CPU, memory, I/O and workload baselines collected per instance.

Aggregated wait types such as PAGEIOLATCH, CXPACKET and LCK_M_* with trend analysis.

Regressed plans, top resource consumers and forced plan tracking.

Live blocking chains with head-blocker identification.

Captured deadlock graphs with victim and resource details.

Replica state, synchronization health and failover readiness.

Publisher, distributor and subscriber latency monitoring.

Full, differential and log backup coverage against RPO targets.

Thresholds, routing and notification configuration.

Logins, role membership and permission change auditing.

Scheduled operational and executive reports.