sqlserver.access.scan.rate | gauge | double | {scan}/s | development | no | sqlserver.access.scan.type (string) | Rate of access method scans. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.attention.rate | gauge | double | {attentions}/s | development | no | | Number of SQL attentions (client cancellation interrupts) received per second. |
sqlserver.availability_group.database_replica.queue.rate | gauge | int | By/s | development | no | sqlserver.availability_group.name (string), sqlserver.availability_group.queue.type (string), sqlserver.replica.name (string) | Rate at which log data is being sent or redone on a database replica, broken down by queue type (log_send for primary-to-secondary transmission, redo for applying log records on the secondary). This metric is only available when the receiver is configured to directly connect to SQL Server and the instance has Always On Availability Groups enabled. |
sqlserver.availability_group.database_replica.queue.size | gauge | int | By | development | no | sqlserver.availability_group.name (string), sqlserver.availability_group.queue.type (string), sqlserver.replica.name (string) | Amount of log data waiting to be processed on a database replica, broken down by queue type (log_send for data not yet sent to the secondary, redo for data received but not yet applied). This metric is only available when the receiver is configured to directly connect to SQL Server and the instance has Always On Availability Groups enabled. |
sqlserver.availability_group.database_replica.secondary_lag | gauge | double | s | development | no | sqlserver.availability_group.name (string), sqlserver.replica.name (string) | Number of seconds the secondary replica is lagging behind the primary replica, measured as the time between the most recent hardened log block on the primary and on the secondary. This metric is only available when the receiver is configured to directly connect to SQL Server and the instance has Always On Availability Groups enabled. |
sqlserver.batch.request.rate | gauge | double | {requests}/s | development | yes | | Number of batch requests received by SQL Server. |
sqlserver.batch.sql_compilation.rate | gauge | double | {compilations}/s | development | yes | | Number of SQL compilations needed. |
sqlserver.batch.sql_recompilation.rate | gauge | double | {compilations}/s | development | yes | | Number of SQL recompilations needed. |
sqlserver.clr.execution.time | sum (monotonic) | double | s | development | no | | Total time spent executing in the CLR. Only non-zero when CLR integration is enabled and CLR code has been executed. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.computer.uptime | gauge | int | {seconds} | development | no | | Computer uptime. |
sqlserver.connection.reset.rate | gauge | double | {connection}/s | development | no | | Number of logical connections reset per second. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.cpu.count | gauge | int | {CPUs} | development | no | | Number of CPUs. |
sqlserver.cpu.utilization | gauge | double | 1 | development | no | | System-wide CPU utilization on the host that SQL Server is running on, expressed as a fraction between 0 and 1. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.cursor.count | gauge | int | {cursor} | development | no | cursor.state (string) | Number of cursors by state. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.cursor.memory.usage | gauge | int | By | development | no | | Memory used by cursors. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.cursor.plan.count | gauge | int | {plan} | development | no | | Number of active cursor plans. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.cursor.request.rate | gauge | double | {request}/s | development | no | | Rate of cursor requests per second. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.database.backup_or_restore.rate | gauge | double | {backups_or_restores}/s | development | no | | Total number of backups/restores. |
sqlserver.database.count | gauge | int | {databases} | development | no | database.status (string) | The number of databases This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.database.execution.errors | gauge | int | {errors} | development | no | | Number of execution errors. |
sqlserver.database.full_scan.rate | gauge | double | {scans}/s | development | no | | The number of unrestricted full table or index scans. |
sqlserver.database.io | sum (monotonic) | int | By | development | no | direction (string), file_type (string), logical_filename (string), physical_filename (string) | The number of bytes of I/O on this file. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.database.latency | sum (monotonic) | double | s | development | no | direction (string), file_type (string), logical_filename (string), physical_filename (string) | Total time that the users waited for I/O issued on this file. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.database.operations | sum (monotonic) | int | {operations} | development | no | direction (string), file_type (string), logical_filename (string), physical_filename (string) | The number of operations issued on the file. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.database.tempdb.space | sum | int | kBy | development | no | tempdb.state (string) | Total free space in temporary DB. |
sqlserver.database.tempdb.version_store.size | gauge | double | kBy | development | no | | TempDB version store size. |
sqlserver.deadlock.rate | gauge | double | {deadlocks}/s | development | no | | Total number of deadlocks. |
sqlserver.disk.io | sum (monotonic) | int | By | development | no | disk.io.direction (string), sqlserver.file.path.prefix (string) | Cumulative bytes transferred to or from files backing SQL Server databases, per I/O direction. Counters reset when the file becomes unavailable (detached, taken offline, or database restart). This metric is only available when the receiver is configured to directly connect to SQL Server. Only covers I/O for SQL Server database files, not total host disk I/O. |
sqlserver.disk.operations | sum (monotonic) | int | {operation} | development | no | disk.io.direction (string), sqlserver.file.path.prefix (string) | Cumulative I/O operation count on files backing SQL Server databases, per I/O direction. Counters reset when the file becomes unavailable (detached, taken offline, or database restart). This metric is only available when the receiver is configured to directly connect to SQL Server. Only covers I/O for SQL Server database files, not total host disk I/O. |
sqlserver.error.rate | gauge | double | {error}/s | development | no | sqlserver.error.category (string) | Number of errors raised per second. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.extent.operation.rate | gauge | double | {extent}/s | development | no | sqlserver.extent.operation.type (string) | Rate of extent operations. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.ghost_record.skipped.rate | gauge | double | {record}/s | development | no | | Rate of ghosted records skipped during scans. |
sqlserver.host.memory.limit | gauge | int | By | development | no | | Total physical memory available to SQL Server on the host. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.host.memory.usage | gauge | int | By | development | no | system.memory.state (string) | Physical memory usage available to SQL Server on the host, broken down by state. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.index.fragmentation | gauge | double | % | development | no | db.namespace (string), sqlserver.index.id (int), sqlserver.object.name (string), sqlserver.schema.name (string) | Average fragmentation percentage of the index. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.index.page.count | gauge | int | {page} | development | no | db.namespace (string), sqlserver.index.id (int), sqlserver.object.name (string), sqlserver.schema.name (string) | Number of pages in the index. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.index.page.utilization | gauge | double | % | development | no | db.namespace (string), sqlserver.index.id (int), sqlserver.object.name (string), sqlserver.schema.name (string) | Average percentage of available data storage space used in all pages of the index. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.index.record.count | gauge | int | {record} | development | no | db.namespace (string), sqlserver.index.id (int), sqlserver.object.name (string), sqlserver.schema.name (string) | Total number of records in the index. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.index.search.rate | gauge | double | {searches}/s | development | no | | Total number of index searches. |
sqlserver.index.size | gauge | int | By | development | no | db.namespace (string), sqlserver.index.id (int), sqlserver.object.name (string), sqlserver.schema.name (string) | Total size of the index. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.latch.superlatch.count | gauge | int | {superlatch} | development | no | | Number of superlatches currently active. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.latch.superlatch.transition.rate | gauge | double | {transition}/s | development | no | transition.direction (string) | Rate of superlatch promotions or demotions. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.latch.wait.rate | gauge | double | {wait}/s | development | no | | Number of latch waits per second. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.latch.wait_time.avg | gauge | double | s | development | no | | Average latch wait time. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.latch.wait_time.total | sum (monotonic) | double | s | development | no | | Total latch wait time. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.lock.block.count | gauge | int | {block} | development | no | sqlserver.lock.block.type (string) | Number of lock blocks tracked by the lock manager. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.lock.escalation.rate | gauge | double | {escalation}/s | development | no | | Number of lock escalations per second (locks on a table escalated to a larger granularity). This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.lock.memory | gauge | int | By | development | no | | Total amount of memory used for locks. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.lock.request.rate | gauge | double | {request}/s | development | no | | Number of new locks and lock conversions per second requested from the lock manager. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.lock.timeout.rate | gauge | double | {timeout}/s | development | no | sqlserver.lock.timeout.type (string) | Number of lock timeouts per second. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.lock.wait.count | sum (monotonic) | int | {wait} | development | no | | Cumulative count of lock waits that occurred. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.lock.wait.rate | gauge | double | {requests}/s | development | yes | | Number of lock requests resulting in a wait. |
sqlserver.lock.wait_time.avg | gauge | double | ms | development | yes | | Average wait time for all lock requests that had to wait. This metric is only available when running on Windows. |
sqlserver.lock.wait_time.total | sum (monotonic) | double | s | development | no | | Total wait time in seconds for locks since the last server restart. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.login.rate | gauge | double | {logins}/s | development | no | | Total number of logins. |
sqlserver.logout.rate | gauge | double | {logouts}/s | development | no | | Total number of logouts. |
sqlserver.memory.area | gauge | int | By | development | no | memory.pool (string) | Amount of memory used by the SQL Server memory pool. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.memory.cache.object.count | gauge | int | {object} | development | no | cache.state (string) | Number of cache objects in the SQL Server cache. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.memory.grants.pending.count | sum | int | {grants} | development | no | | Total number of memory grants pending. |
sqlserver.memory.page.count | gauge | int | {page} | development | no | page.pool (string) | Number of pages in the SQL Server buffer pool. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.memory.usage | sum | double | kBy | development | no | | Total memory in use. |
sqlserver.os.wait.duration | sum (monotonic) | double | s | development | no | wait.category (string), wait.type (string) | Total wait time for this wait type This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.page.allocation.rate | gauge | double | {page}/s | development | no | sqlserver.page.allocation.type (string) | Rate of page allocation operations. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.page.buffer_cache.free_list.stalls.rate | gauge | int | {stalls}/s | development | no | | Number of free list stalls. |
sqlserver.page.buffer_cache.hit_ratio | gauge | double | % | development | yes | | Pages found in the buffer pool without having to read from disk. |
sqlserver.page.checkpoint.flush.rate | gauge | double | {pages}/s | development | yes | | Number of pages flushed by operations requiring dirty pages to be flushed. This metric is only available when running on Windows. |
sqlserver.page.compression.rate | gauge | double | {page}/s | development | no | sqlserver.page.compression.type (string) | Rate of page compression operations. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.page.lazy_write.rate | gauge | double | {writes}/s | development | yes | | Number of lazy writes moving dirty pages to disk. This metric is only available when running on Windows. |
sqlserver.page.life_expectancy | gauge | int | s | development | yes | performance_counter.object_name (string) | Time a page will stay in the buffer pool. |
sqlserver.page.lookup.rate | gauge | double | {lookups}/s | development | no | | Total number of page lookups. |
sqlserver.page.operation.rate | gauge | double | {operations}/s | development | yes | page.operations (string) | Number of physical database page operations issued. This metric is only available when running on Windows. |
sqlserver.page.read_ahead.rate | gauge | double | {page}/s | development | no | | Rate of pages read from disk by the read-ahead manager. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.page.split.rate | gauge | double | {pages}/s | development | yes | | Number of pages split as a result of overflowing index pages. This metric is only available when running on Windows. |
sqlserver.parameterization.rate | gauge | double | {params}/s | development | no | sqlserver.parameterization.result (string) | Rate of auto-parameterization activity, broken down by result. |
sqlserver.plan.execution.rate | gauge | double | {executions}/s | development | no | sqlserver.plan.guidance.result (string) | Rate of plan executions, classified by plan guide result. |
sqlserver.processes.blocked | gauge | int | {processes} | development | no | | The number of processes that are currently blocked This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.recompilation.ratio | gauge | double | % | development | no | | Ratio of SQL recompilations to compilations, expressed as a percentage. |
sqlserver.replica.data.rate | gauge | double | By/s | development | no | replica.direction (string) | Throughput rate of replica data. |
sqlserver.resource_pool.disk.operations | gauge | double | {operations}/s | development | no | direction (string) | The rate of operations issued. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.resource_pool.disk.throttled.read.rate | gauge | int | {reads}/s | development | no | | The number of read operations that were throttled in the last second This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.resource_pool.disk.throttled.write.rate | gauge | double | {writes}/s | development | no | | The number of write operations that were throttled in the last second This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.scan_point.revalidation.rate | gauge | double | {revalidate}/s | development | no | | Rate at which scan points needed to be revalidated. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.stored_procedure.invocation.rate | gauge | double | {invocation}/s | development | no | | Rate of Service Broker activated stored procedure invocations per second. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.table.count | sum | int | {tables} | development | no | table.state (string), table.status (string) | The number of tables. |
sqlserver.task.count | gauge | int | {task} | development | no | task.state (string) | Number of Service Broker activation tasks by state. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.task.rate | gauge | double | {task}/s | development | no | task.result (string) | Rate of Service Broker activation tasks by type per second. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.transaction.delay | sum | double | ms | development | no | | Time consumed in transaction delays. |
sqlserver.transaction.mirror_write.rate | gauge | double | {transactions}/s | development | no | | Total number of mirror write transactions. |
sqlserver.transaction.rate | gauge | double | {transactions}/s | development | yes | | Number of transactions started for the database (not including XTP-only transactions). This metric is only available when running on Windows. |
sqlserver.transaction.write.rate | gauge | double | {transactions}/s | development | yes | | Number of transactions that wrote to the database and committed. This metric is only available when running on Windows. |
sqlserver.transaction_log.flush.data.rate | gauge | double | By/s | development | yes | | Total number of log bytes flushed. This metric is only available when running on Windows. |
sqlserver.transaction_log.flush.rate | gauge | double | {flushes}/s | development | yes | | Number of log flushes. This metric is only available when running on Windows. |
sqlserver.transaction_log.flush.wait.rate | gauge | double | {commits}/s | development | yes | | Number of commits waiting for a transaction log flush. This metric is only available when running on Windows. |
sqlserver.transaction_log.growth.count | sum (monotonic) | int | {growths} | development | yes | | Total number of transaction log expansions for a database. This metric is only available when running on Windows. |
sqlserver.transaction_log.shrink.count | sum (monotonic) | int | {shrinks} | development | yes | | Total number of transaction log shrinks for a database. This metric is only available when running on Windows. |
sqlserver.transaction_log.usage | gauge | int | % | development | yes | | Percent of transaction log space used. This metric is only available when running on Windows. |
sqlserver.user.connection.count | gauge | int | {connections} | development | yes | | Number of users connected to the SQL Server. |
sqlserver.worker.request.count | gauge | int | {request} | development | no | request.state (string) | Number of worker requests by state. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.worker.thread.count | gauge | int | {thread} | development | no | worker.state (string) | Number of worker threads by state. This metric is only available when the receiver is configured to directly connect to SQL Server. |
sqlserver.worktable.cache.hit_ratio | gauge | double | 1 | development | no | | Fraction of worktables that did not require initialization because they were retrieved from the worktable cache. This metric is only available when the receiver is configured to directly connect to SQL Server. |