MSSQL NRDOT metrics reference

sqlserver.batch.request.rate

Number of batch requests received by SQL Server

{requests}/s

gauge (double)

—

sqlserver.batch.sql_compilation.rate

Number of SQL compilations needed

{compilations}/s

gauge (double)

—

sqlserver.batch.sql_recompilation.rate

Number of SQL recompilations needed

{compilations}/s

gauge (double)

—

sqlserver.lock.wait.rate

Number of lock requests resulting in a wait

{requests}/s

gauge (double)

—

sqlserver.page.buffer_cache.hit_ratio

Pages found in the buffer pool without having to read from disk

%

gauge (double)

—

sqlserver.page.life_expectancy

Time a page will stay in the buffer pool

s

gauge (int)

performance_counter.object_name

sqlserver.user.connection.count

Number of users connected to the SQL Server

{connections}

gauge (int)

—

sqlserver.attention.rate

Number of SQL attentions (client cancellation interrupts) received per second

{attentions}/s

gauge (double)

—

sqlserver.batch.compilation.utilization

Number of SQL compilations per batch request

1

gauge (double)

—

sqlserver.batch.page_split.utilization

Number of page splits per batch request

1

gauge (double)

—

sqlserver.recompilation.ratio

Ratio of SQL recompilations to compilations, expressed as a percentage

%

gauge (double)

—

sqlserver.parameterization.rate

Rate of auto-parameterization activity, broken down by result

{params}/s

gauge (double)

sqlserver.parameterization.result (auto_attempted, safe, unsafe, failed, forced)

sqlserver.plan.execution.rate

Rate of plan executions, classified by plan guide result

{executions}/s

gauge (double)

sqlserver.plan.guidance.result (guided, misguided)

sqlserver.database.backup_or_restore.rate

Total number of backups/restores

{backups_or_restores}/s

gauge (double)

—

sqlserver.database.count

The number of databases

{databases}

gauge (int)

database.status (online, restoring, recovering, pending_recovery, suspect, offline)

sqlserver.database.execution.errors

Number of execution errors

{errors}

gauge (int)

—

sqlserver.database.file.size

Size of database files

By

gauge (int)

file_type, db.namespace

sqlserver.database.full_scan.rate

The number of unrestricted full table or index scans

{scans}/s

gauge (double)

—

sqlserver.database.transactions.active

Number of active transactions in the database

{transactions}

gauge (int)

db.namespace

sqlserver.deadlock.rate

Total number of deadlocks

{deadlocks}/s

gauge (double)

—

sqlserver.database.io

The number of bytes of I/O on this file

By

sum (cumulative, int)

physical_filename, logical_filename, file_type, direction

sqlserver.database.latency

Total time that the users waited for I/O issued on this file

s

sum (cumulative, double)

physical_filename, logical_filename, file_type, direction

sqlserver.database.operations

The number of operations issued on the file

{operations}

sum (cumulative, int)

physical_filename, logical_filename, file_type, direction

sqlserver.database.page_file.size

Reserved space allocated to the database, broken down by usage state

By

gauge (int)

db.namespace, page_file.state (used, free, total)

sqlserver.database.principals.count

Number of database security principals broken down by type

{principals}

gauge (int)

db.namespace, principal.type (sql_user, windows_user, role, application_role, certificate_mapped_user, asymmetric_key_mapped_user)

sqlserver.database.principals.old

Number of database principals created more than one year ago

{principals}

gauge (int)

db.namespace

sqlserver.database.principals.orphaned_users

Number of SQL users in the database that have no matching server login

{principals}

gauge (int)

db.namespace

sqlserver.database.principals.recently_created

Number of database principals created in the last 30 days

{principals}

gauge (int)

db.namespace

sqlserver.database.role.members.count

Number of database role members broken down by member kind

{members}

gauge (int)

db.namespace, member.kind (app_role, cross_role, high_privilege, unique)

sqlserver.database.role.memberships.count

Number of database role memberships broken down by kind

{memberships}

gauge (int)

db.namespace, membership.kind (active, custom, nested, users)

sqlserver.database.role.permission.risk_level

Risk level assigned to each database role (1=low, 4=high)

1

gauge (int)

db.namespace, role

sqlserver.database.role.roles.count

Number of database roles broken down by usage state

{roles}

gauge (int)

db.namespace, role.state (empty, with_members)

sqlserver.database.security.role_membership.count

Number of members in a database role

{members}

gauge (int)

db.namespace, role

sqlserver.server.security.principal.count

Number of security principals (logins, users) at the server level

{principals}

gauge (int)

—

sqlserver.server.security.role_membership.count

Number of members in a server role

{members}

gauge (int)

role

sqlserver.failover_cluster.ag.cluster_type

Cluster type of the Always-On Availability Group

1

gauge (int)

ag.name, ag.cluster_type (wsfc, external, none, unknown)

sqlserver.failover_cluster.ag.failure_condition_level

Failure condition level configured for the Availability Group (1-5)

1

gauge (int)

ag.name

sqlserver.failover_cluster.ag.health_check_timeout

Health-check timeout configured for the Availability Group

ms

gauge (int)

ag.name

sqlserver.failover_cluster.ag.required_sync_secondaries

Number of synchronized secondary replicas required to commit on the Availability Group

{secondaries}

gauge (int)

ag.name

sqlserver.failover_cluster.replica.database.queue_size

Size of the log-send or redo queue for an AG database replica

By

gauge (int)

ag.name, replica.server_name, db.namespace, replica.queue_kind (log_send, redo)

sqlserver.failover_cluster.replica.database.redo.rate

Redo rate for an AG database replica

By/s

gauge (double)

ag.name, replica.server_name, db.namespace

sqlserver.failover_cluster.replica.flow_control_time

Cumulative time spent in AG flow control, in milliseconds per second observed

ms

gauge (double)

—

sqlserver.failover_cluster.replica.role

Role of the availability replica

1

gauge (int)

ag.name, replica.server_name, replica.role (primary, secondary, resolving, unknown)

sqlserver.failover_cluster.replica.synchronization_health

Synchronization health of the availability replica

1

gauge (int)

ag.name, replica.server_name, replica.sync_health (healthy, partially_healthy, not_healthy, unknown)

sqlserver.index.search.rate

Total number of index searches

{searches}/s

gauge (double)

—

sqlserver.latch.superlatch.count

Number of superlatches currently active

{superlatch}

gauge (int)

—

sqlserver.latch.superlatch.transition.rate

Rate of superlatch promotions or demotions

{transition}/s

gauge (double)

transition.direction (promotion, demotion)

sqlserver.latch.wait.rate

Number of latch waits per second

{wait}/s

gauge (double)

—

sqlserver.latch.wait_time.avg

Average time spent waiting for latches (lighter-weight synchronization)

s

gauge (double)

—

sqlserver.latch.wait_time.total

Total latch wait time

s

sum (cumulative, double)

—

sqlserver.lock.by_mode.count

Number of currently active locks held in the database, grouped by lock mode

{locks}

gauge (int)

db.namespace, lock.mode (shared, exclusive, update, intent, schema, bulk_update, shared_intent_exclusive)

sqlserver.lock.by_resource.count

Number of currently active locks held in the database, grouped by resource type

{locks}

gauge (int)

db.namespace, lock.resource (key, page, row, table, extent, file, hobt, metadata, application, allocation_unit, database_level)

sqlserver.lock.timeout.rate

Total number of lock timeouts

{timeouts}/s

gauge (double)

—

sqlserver.lock.wait.count

Cumulative count of lock waits that occurred

{wait}

sum (cumulative, int)

workload_group.name (default, internal)

sqlserver.login.rate

Total number of logins

{logins}/s

gauge (double)

—

sqlserver.logout.rate

Total number of logouts

{logouts}/s

gauge (double)

—

sqlserver.kill_connection.error.rate

Number of kill-connection errors per second

{errors}/s

gauge (double)

—

sqlserver.memory.area

Amount of memory used by the SQL Server memory pool

By

gauge (int)

memory.pool (target, total, sql_cache, optimizer, connection, granted_workspace, max_workspace)

sqlserver.memory.cache.object.count

Number of cache objects in the SQL Server cache

{object}

gauge (int)

cache.state (in_use, total)

sqlserver.memory.grants.pending.count

Total number of memory grants pending

{grants}

sum (cumulative, int)

—

sqlserver.memory.page.count

Number of pages in the SQL Server buffer pool

{page}

gauge (int)

page.pool (cache, total, target, database, stolen, reserved, free)

sqlserver.memory.target

Maximum amount of memory SQL Server is willing to use (target server memory)

By

gauge (int)

—

sqlserver.memory.usage

Total memory in use

KB

sum (cumulative, double)

workload_group.name (default, internal)

sqlserver.computer.uptime

Computer uptime

{seconds}

gauge (int)

—

sqlserver.cpu.count

Number of CPUs

{CPUs}

gauge (int)

—

sqlserver.os.disk.size

Total disk space across volumes hosting SQL Server database files

By

gauge (int)

—

sqlserver.os.memory.usage

Amount of system physical memory observed by SQL Server

By

gauge (int)

memory.state (available, total)

sqlserver.os.memory.utilization

Fraction of system physical memory in use by the SQL Server process

1

gauge (double)

—

sqlserver.os.scheduler.runnable_tasks.count

Total number of runnable tasks across online schedulers

{tasks}

gauge (int)

—

sqlserver.os.wait.duration

Total wait time for this wait type

s

sum (cumulative, double)

wait.category, wait.type

sqlserver.os.wait.tasks.count

Cumulative number of tasks that have waited on this wait type since SQL Server startup

{tasks}

sum (cumulative, int)

wait.category, wait.type

sqlserver.page.buffer_cache.free_list.stalls.rate

Number of free list stalls

{stalls}/s

gauge (int)

—

sqlserver.page.lookup.rate

Total number of page lookups

{lookups}/s

gauge (double)

—

sqlserver.process.count

Number of SQL Server processes (user sessions), broken down by status

{processes}

gauge (int)

process.status (background, dormant, preconnect, runnable, running, sleeping, suspended)

sqlserver.processes.blocked

The number of processes that are currently blocked

{processes}

gauge (int)

—

sqlserver.replica.data.rate

Throughput rate of replica data

By/s

gauge (double)

replica.direction (transmit, receive)

sqlserver.resource_pool.disk.operations

The rate of operations issued

{operations}/s

gauge (double)

direction (read, write)

sqlserver.resource_pool.disk.throttled.read.rate

The number of read operations that were throttled in the last second

{reads}/s

gauge (int)

—

sqlserver.resource_pool.disk.throttled.write.rate

The number of write operations that were throttled in the last second

{writes}/s

gauge (double)

—

sqlserver.table.count

The number of tables

{tables}

sum (cumulative, int)

table.state (active, inactive), table.status (temporary, permanent)

sqlserver.database.tempdb.space

Total free space in temporary DB

KB

sum (cumulative, int)

tempdb.state (free, used)

sqlserver.database.tempdb.version_store.size

TempDB version store size

KB

gauge (double)

—

sqlserver.tempdb.allocation.wait_time.total

Cumulative wait time on tempdb allocation pages, broken down by page type

s

sum (cumulative, double)

allocation.page_type (gam, sgam, pfs, other)

sqlserver.tempdb.contention.waiters.count

Number of tempdb pagelatch wait types with at least one active waiter

{waiters}

gauge (int)

—

sqlserver.tempdb.data_files.count

Number of tempdb data files configured on the instance

{files}

gauge (int)

—

sqlserver.tempdb.file.size

Size of each tempdb data or log file

By

gauge (int)

file_type, tempdb.file.id

sqlserver.tempdb.space.usage

Space used by tempdb, broken down by allocation category

By

gauge (int)

tempdb.space_kind (user_objects, internal_objects, version_store, free)

sqlserver.thread_pool.tasks.count

Number of SQL Server tasks broken down by state

{tasks}

gauge (int)

task.state (current, queued, waiting_for_threadpool)

sqlserver.thread_pool.workers.count

Number of SQL Server worker threads broken down by state

{workers}

gauge (int)

worker.state (running, suspended_or_sleeping)

sqlserver.thread_pool.workers.max

Maximum number of SQL Server worker threads configured on the instance

{workers}

gauge (int)

—

sqlserver.thread_pool.workers.utilization

Fraction of configured SQL Server worker threads currently running

1

gauge (double)

—

sqlserver.transaction.delay

Time consumed in transaction delays

ms

sum (cumulative, double)

—

sqlserver.transaction.longest_running_time

Age in seconds of the longest currently-open transaction on the server

s

gauge (double)

—

sqlserver.transaction.mirror_write.rate

Total number of mirror write transactions

{transactions}/s

gauge (double)

—

sqlserver.transaction.version_cleanup.rate

Cumulative bytes cleaned from the tempdb version store

By

sum (cumulative, double)

—

sqlserver.transaction.version_generation.rate

Cumulative bytes of row versions written to the tempdb version store

By

sum (cumulative, double)

—

sqlserver.computer.uptime

System uptime counter

s

gauge (double)

—

sqlserver.cpu.count

Number of CPU cores available

{cpu}

gauge (double)

—

sqlserver.memory.usage

Memory usage by SQL Server process

By

gauge (double)

memory_type

sqlserver.performance_counter.buffer.hit_ratio

Percentage of pages found in the buffer cache

%

gauge (double)

—

sqlserver.performance_counter.cache.hit_ratio

Ratio of cache hits to cache lookups

%

gauge (double)

cache_type

sqlserver.performance_counter.compilations.rate

Number of SQL compilations per second

{compilations}/s

gauge (double)

—

sqlserver.performance_counter.connections

Number of user connections to SQL Server

{connections}

gauge (double)

—

sqlserver.performance_counter.locks.count

Number of current locks

{locks}

gauge (double)

lock_type

sqlserver.performance_counter.locks.timeout.rate

Number of lock timeouts per second

{timeouts}/s

gauge (double)

—

sqlserver.performance_counter.memory.grant_pending

Total number of processes waiting for memory grants

{processes}

gauge (double)

—

sqlserver.performance_counter.page.operations.rate

Number of physical database page operations per second

{operations}/s

gauge (double)

page_type

sqlserver.performance_counter.recompilations.rate

Number of SQL recompilations per second

{recompilations}/s

gauge (double)

—

sqlserver.performance_counter.transactions.rate

Number of transactions per second

{transactions}/s

gauge (double)

database