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.
Follow the installation instructions for the SignalFx Smart Agent.
Follow the configuration instructions for the Microsoft SQL Server monitor in the SignalFx Smart Agent documentation.
Bytes read by the database.
Latency in milliseconds reading from the database.
Number of reads from the database.
Bytes written to the database.
Latency in milliseconds writing to the database.
Number of writes to the database.
Size in KB of bound trees memory clerk.
Size in KB of buffer pool memory clerk.
Size in KB of connection pool memory clerk.
Size in KB of general memory clerk.
Size in KB of in in-memoory oltp memory clerk.
Size in KB of log pool memory clerk.
Size in KB of sql trace memory clerk.
Size in KB of user store schema manager memory clerk.
Size in KB of sos node memory clerk.
Size in KB of SQL optimizer memory clerk.
Size in KB of sql plans memory clerk.
Size in KB of sql reservations memory clerk.
Size in KB of sql storage engine memory clerk.
Size in KB of system rowset store memory clerk.
Amount of active memory in KB granted.
Number of active temporary tables.
Rate per second of pages written in the background.
Rate per second of backup/restore throughput.
Rate per second of batch requests.
Rate per second of bytes received from replicas.
Rate per second of bytes sent to replicas.
Rate per second of bytes sent to transports.
Rate per second of checkpoint pages.
Number of cpu limit violations.
Size in KB of data files.
Rate per second of bytes from disk.
Rate per second of read operations from disk.
Rate per second of throttled read operations.
Rate per second of bytes written to disk.
Rate per second of write operations to disk.
Rate per second of write operations throttled.
Rate of errors per second.
Rate per second of flow control.
Rate per second of ms of flow control time.
Rate per second of record forwarding.
Rate per second of stalled free list.
Free space in KB of tempdb.
Rate per second of full scans.
Rate per second of index searches.
Rate per second of latch waits.
Rate per second of lazy writes.
Rate per second of lock timeouts.
Rate per second of lock waits.
Size of the log apply pending queue.
Size of log apply ready queue.
Rate per second of log bytes flushed.
Rate per second of log bytes received.
Size in KB of log file.
Size in KB of log file used.
Time spent flushing the log.
Rate per second of log flushes.
Size of the log send queue.
Rate of logins per second.
Rate of logouts per second.
Size of memory broker clerk.
Number of outstanding memory grants.
Number of pending memory grants.
Rate of deadlocks per second.
Rate of page look ups per second.
Rate of page reads per second.
Rate of page splits per second.
Rate of page writes per second.
Average number of queued requests.
Rate per second of read ahead pages.
Rate receives from replicas per second.
Rate of redone bytes per second.
Number of reduced memory grants.
Rate of completed requests per second.
Rate of resent messages per second.
Rate of sends to replicas per second.
Rate of sends to transports per second.
Rate of sql compilations per second.
Rate of sql recompilations per sec.
Size of target server memory in KB.
Rate of temporary table creations.
Number of temporary tables marked for destruction.
Total server memory in KB.
Rate of transactions per second.
Size of the version store in KB.
Rate of write transactions per second.
Size of xtp memory used in KB.
Number of databases pending recovery.
Sql server engine edition version.
Amount of memory on the sql server.
Amount of storage in MB of the sql server.
Uptime of the sql server.
Maximum time in millisecond spent waiting.
Time in milliseconds spent waiting on a resource.
Time in milliseconds waiting on a signal.