Docs » Integrations Guide » Integrations Reference » Microsoft SQL Server

image0 Microsoft SQL Server

DESCRIPTION

The Microsoft SQL Server monitor is a SignalFx Smart Agent monitor used to report metrics about Microsoft SQL Server. The code from the monitor can be found here. Please refer to the SignalFx Smart Agent documentation for more information about this monitor.

INSTALLATION

Follow the installation instructions for the SignalFx Smart Agent.

CONFIGURATION

Follow the configuration instructions for the Microsoft SQL Server monitor in the SignalFx Smart Agent documentation.

Below is a list of all metrics.

Metric Name Brief Type
gauge.sqlserver_database_io.read_bytes Bytes read by the database. gauge
gauge.sqlserver_database_io.read_latency_ms Latency in milliseconds reading from the database. gauge
gauge.sqlserver_database_io.reads Number of reads from the database. gauge
gauge.sqlserver_database_io.write_bytes Bytes written to the database. gauge
gauge.sqlserver_database_io.write_latency_ms Latency in milliseconds writing to the database. gauge
gauge.sqlserver_database_io.writes Number of writes to the database. gauge
gauge.sqlserver_memory_clerks.size_kb.bound_trees Size in KB of bound trees memory clerk. gauge
gauge.sqlserver_memory_clerks.size_kb.buffer_pool Size in KB of buffer pool memory clerk. gauge
gauge.sqlserver_memory_clerks.size_kb.connection_pool Size in KB of connection pool memory clerk. gauge
gauge.sqlserver_memory_clerks.size_kb.general Size in KB of general memory clerk. gauge
gauge.sqlserver_memory_clerks.size_kb.in-memory_oltp Size in KB of in in-memoory oltp memory clerk. gauge
gauge.sqlserver_memory_clerks.size_kb.log_pool Size in KB of log pool memory clerk. gauge
gauge.sqlserver_memory_clerks.size_kb.memoryclerk_sqltrace Size in KB of sql trace memory clerk. gauge
gauge.sqlserver_memory_clerks.size_kb.schema_manager_user_store Size in KB of user store schema manager memory clerk. gauge
gauge.sqlserver_memory_clerks.size_kb.sos_node Size in KB of sos node memory clerk. gauge
gauge.sqlserver_memory_clerks.size_kb.sql_optimizer Size in KB of SQL optimizer memory clerk. gauge
gauge.sqlserver_memory_clerks.size_kb.sql_plans Size in KB of sql plans memory clerk. gauge
gauge.sqlserver_memory_clerks.size_kb.sql_reservations Size in KB of sql reservations memory clerk. gauge
gauge.sqlserver_memory_clerks.size_kb.sql_storage_engine Size in KB of sql storage engine memory clerk. gauge
gauge.sqlserver_memory_clerks.size_kb.system_rowset_store Size in KB of system rowset store memory clerk. gauge
gauge.sqlserver_performance.active_memory_grant_amount_kb Amount of active memory in KB granted. gauge
gauge.sqlserver_performance.active_temp_tables Number of active temporary tables. gauge
gauge.sqlserver_performance.background_writer_pages_persec Rate per second of pages written in the background. gauge
gauge.sqlserver_performance.backup.restore_throughput_persec Rate per second of backup/restore throughput. gauge
gauge.sqlserver_performance.batch_requests_persec Rate per second of batch requests. gauge
gauge.sqlserver_performance.blocked_tasks Number of blocked tasks. gauge
gauge.sqlserver_performance.buffer_cache_hit_ratio Buffer cache hit ration. gauge
gauge.sqlserver_performance.bytes_received_from_replica_persec Rate per second of bytes received from replicas. gauge
gauge.sqlserver_performance.bytes_sent_to_replica_persec Rate per second of bytes sent to replicas. gauge
gauge.sqlserver_performance.bytes_sent_to_transport_persec Rate per second of bytes sent to transports. gauge
gauge.sqlserver_performance.checkpoint_pages_persec Rate per second of checkpoint pages. gauge
gauge.sqlserver_performance.cpu_limit_violation_count Number of cpu limit violations. gauge
gauge.sqlserver_performance.cpu_usage_percent CPU usage percentage. gauge
gauge.sqlserver_performance.cpu_usage_time CPU usage time. gauge
gauge.sqlserver_performance.data_files_size_kb Size in KB of data files. gauge
gauge.sqlserver_performance.disk_read_bytes_persec Rate per second of bytes from disk. gauge
gauge.sqlserver_performance.disk_read_io_persec Rate per second of read operations from disk. gauge
gauge.sqlserver_performance.disk_read_io_throttled_persec Rate per second of throttled read operations. gauge
gauge.sqlserver_performance.disk_write_bytes_persec Rate per second of bytes written to disk. gauge
gauge.sqlserver_performance.disk_write_io_persec Rate per second of write operations to disk. gauge
gauge.sqlserver_performance.disk_write_io_throttled_persec Rate per second of write operations throttled. gauge
gauge.sqlserver_performance.errors_persec Rate of errors per second. gauge
gauge.sqlserver_performance.flow_control_persec Rate per second of flow control. gauge
gauge.sqlserver_performance.flow_control_time_ms_persec Rate per second of ms of flow control time. gauge
gauge.sqlserver_performance.forwarded_records_persec Rate per second of record forwarding. gauge
gauge.sqlserver_performance.free_list_stalls_persec Rate per second of stalled free list. gauge
gauge.sqlserver_performance.free_space_in_tempdb_kb Free space in KB of tempdb. gauge
gauge.sqlserver_performance.full_scans_persec Rate per second of full scans. gauge
gauge.sqlserver_performance.index_searches_persec Rate per second of index searches. gauge
gauge.sqlserver_performance.latch_waits_persec Rate per second of latch waits. gauge
gauge.sqlserver_performance.lazy_writes_persec Rate per second of lazy writes. gauge
gauge.sqlserver_performance.lock_timeouts_persec Rate per second of lock timeouts. gauge
gauge.sqlserver_performance.lock_wait_count Number of lock waits. gauge
gauge.sqlserver_performance.lock_wait_time Lock wait time. gauge
gauge.sqlserver_performance.lock_waits_persec Rate per second of lock waits. gauge
gauge.sqlserver_performance.log_apply_pending_queue Size of the log apply pending queue. gauge
gauge.sqlserver_performance.log_apply_ready_queue Size of log apply ready queue. gauge
gauge.sqlserver_performance.log_bytes_flushed_persec Rate per second of log bytes flushed. gauge
gauge.sqlserver_performance.log_bytes_received_persec Rate per second of log bytes received. gauge
gauge.sqlserver_performance.log_files_size_kb Size in KB of log file. gauge
gauge.sqlserver_performance.log_files_used_size_kb Size in KB of log file used. gauge
gauge.sqlserver_performance.log_flush_wait_time Time spent flushing the log. gauge
gauge.sqlserver_performance.log_flushes_persec Rate per second of log flushes. gauge
gauge.sqlserver_performance.log_send_queue Size of the log send queue. gauge
gauge.sqlserver_performance.logins_persec Rate of logins per second. gauge
gauge.sqlserver_performance.logouts_persec Rate of logouts per second. gauge
gauge.sqlserver_performance.memory_broker_clerk_size Size of memory broker clerk. gauge
gauge.sqlserver_performance.memory_grants_outstanding Number of outstanding memory grants. gauge
gauge.sqlserver_performance.memory_grants_pending Number of pending memory grants. gauge
gauge.sqlserver_performance.number_of_deadlocks_persec Rate of deadlocks per second. gauge
gauge.sqlserver_performance.page_life_expectancy Page life expectancy. gauge
gauge.sqlserver_performance.page_lookups_persec Rate of page look ups per second. gauge
gauge.sqlserver_performance.page_reads_persec Rate of page reads per second. gauge
gauge.sqlserver_performance.page_splits_persec Rate of page splits per second. gauge
gauge.sqlserver_performance.page_writes_persec Rate of page writes per second. gauge
gauge.sqlserver_performance.percent_log_used Percentage of log used. gauge
gauge.sqlserver_performance.processes_blocked Number of blocked processes. gauge
gauge.sqlserver_performance.queued_request_count Number of queued requests. gauge
gauge.sqlserver_performance.queued_requests Average number of queued requests. gauge
gauge.sqlserver_performance.readahead_pages_persec Rate per second of read ahead pages. gauge
gauge.sqlserver_performance.receives_from_replica_persec Rate receives from replicas per second. gauge
gauge.sqlserver_performance.recovery_queue Size of recovery queue. gauge
gauge.sqlserver_performance.redone_bytes_persec Rate of redone bytes per second. gauge
gauge.sqlserver_performance.reduced_memory_grant_count Number of reduced memory grants. gauge
gauge.sqlserver_performance.request_count Number of requests. gauge
gauge.sqlserver_performance.requests_completed_persec Rate of completed requests per second. gauge
gauge.sqlserver_performance.resent_messages_persec Rate of resent messages per second. gauge
gauge.sqlserver_performance.sends_to_replica_persec Rate of sends to replicas per second. gauge
gauge.sqlserver_performance.sends_to_transport_persec Rate of sends to transports per second. gauge
gauge.sqlserver_performance.sql_compilations_persec Rate of sql compilations per second. gauge
gauge.sqlserver_performance.sql_re-compilations_persec Rate of sql recompilations per sec. gauge
gauge.sqlserver_performance.target_server_memory_kb Size of target server memory in KB. gauge
gauge.sqlserver_performance.temp_tables_creation_rate Rate of temporary table creations. gauge
gauge.sqlserver_performance.temp_tables_for_destruction Number of temporary tables marked for destruction. gauge
gauge.sqlserver_performance.total_server_memory_kb Total server memory in KB. gauge
gauge.sqlserver_performance.transaction_delay Number of delayed transactions. gauge
gauge.sqlserver_performance.transactions_persec Rate of transactions per second. gauge
gauge.sqlserver_performance.used_memory_kb Used memory in KB. gauge
gauge.sqlserver_performance.user_connections Number of user connections. gauge
gauge.sqlserver_performance.version_store_size_kb Size of the version store in KB. gauge
gauge.sqlserver_performance.write_transactions_persec Rate of write transactions per second. gauge
gauge.sqlserver_performance.xtp_memory_used_kb Size of xtp memory used in KB. gauge
gauge.sqlserver_server_properties.available_storage_mb Available storage in MB. gauge
gauge.sqlserver_server_properties.cpu_count Number of cpus. gauge
gauge.sqlserver_server_properties.db_offline Number of offline databases. gauge
gauge.sqlserver_server_properties.db_online Number of online databases. gauge
gauge.sqlserver_server_properties.db_recovering Number of databases recovering. gauge
gauge.sqlserver_server_properties.db_recoverypending Number of databases pending recovery. gauge
gauge.sqlserver_server_properties.db_restoring Number of databases restoring. gauge
gauge.sqlserver_server_properties.db_suspect Number of suspect databases. gauge
gauge.sqlserver_server_properties.engine_edition Sql server engine edition version. gauge
gauge.sqlserver_server_properties.server_memory Amount of memory on the sql server. gauge
gauge.sqlserver_server_properties.total_storage_mb Amount of storage in MB of the sql server. gauge
gauge.sqlserver_server_properties.uptime Uptime of the sql server. gauge
gauge.sqlserver_waitstats.max_wait_time_ms Maximum time in millisecond spent waiting. gauge
gauge.sqlserver_waitstats.resource_wait_ms Time in milliseconds spent waiting on a resource. gauge
gauge.sqlserver_waitstats.signal_wait_time_ms Time in milliseconds waiting on a signal. gauge
gauge.sqlserver_waitstats.wait_time_ms Time in milliseconds waiting. gauge
gauge.sqlserver_waitstats.waiting_tasks_count Time in milliseconds gauge

gauge.sqlserver_database_io.read_bytes

gauge

Bytes read by the database.

gauge.sqlserver_database_io.read_latency_ms

gauge

Latency in milliseconds reading from the database.

gauge.sqlserver_database_io.reads

gauge

Number of reads from the database.

gauge.sqlserver_database_io.write_bytes

gauge

Bytes written to the database.

gauge.sqlserver_database_io.write_latency_ms

gauge

Latency in milliseconds writing to the database.

gauge.sqlserver_database_io.writes

gauge

Number of writes to the database.

gauge.sqlserver_memory_clerks.size_kb.bound_trees

gauge

Size in KB of bound trees memory clerk.

gauge.sqlserver_memory_clerks.size_kb.buffer_pool

gauge

Size in KB of buffer pool memory clerk.

gauge.sqlserver_memory_clerks.size_kb.connection_pool

gauge

Size in KB of connection pool memory clerk.

gauge.sqlserver_memory_clerks.size_kb.general

gauge

Size in KB of general memory clerk.

gauge.sqlserver_memory_clerks.size_kb.in-memory_oltp

gauge

Size in KB of in in-memoory oltp memory clerk.

gauge.sqlserver_memory_clerks.size_kb.log_pool

gauge

Size in KB of log pool memory clerk.

gauge.sqlserver_memory_clerks.size_kb.memoryclerk_sqltrace

gauge

Size in KB of sql trace memory clerk.

gauge.sqlserver_memory_clerks.size_kb.schema_manager_user_store

gauge

Size in KB of user store schema manager memory clerk.

gauge.sqlserver_memory_clerks.size_kb.sos_node

gauge

Size in KB of sos node memory clerk.

gauge.sqlserver_memory_clerks.size_kb.sql_optimizer

gauge

Size in KB of SQL optimizer memory clerk.

gauge.sqlserver_memory_clerks.size_kb.sql_plans

gauge

Size in KB of sql plans memory clerk.

gauge.sqlserver_memory_clerks.size_kb.sql_reservations

gauge

Size in KB of sql reservations memory clerk.

gauge.sqlserver_memory_clerks.size_kb.sql_storage_engine

gauge

Size in KB of sql storage engine memory clerk.

gauge.sqlserver_memory_clerks.size_kb.system_rowset_store

gauge

Size in KB of system rowset store memory clerk.

gauge.sqlserver_performance.active_memory_grant_amount_kb

gauge

Amount of active memory in KB granted.

gauge.sqlserver_performance.active_temp_tables

gauge

Number of active temporary tables.

gauge.sqlserver_performance.background_writer_pages_persec

gauge

Rate per second of pages written in the background.

gauge.sqlserver_performance.backup.restore_throughput_persec

gauge

Rate per second of backup/restore throughput.

gauge.sqlserver_performance.batch_requests_persec

gauge

Rate per second of batch requests.

gauge.sqlserver_performance.blocked_tasks

gauge

Number of blocked tasks.

gauge.sqlserver_performance.buffer_cache_hit_ratio

gauge

Buffer cache hit ration.

gauge.sqlserver_performance.bytes_received_from_replica_persec

gauge

Rate per second of bytes received from replicas.

gauge.sqlserver_performance.bytes_sent_to_replica_persec

gauge

Rate per second of bytes sent to replicas.

gauge.sqlserver_performance.bytes_sent_to_transport_persec

gauge

Rate per second of bytes sent to transports.

gauge.sqlserver_performance.checkpoint_pages_persec

gauge

Rate per second of checkpoint pages.

gauge.sqlserver_performance.cpu_limit_violation_count

gauge

Number of cpu limit violations.

gauge.sqlserver_performance.cpu_usage_percent

gauge

CPU usage percentage.

gauge.sqlserver_performance.cpu_usage_time

gauge

CPU usage time.

gauge.sqlserver_performance.data_files_size_kb

gauge

Size in KB of data files.

gauge.sqlserver_performance.disk_read_bytes_persec

gauge

Rate per second of bytes from disk.

gauge.sqlserver_performance.disk_read_io_persec

gauge

Rate per second of read operations from disk.

gauge.sqlserver_performance.disk_read_io_throttled_persec

gauge

Rate per second of throttled read operations.

gauge.sqlserver_performance.disk_write_bytes_persec

gauge

Rate per second of bytes written to disk.

gauge.sqlserver_performance.disk_write_io_persec

gauge

Rate per second of write operations to disk.

gauge.sqlserver_performance.disk_write_io_throttled_persec

gauge

Rate per second of write operations throttled.

gauge.sqlserver_performance.errors_persec

gauge

Rate of errors per second.

gauge.sqlserver_performance.flow_control_persec

gauge

Rate per second of flow control.

gauge.sqlserver_performance.flow_control_time_ms_persec

gauge

Rate per second of ms of flow control time.

gauge.sqlserver_performance.forwarded_records_persec

gauge

Rate per second of record forwarding.

gauge.sqlserver_performance.free_list_stalls_persec

gauge

Rate per second of stalled free list.

gauge.sqlserver_performance.free_space_in_tempdb_kb

gauge

Free space in KB of tempdb.

gauge.sqlserver_performance.full_scans_persec

gauge

Rate per second of full scans.

gauge.sqlserver_performance.index_searches_persec

gauge

Rate per second of index searches.

gauge.sqlserver_performance.latch_waits_persec

gauge

Rate per second of latch waits.

gauge.sqlserver_performance.lazy_writes_persec

gauge

Rate per second of lazy writes.

gauge.sqlserver_performance.lock_timeouts_persec

gauge

Rate per second of lock timeouts.

gauge.sqlserver_performance.lock_wait_count

gauge

Number of lock waits.

gauge.sqlserver_performance.lock_wait_time

gauge

Lock wait time.

gauge.sqlserver_performance.lock_waits_persec

gauge

Rate per second of lock waits.

gauge.sqlserver_performance.log_apply_pending_queue

gauge

Size of the log apply pending queue.

gauge.sqlserver_performance.log_apply_ready_queue

gauge

Size of log apply ready queue.

gauge.sqlserver_performance.log_bytes_flushed_persec

gauge

Rate per second of log bytes flushed.

gauge.sqlserver_performance.log_bytes_received_persec

gauge

Rate per second of log bytes received.

gauge.sqlserver_performance.log_files_size_kb

gauge

Size in KB of log file.

gauge.sqlserver_performance.log_files_used_size_kb

gauge

Size in KB of log file used.

gauge.sqlserver_performance.log_flush_wait_time

gauge

Time spent flushing the log.

gauge.sqlserver_performance.log_flushes_persec

gauge

Rate per second of log flushes.

gauge.sqlserver_performance.log_send_queue

gauge

Size of the log send queue.

gauge.sqlserver_performance.logins_persec

gauge

Rate of logins per second.

gauge.sqlserver_performance.logouts_persec

gauge

Rate of logouts per second.

gauge.sqlserver_performance.memory_broker_clerk_size

gauge

Size of memory broker clerk.

gauge.sqlserver_performance.memory_grants_outstanding

gauge

Number of outstanding memory grants.

gauge.sqlserver_performance.memory_grants_pending

gauge

Number of pending memory grants.

gauge.sqlserver_performance.number_of_deadlocks_persec

gauge

Rate of deadlocks per second.

gauge.sqlserver_performance.page_life_expectancy

gauge

Page life expectancy.

gauge.sqlserver_performance.page_lookups_persec

gauge

Rate of page look ups per second.

gauge.sqlserver_performance.page_reads_persec

gauge

Rate of page reads per second.

gauge.sqlserver_performance.page_splits_persec

gauge

Rate of page splits per second.

gauge.sqlserver_performance.page_writes_persec

gauge

Rate of page writes per second.

gauge.sqlserver_performance.percent_log_used

gauge

Percentage of log used.

gauge.sqlserver_performance.processes_blocked

gauge

Number of blocked processes.

gauge.sqlserver_performance.queued_request_count

gauge

Number of queued requests.

gauge.sqlserver_performance.queued_requests

gauge

Average number of queued requests.

gauge.sqlserver_performance.readahead_pages_persec

gauge

Rate per second of read ahead pages.

gauge.sqlserver_performance.receives_from_replica_persec

gauge

Rate receives from replicas per second.

gauge.sqlserver_performance.recovery_queue

gauge

Size of recovery queue.

gauge.sqlserver_performance.redone_bytes_persec

gauge

Rate of redone bytes per second.

gauge.sqlserver_performance.reduced_memory_grant_count

gauge

Number of reduced memory grants.

gauge.sqlserver_performance.request_count

gauge

Number of requests.

gauge.sqlserver_performance.requests_completed_persec

gauge

Rate of completed requests per second.

gauge.sqlserver_performance.resent_messages_persec

gauge

Rate of resent messages per second.

gauge.sqlserver_performance.sends_to_replica_persec

gauge

Rate of sends to replicas per second.

gauge.sqlserver_performance.sends_to_transport_persec

gauge

Rate of sends to transports per second.

gauge.sqlserver_performance.sql_compilations_persec

gauge

Rate of sql compilations per second.

gauge.sqlserver_performance.sql_re-compilations_persec

gauge

Rate of sql recompilations per sec.

gauge.sqlserver_performance.target_server_memory_kb

gauge

Size of target server memory in KB.

gauge.sqlserver_performance.temp_tables_creation_rate

gauge

Rate of temporary table creations.

gauge.sqlserver_performance.temp_tables_for_destruction

gauge

Number of temporary tables marked for destruction.

gauge.sqlserver_performance.total_server_memory_kb

gauge

Total server memory in KB.

gauge.sqlserver_performance.transaction_delay

gauge

Number of delayed transactions.

gauge.sqlserver_performance.transactions_persec

gauge

Rate of transactions per second.

gauge.sqlserver_performance.used_memory_kb

gauge

Used memory in KB.

gauge.sqlserver_performance.user_connections

gauge

Number of user connections.

gauge.sqlserver_performance.version_store_size_kb

gauge

Size of the version store in KB.

gauge.sqlserver_performance.write_transactions_persec

gauge

Rate of write transactions per second.

gauge.sqlserver_performance.xtp_memory_used_kb

gauge

Size of xtp memory used in KB.

gauge.sqlserver_server_properties.available_storage_mb

gauge

Available storage in MB.

gauge.sqlserver_server_properties.cpu_count

gauge

Number of cpus.

gauge.sqlserver_server_properties.db_offline

gauge

Number of offline databases.

gauge.sqlserver_server_properties.db_online

gauge

Number of online databases.

gauge.sqlserver_server_properties.db_recovering

gauge

Number of databases recovering.

gauge.sqlserver_server_properties.db_recoverypending

gauge

Number of databases pending recovery.

gauge.sqlserver_server_properties.db_restoring

gauge

Number of databases restoring.

gauge.sqlserver_server_properties.db_suspect

gauge

Number of suspect databases.

gauge.sqlserver_server_properties.engine_edition

gauge

Sql server engine edition version.

gauge.sqlserver_server_properties.server_memory

gauge

Amount of memory on the sql server.

gauge.sqlserver_server_properties.total_storage_mb

gauge

Amount of storage in MB of the sql server.

gauge.sqlserver_server_properties.uptime

gauge

Uptime of the sql server.

gauge.sqlserver_waitstats.max_wait_time_ms

gauge

Maximum time in millisecond spent waiting.

gauge.sqlserver_waitstats.resource_wait_ms

gauge

Time in milliseconds spent waiting on a resource.

gauge.sqlserver_waitstats.signal_wait_time_ms

gauge

Time in milliseconds waiting on a signal.

gauge.sqlserver_waitstats.wait_time_ms

gauge

Time in milliseconds waiting.

gauge.sqlserver_waitstats.waiting_tasks_count

gauge

Time in milliseconds