What we monitor/feature above and beyond other industry-standard tools:
- Full Resource Governor metrics and configuration statistics with up to workload group detail.
- Very detailed storage capacity & usage statistic collection per specific database file by volume.
- Index recommendations with overtime statistics
- Per database index operational & usage metrics with overtime statistics
- Collection of thread waits, spinlocks & latches with overtime statistics
- Buffer pool memory allocation with per database granularity
- Per NUMA node metrics for memory
- Tempdb allocation patterns (All types of stores, cleanup rates, and contention events)
- Trigger performance metrics over time with the most influential code.
- Audit for changes of server config and database index definitions
- Advanced CPU counters and waiting tasks
Other (more usual) areas covered by our monitoring tool:
- Memory allocation distribution, usage, and its KPI states.
- CPU resource allocation per database or process and related counters.
- Tempdb performance metrics and usage, together with contention points and costly operations.
- Transaction log usage per database and file with its contention points and costly operations.
- Index usage of all indexes on the server and its design changes together with recommendations over time.
- Query performance for the most interesting operations on the server and databases.
- Blocking and deadlocking operations on the server and its victims.
- Memory checkpoint and lazy writer processes with overtime statistics
- AlwaysOn events and configuration.
- Server configuration changes and all its logs such as server, agent, SMT alerts, maintenance, and job automatization.
- Everything was collected and stored for up to 3 years in the past for good trend analysis.
- With schedules configurable per monitoring item with server-specific presets.
- And much more…