Metrics reference
This page is generated from the plug-in’s own target metadata, for the exact build you deploy, rather than written by hand - so it cannot drift from what the plug-in actually collects. Where another page and this one disagree on a column name, a unit or a threshold, this page is authoritative.
It covers all 71 metric groups and 527 columns on the ip_mssql_database target type, each with its collection schedule, its columns, their display labels and units, and the default thresholds that ship.
How to read a metric group
Every entry has the same shape. The heading gives the group’s display name, its internal name in parentheses - the name EM CLI, thresholds and the metric browser use - and its collection schedule. One sentence underneath says what the group collects and where the values come from. Then the column table:
| Column | What it tells you |
|---|---|
| Column | The column’s internal name, in the form EM CLI and threshold commands take. A (key) marker means the column is part of the group’s key, so the group returns one row per distinct key value - per database, per index, per wait type - rather than a single row. A group with no key column returns exactly one row per collection. |
| Label | The display name shown in the console. |
| Unit | The unit Enterprise Manager labels the value with, for example KB, SECOND, PERCENTAGE or BOOLEAN. NA means the value carries no unit - a count, a state or a string. |
| Warning / Critical | The default threshold that ships for the column, with its operator. A blank cell means no default threshold, which is the normal case: 13 curated thresholds ship, listed on Alerts and thresholds. A blank cell is not an omission and it does not stop you setting your own. |
Groups marked configuration snapshot in their heading behave differently. They collect into Enterprise Manager’s configuration history rather than into the metric tables, which is what makes an instance’s settings comparable over time and against other instances under Enterprise -> Configuration, and what the compliance rules evaluate. They carry no thresholds and raise no alerts.
Some groups are empty on a given instance by design rather than by fault - the AlwaysOn families on a standalone server, the cluster families under Pacemaker, the Windows registry family on Linux. An empty group is the plug-in reporting that the feature is not present, not a collection failure.
Microsoft SQL Server Database (ip_mssql_database)
Response (Response) - collected every 1 Min
Availability. EM derives the target’s Up/Down state from the Status column; a Status below 1 raises the target-down event. This is the only group whose condition is an availability condition rather than a metric threshold.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
Status |
Status (up/down) | NA | < 1 |
Memory Usage (MemoryUsage) - collected every 15 Min
Host and SQL Server memory from sys.dm_os_sys_memory and sys.dm_os_process_memory - physical and page-file totals, what the SQL Server process holds, and the OS memory-state description.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
total_physical_memory_kb |
Total Physical Memory (KB) | KB | ||
available_physical_memory_kb |
Available Physical Memory (KB) | KB | ||
server_memory_kb |
Host Used Memory (KB) | KB | ||
total_page_file_kb |
Total Page File (KB) | KB | ||
available_page_file_kb |
Available Page File (KB) | KB | ||
system_memory_state_desc |
System Memory State | NA | ||
sql_process_memory_kb |
SQL Server Process Memory (KB) | KB |
Processor (Processor) - collected every 15 Min
CPU counts and utilization from sys.dm_os_sys_info and the scheduler ring buffer, split into the SQL Server process, other processes, and idle. On SQL Server 2017 and later on Linux the ring buffer reports a fabricated 100% - see the known-limitations section of the Early-Access guide.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
cpu_count |
CPU Count | NA | ||
hyperthread_ratio |
Hyperthread Ratio | NA | ||
sql_process_utilization |
SQL Process CPU (%) | PERCENTAGE | ||
system_idle |
System Idle (%) | PERCENTAGE | ||
other_process_utilization |
Other Process CPU (%) | PERCENTAGE | ||
cpu_utilization_pct |
CPU Utilization (%) | PERCENTAGE | > 80 | > 90 |
Volume Space (VolumeSpace) - collected every 15 Min
Total and available space per volume hosting database files, from sys.dm_os_volume_stats. One row per distinct mount point.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
volume_mount_point (key) |
Volume Mount Point | NA | ||
logical_volume_name |
Logical Volume Name | NA | ||
total_bytes |
Total Bytes | BYTE | ||
available_bytes |
Available Bytes | BYTE | ||
available_pct |
Available (%) | PERCENTAGE |
SQL Server Configuration (SQLServer) - collected every 24 Hr
Instance identity and edition - server and machine name, edition, product version and level, collation, and whether the instance is clustered, HADR-enabled or integrated-security only.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
server_name |
Server Name | NA | ||
machine_name |
Machine Name | NA | ||
instance_name |
Instance Name | NA | ||
edition |
Edition | NA | ||
product_version |
Product Version | NA | ||
product_level |
Product Level | NA | ||
collation |
Server Collation | NA | ||
is_clustered |
Is Clustered (FCI) | BOOLEAN | ||
is_hadr_enabled |
Is AlwaysOn AG Enabled | BOOLEAN | ||
is_integrated_security_only |
Windows-Authentication-Only Mode | BOOLEAN |
Databases (Database) - collected every 24 Hr
Per-database inventory from sys.databases - state, recovery model, compatibility level, collation, creation date, and the log-reuse wait that explains why a log is not truncating.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
database_name (key) |
Database Name | NA | ||
database_id |
Database ID | NA | ||
state_desc |
State | NA | ||
recovery_model_desc |
Recovery Model | NA | ||
compatibility_level |
Compatibility Level | NA | ||
collation_name |
Collation | NA | ||
create_date |
Create Date | NA | ||
is_read_only |
Is Read Only | BOOLEAN | ||
containment_desc |
Containment | NA | ||
log_reuse_wait_desc |
Log Reuse Wait | NA |
Database Settings (DatabaseSetting) - collected every 24 Hr
Per-database options that matter for correctness and performance: auto-close, auto-shrink, auto-create and auto-update statistics, page verification, snapshot isolation, read-committed snapshot, trustworthy, and Service Broker.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
database_name (key) |
Database Name | NA | ||
is_auto_close_on |
Auto Close | BOOLEAN | ||
is_auto_shrink_on |
Auto Shrink | BOOLEAN | ||
is_auto_create_stats_on |
Auto Create Statistics | BOOLEAN | ||
is_auto_update_stats_on |
Auto Update Statistics | BOOLEAN | ||
page_verify_option_desc |
Page Verify Option | NA | ||
snapshot_isolation_state_desc |
Snapshot Isolation | NA | ||
is_read_committed_snapshot_on |
Read Committed Snapshot | BOOLEAN | ||
is_trustworthy_on |
Trustworthy | BOOLEAN | ||
is_broker_enabled |
Service Broker Enabled | BOOLEAN |
Database Status (DatabaseStatus) - collected every 24 Hr
Per-database availability state - online/offline/restoring, user access mode, standby, read-only, and whether the database is encrypted.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
database_name (key) |
Database Name | NA | ||
database_id |
Database ID | NA | ||
state_desc |
State | NA | ||
user_access_desc |
User Access | NA | ||
is_in_standby |
Is In Standby | BOOLEAN | ||
is_read_only |
Is Read Only | BOOLEAN | ||
is_encrypted |
Is Encrypted (TDE) | BOOLEAN |
Server Configuration Parameters (DatabaseParameter) - collected every 24 Hr
Server-level settings from sys.configurations: the configured value, the value in use, the permitted range, and whether the setting is dynamic or advanced. One row per setting.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
parameter_name (key) |
Parameter Name | NA | ||
configuration_id |
Configuration ID | NA | ||
value |
Configured Value | NA | ||
value_in_use |
Running Value | NA | ||
minimum |
Minimum | NA | ||
maximum |
Maximum | NA | ||
is_dynamic |
Is Dynamic | BOOLEAN | ||
is_advanced |
Is Advanced | BOOLEAN |
Database Files (DatabaseFile) - collected every 24 Hr
Every data and log file from sys.master_files - type, physical path, state, current and maximum size, and the autogrowth setting including whether growth is a percentage. Needs VIEW ANY DEFINITION; without it the group is permanently empty.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
database_name (key) |
Database Name | NA | ||
logical_name (key) |
Logical Name | NA | ||
file_id |
File ID | NA | ||
type_desc |
File Type | NA | ||
physical_name |
Physical Path | NA | ||
state_desc |
State | NA | ||
size_kb |
Size (KB) | KB | ||
max_size_kb |
Max Size (KB, -1=unlimited) | KB | ||
growth_raw |
Growth (pages or percent) | NA | ||
is_percent_growth |
Growth Is Percent | BOOLEAN |
File Groups (FileGroup) - collected every 24 Hr
Filegroups per database - type, default and read-only flags, the number of files in the group, and the group’s total size.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
database_name (key) |
Database Name | NA | ||
filegroup_name (key) |
File Group Name | NA | ||
filegroup_id |
File Group ID | NA | ||
type_desc |
Type | NA | ||
is_default |
Is Default | BOOLEAN | ||
is_read_only |
Is Read Only | BOOLEAN | ||
file_count |
File Count | NA | ||
total_size_kb |
Total Size (KB) | KB |
Database Free Space (DbFreespace) - collected every 24 Hr
Allocated, used and free space per database with the free percentage, which carries the ships-enabled low-free-space threshold.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
database_name (key) |
Database Name | NA | ||
allocated_kb |
Allocated (KB) | KB | ||
used_kb |
Used (KB) | KB | ||
free_kb |
Free (KB) | KB | ||
free_pct |
Free (%) | PERCENTAGE | < 15 | < 5 |
Host Info (HostInfo) - collected every 1 Hr
Operating system platform, distribution, release, service pack and SKU from sys.dm_os_host_info, which is what makes the host families Linux-safe.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
host_platform |
Host Platform | NA | ||
host_distribution |
Host Distribution | NA | ||
host_release |
Host Release | NA | ||
host_service_pack_level |
Host Service Pack Level | NA | ||
host_sku |
Host SKU (Windows only) | NA | ||
os_language_version |
OS Language Version | NA |
Registry Setting (RegistrySetting) - collected every 24 Hr
Windows registry values for the instance. Windows-only enrichment; the group returns an empty result on Linux rather than erroring.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
registry_key (key) |
Registry Key | NA | ||
value_name (key) |
Value Name | NA | ||
value_data |
Value Data | NA |
FCI / Cluster Identity (FciIdentity) - collected every 15 Min
Failover-cluster identity - whether the instance is clustered, the active node, and the external-cluster boundary flag that marks a Linux instance whose availability is managed by Pacemaker rather than WSFC.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
is_clustered |
Is Clustered (FCI) | BOOLEAN | ||
machine_name |
Virtual Machine Name | NA | ||
active_node |
Active Node | NA | ||
host_platform |
Host Platform | NA | ||
has_availability_group |
Hosts Availability Group | BOOLEAN | ||
external_cluster_boundary |
External Cluster Boundary (Pacemaker) | BOOLEAN |
Cluster Nodes (ClusterNodes) - collected every 15 Min
WSFC cluster node list with each node’s status and whether it currently owns the instance. Empty on a standalone instance, and empty by design under Pacemaker, where WSFC node detail does not exist.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
node_name (key) |
Node Name | NA | ||
status |
Status | NA | ||
status_description |
Status Description | NA | ||
is_current_owner |
Is Current Owner | BOOLEAN |
General Statistics (GeneralStatistics) - collected every 30 Min
SQL Server General Statistics performance counters - connections, processes and logins per second. One row per counter.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
counter_name (key) |
Counter | NA | ||
cntr_type |
Counter Type | NA | ||
cntr_value |
Value | NA |
SQL Statistics (SQLStatistics) - collected every 10 Min
SQL Server SQL Statistics performance counters - batch requests, compilations and recompilations. One row per counter.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
counter_name (key) |
Counter | NA | ||
cntr_type |
Counter Type | NA | ||
cntr_value |
Value | NA |
Access Methods (AccessMethods) - collected every 30 Min
SQL Server Access Methods performance counters - scans, page splits, and index and table access rates. One row per counter.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
counter_name (key) |
Counter | NA | ||
cntr_type |
Counter Type | NA | ||
cntr_value |
Value | NA |
Buffer Manager (BufferManager) - collected every 15 Min
SQL Server Buffer Manager performance counters - page life expectancy, buffer cache hit ratio, and page read/write rates. One row per counter.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
counter_name (key) |
Counter | NA | ||
cntr_type |
Counter Type | NA | ||
cntr_value |
Value | NA |
Memory Manager (MemoryManager) - collected every 15 Min
SQL Server Memory Manager performance counters - target and total server memory, grants pending, and memory-clerk totals. One row per counter.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
counter_name (key) |
Counter | NA | ||
cntr_type |
Counter Type | NA | ||
cntr_value |
Value | NA |
Latches (Latches) - collected every 15 Min
SQL Server Latches performance counters - latch waits and average latch wait time. One row per counter.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
counter_name (key) |
Counter | NA | ||
cntr_type |
Counter Type | NA | ||
cntr_value |
Value | NA |
Cache Manager (CacheManager) - collected every 15 Min
SQL Server Plan Cache performance counters per cache type - cache hit ratio, object counts and pages in use. Keyed by counter and cache instance.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
counter_name (key) |
Counter | NA | ||
instance_name (key) |
Cache Type | NA | ||
cntr_type |
Counter Type | NA | ||
cntr_value |
Value | NA |
Process Stats (ProcessStats) - collected every 15 Min
The SQL Server process’s own memory footprint from sys.dm_os_process_memory - physical memory in use, committed and reserved virtual address space, page faults, and the process memory-utilization percentage.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
physical_memory_in_use_kb |
Physical Memory In Use (KB) | KB | ||
virtual_address_space_committed_kb |
VAS Committed (KB) | KB | ||
virtual_address_space_reserved_kb |
VAS Reserved (KB) | KB | ||
page_fault_count |
Page Faults | NA | ||
memory_utilization_percentage |
Memory Utilization (%) | PERCENTAGE |
Memory Statistics (MemoryStatistics) - collected every 15 Min
Derived cache and contention ratios computed in the collection rather than read raw: buffer and plan cache hit ratios, and average latch and lock wait times. The two hit ratios are computed from the ratio/base counter pair, which is a rolling window rather than a lifetime accumulator.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
buffer_cache_hit_ratio_pct |
Buffer Cache Hit Ratio per Interval (%) | PERCENTAGE | ||
plan_cache_hit_ratio_pct |
Plan Cache Hit Ratio per Interval (%) | PERCENTAGE | ||
avg_latch_wait_ms |
Avg Latch Wait per Interval (ms) | MILLISECONDS | ||
avg_lock_wait_ms |
Avg Lock Wait per Interval (ms) | MILLISECONDS |
Server Statistics (ServerStatistics) - collected every 15 Min
Instance-wide totals from sys.sysprocesses and @@-style counters - CPU and I/O busy time, packet counts and errors, connection counts, and derived CPU-busy and packet-error percentages.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
cpu_busy |
CPU Busy (ticks) | NA | ||
io_busy |
IO Busy (ticks) | NA | ||
idle |
Idle (ticks) | NA | ||
pack_sent |
Packets Sent | NA | ||
pack_received |
Packets Received | NA | ||
packet_errors |
Packet Errors | NA | ||
total_read |
Total Reads | NA | ||
total_write |
Total Writes | NA | ||
total_errors |
Total Errors | NA | ||
connections |
Connections | NA | ||
max_connections |
Max Connections | NA | ||
cpu_busy_pct |
CPU Busy (%) | PERCENTAGE | ||
packet_error_pct |
Packet Error (%) | PERCENTAGE |
Latch Wait Time (LatchWaitTime) - collected every 15 Min
Average latch wait time in milliseconds, isolated as a single numeric row so it can be charted as a trend.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
avg_latch_wait_ms |
Avg Latch Wait per Interval (ms) | MILLISECONDS |
Availability Groups (AvailabilityGroups) - collected every 15 Min
One row per availability group - the current primary replica, the primary and secondary recovery health, and the group’s overall synchronization health.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
group_id (key) |
Group ID | NA | ||
group_name |
Group Name | NA | ||
primary_replica |
Primary Replica | NA | ||
primary_recovery_health_desc |
Primary Recovery Health | NA | ||
secondary_recovery_health_desc |
Secondary Recovery Health | NA | ||
synchronization_health_desc |
Synchronization Health | NA |
Availability Replicas (Replicas) - collected every 15 Min
One row per replica in every availability group - server name, role, operational and connected state, recovery health, synchronization health, and join state.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
replica_id (key) |
Replica ID | NA | ||
group_id |
Group ID | NA | ||
replica_server_name |
Replica Server | NA | ||
is_local |
Is Local | BOOLEAN | ||
role_desc |
Role | NA | ||
operational_state_desc |
Operational State | NA | ||
connected_state_desc |
Connected State | NA | ||
recovery_health_desc |
Recovery Health | NA | ||
synchronization_health_desc |
Synchronization Health | NA | ||
join_state_desc |
Join State | NA |
Availability Databases (AvailabilityDatabases) - collected every 15 Min
Per-database, per-replica failover state - whether the database is failover-ready, joined, or pending suspend, plus the recovery and truncation LSNs.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
replica_id (key) |
Replica ID | NA | ||
group_database_id (key) |
Group Database ID | NA | ||
database_name |
Database Name | NA | ||
is_failover_ready |
Is Failover Ready | BOOLEAN | ||
is_pending_secondary_suspend |
Is Pending Secondary Suspend | BOOLEAN | ||
is_database_joined |
Is Database Joined | BOOLEAN | ||
recovery_lsn |
Recovery LSN | NA | ||
truncation_lsn |
Truncation LSN | NA |
Replica Databases (ReplicaDatabases) - collected every 15 Min
Per-database synchronization state on each replica - synchronization state and health, and whether data movement is suspended.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
group_id (key) |
Group ID | NA | ||
replica_id (key) |
Replica ID | NA | ||
database_id (key) |
Database ID | NA | ||
database_name |
Database Name | NA | ||
is_local |
Is Local | BOOLEAN | ||
is_primary_replica |
Is Primary Replica | BOOLEAN | ||
synchronization_state_desc |
Synchronization State | NA | ||
synchronization_health_desc |
Synchronization Health | NA | ||
is_suspended |
Is Suspended | BOOLEAN |
AlwaysOn Cluster (WSFC Quorum) (HadrCluster) - collected every 15 Min
The WSFC quorum backing AlwaysOn - cluster name, quorum type and quorum state. Empty on an instance with no cluster.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
cluster_name (key) |
Cluster Name | NA | ||
quorum_type |
Quorum Type | NA | ||
quorum_type_desc |
Quorum Type Description | NA | ||
quorum_state |
Quorum State | NA | ||
quorum_state_desc |
Quorum State Description | NA |
AlwaysOn Enabled (HadrEnabled) - collected every 15 Min
Whether the AlwaysOn Availability Groups feature is enabled on the instance. A single flag, collected so a target can be told apart from one where AlwaysOn is merely unused.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
is_hadr_enabled |
Is AlwaysOn Enabled | BOOLEAN |
AG Failover Readiness (AgFailoverReadiness) - collected every 15 Min
The flagship AlwaysOn surface: per-database recovery point and recovery time estimates, the send and redo queue depths behind them, the redo rate, a synchronization-state composite, and a link-health flag. Four of these columns carry thresholds. Primary-authoritative - the group is empty on a secondary replica and on a non-AG instance, because only the primary can measure the queues.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
group_id (key) |
AG ID | NA | ||
group_database_id (key) |
AG Database ID | NA | ||
replica_id (key) |
Replica ID | NA | ||
ag_name |
Availability Group | NA | ||
database_name |
Database | NA | ||
replica_server_name |
Secondary Replica | NA | ||
synchronization_state_desc |
Synchronization State | NA | ||
synchronization_health_desc |
Synchronization Health | NA | ||
is_suspended |
Suspended | BOOLEAN | ||
log_send_queue_kb |
Log Send Queue (KB) | KB | > 1048576 | > 5242880 |
redo_queue_kb |
Redo Queue (KB) | KB | > 1048576 | > 5242880 |
redo_rate_kb_s |
Redo Rate (KB/s) | KBPS | ||
rpo_seconds |
RPO - Est. Data Loss (s) | SECOND | > 300 | > 900 |
rto_seconds |
RTO - Est. Recovery (s) | SECOND | ||
readiness |
Failover Ready (1/0) | BOOLEAN | ||
link_healthy |
Replica Link Healthy (1/0) | BOOLEAN | < 1 | |
last_commit_primary |
Primary Last Commit | NA | ||
last_commit_secondary |
Secondary Last Commit | NA |
Database Mirroring (MirroringMonitoring) - collected every 15 Min
Legacy database mirroring state per database - mirroring state, role, safety level, partner and witness, and the redo queue. Empty when no database is mirrored.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
database_id (key) |
Database ID | NA | ||
database_name |
Database Name | NA | ||
mirroring_state_desc |
Mirroring State | NA | ||
mirroring_role_desc |
Mirroring Role | NA | ||
mirroring_safety_level_desc |
Safety Level | NA | ||
mirroring_partner_name |
Partner Name | NA | ||
mirroring_partner_instance |
Partner Instance | NA | ||
mirroring_witness_name |
Witness Name | NA | ||
mirroring_witness_state_desc |
Witness State | NA | ||
mirroring_redo_queue_kb |
Redo Queue (KB) | KB |
Database Mirroring Statistics (MirroringStatistics) - collected every 15 Min
Database Mirroring performance counters per mirrored database - send and redo queue sizes and transaction rates. Empty when no database is mirrored.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
counter_name (key) |
Counter Name | NA | ||
cntr_type |
Counter Type | NA | ||
instance_name (key) |
Database | NA | ||
cntr_value |
Counter Value | NA |
SQL Server Instance Configuration (SQLServerConfig) - configuration snapshot, collected every 24 Hr
Configuration snapshot of SQL Server Instance Configuration, captured for configuration history and compliance evaluation rather than for alerting.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
SERVER_NAME |
Server Name | NA | ||
MACHINE_NAME |
Machine Name | NA | ||
INSTANCE_NAME |
Instance Name | NA | ||
EDITION |
Edition | NA | ||
PRODUCT_VERSION |
Product Version | NA | ||
PRODUCT_LEVEL |
Product Level | NA | ||
COLLATION |
Server Collation | NA | ||
IS_CLUSTERED |
Is Clustered (FCI) | NA | ||
IS_HADR_ENABLED |
Is AlwaysOn AG Enabled | NA | ||
IS_INTEGRATED_SECURITY_ONLY |
Windows-Authentication-Only Mode | NA |
Database Settings Configuration (DatabaseSettingConfig) - configuration snapshot, collected every 24 Hr
Configuration snapshot of Database Settings Configuration, captured for configuration history and compliance evaluation rather than for alerting.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
DATABASE_NAME (key) |
Database Name | NA | ||
IS_AUTO_CLOSE_ON |
Auto Close | NA | ||
IS_AUTO_SHRINK_ON |
Auto Shrink | NA | ||
IS_AUTO_CREATE_STATS_ON |
Auto Create Statistics | NA | ||
IS_AUTO_UPDATE_STATS_ON |
Auto Update Statistics | NA | ||
PAGE_VERIFY_OPTION_DESC |
Page Verify Option | NA | ||
SNAPSHOT_ISOLATION_STATE_DESC |
Snapshot Isolation | NA | ||
IS_READ_COMMITTED_SNAPSHOT_ON |
Read Committed Snapshot | NA | ||
IS_TRUSTWORTHY_ON |
Trustworthy | NA | ||
IS_BROKER_ENABLED |
Service Broker Enabled | NA |
AlwaysOn Databases Configuration (HadrDatabasesConfig) - configuration snapshot, collected every 24 Hr
Configuration snapshot of AlwaysOn Databases Configuration, captured for configuration history and compliance evaluation rather than for alerting.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
GROUP_ID (key) |
Availability Group ID | NA | ||
REPLICA_ID (key) |
Replica ID | NA | ||
DATABASE_ID (key) |
Database ID | NA | ||
DATABASE_NAME |
Database Name | NA | ||
IS_LOCAL |
Is Local | NA | ||
IS_PRIMARY_REPLICA |
Is Primary Replica | NA | ||
SYNCHRONIZATION_STATE_DESC |
Synchronization State | NA | ||
SYNCHRONIZATION_HEALTH_DESC |
Synchronization Health | NA | ||
IS_SUSPENDED |
Is Suspended | NA |
SQL Server Locks (SQLServerLock) - collected every 15 Min
Lock counts aggregated by resource type, request mode and status, from sys.dm_tran_locks - the shape of current locking rather than individual locks.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
resource_type (key) |
Resource Type | NA | ||
request_mode (key) |
Request Mode | NA | ||
request_status (key) |
Request Status | NA | ||
lock_count |
Lock Count | NA |
Top Blocked Queries (TopQueriesBlocked) - collected every 15 Min
Requests currently blocked, with the blocking session, the wait type, how long the wait has run, the resource waited on, and the statement text.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
session_id (key) |
Session ID | NA | ||
request_id (key) |
Request ID | NA | ||
blocking_session_id |
Blocking Session ID | NA | ||
wait_type |
Wait Type | NA | ||
wait_time |
Wait Time (ms) | MILLISECONDS | ||
wait_resource |
Wait Resource | NA | ||
database_name |
Database | NA | ||
status |
Status | NA | ||
command |
Command | NA | ||
sql_text |
SQL Text | NA |
Blocked Session History (BlockedSessionHistory) - collected every 15 Min
Blocked requests with both sides identified - the blocked session’s login, host and program, and the same three for the blocking session, which is what makes a blocking chain attributable to an application.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
session_id (key) |
Session ID | NA | ||
request_id (key) |
Request ID | NA | ||
blocking_session_id |
Blocking Session ID | NA | ||
wait_type |
Wait Type | NA | ||
wait_time |
Wait Time (ms) | MILLISECONDS | ||
wait_resource |
Wait Resource | NA | ||
database_name |
Database | NA | ||
login_name |
Login | NA | ||
host_name |
Host | NA | ||
program_name |
Program | NA | ||
blocking_login_name |
Blocking Login | NA | ||
blocking_host_name |
Blocking Host | NA |
Locks (Locks) - collected every 15 Min
Individual lock requests from sys.dm_tran_locks - the session holding or waiting, the resource and its subtype, the requested mode, and the request status.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
session_id (key) |
Session ID | NA | ||
resource_type (key) |
Resource Type | NA | ||
resource_associated_entity_id (key) |
Resource Entity ID | NA | ||
database_name |
Database | NA | ||
resource_subtype |
Resource Subtype | NA | ||
request_mode (key) |
Request Mode | NA | ||
request_type |
Request Type | NA | ||
request_status (key) |
Request Status | NA | ||
resource_description |
Resource Description | NA |
Top Queries by CPU (TopQueriesCpu) - collected every 15 Min
Top cached statements by total CPU (worker) time, from sys.dm_exec_query_stats with the statement text - executions, total and average worker time, elapsed time, and logical and physical I/O.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
sql_handle (key) |
SQL Handle | NA | ||
plan_handle (key) |
Plan Handle | NA | ||
statement_start_offset (key) |
Statement Offset | NA | ||
statement_end_offset (key) |
Statement End Offset | NA | ||
execution_count |
Executions | NA | ||
total_worker_time |
Total CPU (us) | MICROSEC | ||
avg_worker_time |
Avg CPU (us) | MICROSEC | ||
total_elapsed_time |
Total Elapsed (us) | MICROSEC | ||
total_logical_reads |
Logical Reads | NA | ||
total_physical_reads |
Physical Reads | NA | ||
total_logical_writes |
Logical Writes | NA | ||
last_execution_time |
Last Execution | NA | ||
sql_text |
SQL Text | NA |
Top Queries by Executions (TopQueriesExec) - collected every 15 Min
The same statement statistics as Top Queries by CPU, ranked by execution count instead - the queries that run most often rather than the ones that cost most per run.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
sql_handle (key) |
SQL Handle | NA | ||
plan_handle (key) |
Plan Handle | NA | ||
statement_start_offset (key) |
Statement Offset | NA | ||
statement_end_offset (key) |
Statement End Offset | NA | ||
execution_count |
Executions | NA | ||
total_worker_time |
Total CPU (us) | MICROSEC | ||
avg_worker_time |
Avg CPU (us) | MICROSEC | ||
total_elapsed_time |
Total Elapsed (us) | MICROSEC | ||
total_logical_reads |
Logical Reads | NA | ||
total_physical_reads |
Physical Reads | NA | ||
total_logical_writes |
Logical Writes | NA | ||
last_execution_time |
Last Execution | NA | ||
sql_text |
SQL Text | NA |
Query Plan Statistics (QueryPlanStatistics) - collected every 15 Min
Cached execution plans aggregated per plan handle - how many statements the plan covers, executions, and the CPU, elapsed and I/O totals attributable to it.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
plan_handle (key) |
Plan Handle | NA | ||
statement_count |
Statement Count | NA | ||
execution_count |
Executions | NA | ||
total_worker_time |
Total CPU (us) | MICROSEC | ||
total_elapsed_time |
Total Elapsed (us) | MICROSEC | ||
total_logical_reads |
Logical Reads | NA | ||
total_physical_reads |
Physical Reads | NA | ||
total_logical_writes |
Logical Writes | NA | ||
last_execution_time |
Last Execution | NA |
Top Sessions (TopSessions) - collected every 15 Min
The busiest sessions from sys.dm_exec_sessions - login, host, program, status, CPU and memory use, scheduled and elapsed time, and logical and physical I/O.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
session_id (key) |
Session ID | NA | ||
login_name |
Login | NA | ||
host_name |
Host | NA | ||
program_name |
Program | NA | ||
status |
Status | NA | ||
cpu_time |
CPU Time (ms) | MILLISECONDS | ||
memory_usage |
Memory (pages) | NA | ||
total_scheduled_time |
Scheduled Time (ms) | MILLISECONDS | ||
total_elapsed_time |
Total Elapsed (ms) | MILLISECONDS | ||
logical_reads |
Logical Reads | NA | ||
reads |
Reads | NA | ||
writes |
Writes | NA | ||
database_name |
Database | NA | ||
last_request_start_time |
Last Request Start | NA |
Index Fragmentation (IndexFragmentation) - collected every 360 Min
Average fragmentation percentage and page count per index partition and allocation unit, from sys.dm_db_index_physical_stats in LIMITED mode. Collected on a long schedule because the scan is not free.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
database_name (key) |
Database | NA | ||
schema_name (key) |
Schema | NA | ||
table_name (key) |
Table | NA | ||
index_name (key) |
Index | NA | ||
partition_number (key) |
Partition | NA | ||
alloc_unit_type_desc (key) |
Alloc Unit Type | NA | ||
index_id |
Index ID | NA | ||
index_type_desc |
Index Type | NA | ||
avg_fragmentation_in_percent |
Fragmentation % | PERCENTAGE | ||
page_count |
Page Count | NA |
Index Usage (IndexUsage) - collected every 60 Min
How each index is actually used, from sys.dm_db_index_usage_stats - seeks, scans, lookups and updates, with the timestamps of the last of each. An index with updates and no reads is a maintenance cost with no return.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
database_name (key) |
Database | NA | ||
schema_name (key) |
Schema | NA | ||
table_name (key) |
Table | NA | ||
index_name (key) |
Index | NA | ||
index_id |
Index ID | NA | ||
user_seeks |
User Seeks | NA | ||
user_scans |
User Scans | NA | ||
user_lookups |
User Lookups | NA | ||
user_updates |
User Updates | NA | ||
last_user_seek |
Last Seek | NA | ||
last_user_scan |
Last Scan | NA | ||
last_user_update |
Last Update | NA |
Missing Indexes (MissingIndex) - collected every 60 Min
Indexes the optimizer wanted and did not find, from the missing-index DMVs - the table, the equality, inequality and included columns, the seeks and scans that would have used it, the average user impact, and a derived improvement measure for ranking. The Create Index dialog on the Indexes page acts on these rows.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
group_handle (key) |
Group Handle | NA | ||
database_name |
Database | NA | ||
table_statement |
Table | NA | ||
equality_columns |
Equality Columns | NA | ||
inequality_columns |
Inequality Columns | NA | ||
included_columns |
Included Columns | NA | ||
unique_compiles |
Unique Compiles | NA | ||
user_seeks |
User Seeks | NA | ||
user_scans |
User Scans | NA | ||
avg_total_user_cost |
Avg Cost | NA | ||
avg_user_impact |
Avg Impact % | PERCENTAGE | ||
improvement_measure |
Improvement Measure | NA |
Wait Type History (WaitTypeHistory) - collected every 15 Min
Wait statistics per wait type from sys.dm_os_wait_stats - waiting task count, total and maximum wait time, and the signal/resource split that separates waiting for a CPU from waiting for a resource.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
wait_type (key) |
Wait Type | NA | ||
waiting_tasks_count |
Waiting Tasks | NA | ||
wait_time_ms |
Wait Time (ms) | MILLISECONDS | ||
max_wait_time_ms |
Max Wait (ms) | MILLISECONDS | ||
signal_wait_time_ms |
Signal Wait (ms) | MILLISECONDS | ||
resource_wait_time_ms |
Resource Wait (ms) | MILLISECONDS |
File I/O Statistics (FileIoStats) - collected every 15 Min
Per-file I/O from sys.dm_io_virtual_file_stats - read and write counts and bytes, the read and write stall times that indicate storage latency, and the file’s size on disk.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
database_id (key) |
Database ID | NA | ||
database_name |
Database | NA | ||
file_id (key) |
File ID | NA | ||
logical_name |
Logical Name | NA | ||
physical_name |
Physical Name | NA | ||
file_type |
File Type | NA | ||
num_of_reads |
Reads | NA | ||
num_of_writes |
Writes | NA | ||
num_of_bytes_read |
Bytes Read | BYTE | ||
num_of_bytes_written |
Bytes Written | BYTE | ||
io_stall_read_ms |
Read Stall (ms) | MILLISECONDS | ||
io_stall_write_ms |
Write Stall (ms) | MILLISECONDS | ||
io_stall |
Total Stall (ms) | MILLISECONDS | ||
size_on_disk_mb |
Size on Disk (MB) | MB |
Database IOPS (DatabaseIops) - collected every 15 Min
The same virtual file statistics rolled up per database, giving read, write and total I/O counts, bytes, and stall times without the per-file detail.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
database_id (key) |
Database ID | NA | ||
database_name |
Database | NA | ||
num_of_reads |
Reads | NA | ||
num_of_writes |
Writes | NA | ||
num_of_ios |
Total IOs | NA | ||
num_of_bytes_read |
Bytes Read | BYTE | ||
num_of_bytes_written |
Bytes Written | BYTE | ||
io_stall_read_ms |
Read Stall (ms) | MILLISECONDS | ||
io_stall_write_ms |
Write Stall (ms) | MILLISECONDS | ||
io_stall |
Total Stall (ms) | MILLISECONDS |
SQL Server Backups (Backups) - collected every 60 Min
Backup history from msdb - one row per backup set with type, start and finish times, raw and compressed size, recovery model, copy-only flag, and who ran it. This is the trending source; Last Database Backup is the current-state one.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
backup_set_id (key) |
Backup Set ID | NA | ||
media_set_id |
Media Set ID | NA | ||
database_name |
Database | NA | ||
backup_type |
Backup Type | NA | ||
backup_start_date |
Start Date | NA | ||
backup_finish_date |
Finish Date | NA | ||
backup_size_bytes |
Backup Size (bytes) | BYTE | ||
compressed_backup_size_bytes |
Compressed Size (bytes) | BYTE | ||
user_name |
User Name | NA | ||
recovery_model |
Recovery Model | NA | ||
is_copy_only |
Copy Only | BOOLEAN | ||
server_name |
Server Name | NA | ||
machine_name |
Machine Name | NA | ||
backup_set_name |
Backup Set Name | NA |
Last Database Backup (LastDatabaseBackup) - collected every 60 Min
The most recent backup per database with its age in both days and hours, the last full and last log backup dates, and the recovery model. hours_since_last_backup carries the RPO threshold. A database that has never been backed up reports a sentinel age rather than a null.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
database_name (key) |
Database | NA | ||
days_since_last_backup |
Days Since Last Backup | DAYS | ||
last_backup_date |
Last Backup Date | NA | ||
last_backup_type |
Last Backup Type | NA | ||
last_full_backup_date |
Last Full Backup Date | NA | ||
last_log_backup_date |
Last Log Backup Date | NA | ||
recovery_model_desc |
Recovery Model | NA | ||
hours_since_last_backup |
Hours Since Last Backup | HOURS | > 48 | > 168 |
Transaction Log Space (TransactionLog) - collected every 30 Min
Per-database transaction log size and the percentage of log space used, which carries a threshold - a log filling up is the common cause of a database becoming unwritable.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
database_name (key) |
Database | NA | ||
log_size_mb |
Log Size (MB) | MB | ||
log_space_used_pct |
Log Space Used (%) | PERCENTAGE | > 75 | > 90 |
log_space_available_pct |
Log Space Available (%) | PERCENTAGE |
Database I/O By Type (DatabaseIoByType) - collected every 15 Min
Per-database I/O split by file type, so data-file and log-file activity can be told apart - the log is the write-latency-sensitive half.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
database_id (key) |
Database ID | NA | ||
database_name |
Database | NA | ||
file_type (key) |
File Type | NA | ||
num_of_reads |
Reads | NA | ||
num_of_writes |
Writes | NA | ||
num_of_ios |
Total I/Os | NA | ||
num_of_bytes_read |
Bytes Read | BYTE | ||
num_of_bytes_written |
Bytes Written | BYTE | ||
io_stall_read_ms |
Read Stall (ms) | MILLISECONDS | ||
io_stall_write_ms |
Write Stall (ms) | MILLISECONDS | ||
io_stall |
Total Stall (ms) | MILLISECONDS | ||
size_on_disk_mb |
Size on Disk (MB) | MB |
SQL Server Processes (Processes) - collected every 15 Min
Current sessions and requests - blocking session, CPU time, program and command, login time, execution state, and the current wait type and wait time.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
session_id (key) |
Session ID | NA | ||
blocking_session_id |
Blocking Session ID | NA | ||
cpu_time_ms |
CPU Time (ms) | MILLISECONDS | ||
program_name |
Program Name | NA | ||
command |
Command | NA | ||
login_time |
Login Time | NA | ||
database_name |
Database | NA | ||
execution_state |
Execution State | NA | ||
host_name |
Host Name | NA | ||
login_name |
Login Name | NA | ||
memory_usage_pages |
Memory Usage (pages) | NA | ||
process_state |
Process State | NA | ||
wait_type |
Wait Type | NA | ||
wait_time_ms |
Wait Time (ms) | MILLISECONDS |
Logins (Login) - collected every 60 Min
Server-level principals from sys.server_principals - type, whether disabled, creation and modification dates, and the default database and language.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
name (key) |
Name | NA | ||
type_code |
Type Code | NA | ||
type_desc |
Type | NA | ||
is_disabled |
Disabled | BOOLEAN | ||
create_date |
Created | NA | ||
modify_date |
Modified | NA | ||
default_database_name |
Default Database | NA | ||
default_language_name |
Default Language | NA |
Database Users (User) - collected every 60 Min
Database-level principals per database - type, whether it is a system user, creation date, default schema, and authentication type.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
database_name (key) |
Database | NA | ||
name (key) |
Name | NA | ||
type_desc |
Type | NA | ||
is_system |
System Object | BOOLEAN | ||
create_date |
Created | NA | ||
default_schema_name |
Default Schema | NA | ||
authentication_type_desc |
Authentication Type | NA |
SQL Server Agent Status (AgentStatus) - collected every 5 Min
SQL Server Agent service state - the running status, start mode, last startup time, and the service account. Collected on a short schedule because an Agent that is not running silently stops every scheduled job.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
server_name |
Server Name | NA | ||
service_name (key) |
Service Name | NA | ||
process_id |
Process ID | NA | ||
service_path |
Service Path | NA | ||
agent_status |
Agent Status | NA | ||
agent_start_mode |
Start Mode | NA | ||
last_startup_time |
Last Startup Time | NA | ||
service_account |
Service Account | NA |
License (License) - collected every 60 Min
Licence state of this plug-in installation, not of the SQL Server instance - the collection contacts neither the database nor the OMS. license_status carries the reason (Active, Expired, Wrong Product, Invalid Signature, License Required, Exceeded Limit, Instance Count Unavailable); the threshold is set on days_remaining, which is only a real countdown for Active and Expired.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
customer (key) |
Customer | NA | ||
license_type |
License Type | NA | ||
expiration |
Expiration | NA | ||
instances |
Licensed Instances | NA | ||
days_remaining |
Days Remaining | days | < 30 | < 7 |
license_status |
License Status | NA |
SQL Server Agent Jobs (DatabaseJob) - collected every 60 Min
SQL Server Agent job definitions and outcomes from msdb - whether the job is enabled, its owner and category, the step count, and the last run’s date, time and outcome.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
job_id (key) |
Job ID | NA | ||
name |
Name | NA | ||
enabled |
Enabled | BOOLEAN | ||
description |
Description | NA | ||
owner |
Owner | NA | ||
category |
Category | NA | ||
date_created |
Created | NA | ||
date_modified |
Modified | NA | ||
version_number |
Version | NA | ||
last_run_date |
Last Run Date | NA | ||
last_run_time |
Last Run Time | NA | ||
last_run_outcome |
Last Run Outcome | NA | ||
number_of_steps |
Number of Steps | NA |
Error Log Entries (ErrorLog) - collected every 15 Min
Recent SQL Server error log entries with their timestamp and process context. Keyed by timestamp and sequence so repeated messages in the same second stay distinct.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
log_date (key) |
Log Date | NA | ||
process_info |
Process Info | NA | ||
error_text |
Message | NA | ||
seq (key) |
Sequence | NA |
SQL Instance Statistics (SqlInstanceStats) - collected every 60 Min
Instance-wide size rollup - database counts and the combined data, log and total file sizes across every database.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
combined_file_size_mb |
Combined File Size (MB) | MB | ||
number_of_databases |
Number of Databases | NA | ||
number_of_user_databases |
Number of User Databases | NA | ||
combined_data_size_mb |
Combined Data Size (MB) | MB | ||
combined_log_size_mb |
Combined Log Size (MB) | MB |
Deadlock Rate (DeadlockRate) - collected every 15 Min
Deadlock counts from the system_health extended-events session - the trailing hour and day, the total in the current file, and how long since the last one. The hourly count carries a threshold.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
deadlocks_last_hour |
Deadlocks (Last Hour) | NA | > 5 | > 20 |
deadlocks_last_day |
Deadlocks (Last 24h) | NA | ||
deadlocks_in_file |
Deadlocks (In Event File) | NA | ||
minutes_since_last_deadlock |
Minutes Since Last Deadlock | MINUTES |
Recent Deadlocks (RecentDeadlocks) - collected every 15 Min
The recent deadlock list parsed out of the system_health event file - event time, how many processes and resources took part, and the victim’s identifiers. One row per deadlock graph.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
event_time_utc (key) |
Deadlock Time (UTC) | NA | ||
process_count |
Processes | NA | ||
resource_count |
Resources | NA | ||
victim_process_id |
Victim Process | NA | ||
victim_spid |
Victim SPID | NA | ||
victim_database_id |
Victim Database ID | NA |
Blocked Sessions (BlockedSessions) - collected every 5 Min
The current count of blocked requests as a single number, collected on a short schedule so it can be alerted on and charted. Carries a threshold.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
blocked_sessions |
Blocked Sessions | NA | > 5 | > 20 |
Connection Saturation (ConnectionSaturation) - collected every 5 Min
User connections as a percentage of the instance’s effective connection cap, so the alert fires on the ratio rather than on a raw count that means different things on different instances.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
user_connections |
User Connections | NA | ||
max_connections |
Max Connections | NA | ||
connection_saturation_pct |
Connection Saturation (%) | PERCENTAGE | > 80 | > 90 |
TempDB Contention (TempdbContention) - collected every 5 Min
TempDB PAGELATCH contention with the page type classified by the engine rather than guessed from the page number - total and exclusive-mode waiters, the allocation-page (PFS/GAM/SGAM) and metadata-page splits, the longest current wait, and a plain-language advice string. The allocation and metadata splits require DMVs added in SQL Server 2019 and report zero on 2016 and 2017; read those zeros as not-classifiable-here rather than as nothing-to-report.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
pagelatch_waiters |
PAGELATCH Waiters | NA | ||
pagelatch_ex_waiters |
PAGELATCH_EX Waiters | NA | > 5 | > 20 |
allocation_page_waiters |
Allocation-Page Waiters (PFS/GAM/SGAM) | NA | ||
metadata_page_waiters |
Metadata-Page Waiters | NA | ||
max_wait_ms |
Max Wait (ms) | MILLISECONDS | ||
advice |
Advice | NA |
Worst Query CPU (WorstQueryCpu) - collected every 15 Min
Instance-wide worst-query costs as one numeric row per collection, which is what the Queries page history chart is drawn from. The three CPU columns are each the maximum of their own measure, so they may describe different statements; use the tables on that page to identify which.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
worst_query_cpu_ms |
Worst Query CPU, Cumulative While Cached (ms) | MILLISECONDS | ||
worst_query_avg_cpu_ms |
Worst Query CPU per Execution (ms) | MILLISECONDS | ||
worst_query_max_cpu_ms |
Worst Query CPU, Slowest Execution (ms) | MILLISECONDS | ||
cached_statements |
Cached Statements | NA | ||
cached_executions |
Cached Executions | NA |