SQL Server Monitoring | Dynatrace Hub

Metric name	Metric key	Description	Unit
Uptime	sql-server.sessions	Number of active sessions per user	Count

Metric name	Metric key	Description	Unit
Latch waits	sql-server.latches.waits.count	Number of latch requests that could not be granted immediately	Count
Average latch wait time	sql-server.latches.averageWaitTime.count	Average latch wait time for latch requests that had to wait	MilliSecond

Metric name	Metric key	Description	Unit
Bytes sent to replica	sql-server.replica.bytesSent.count	Message bytes queued to be sent to replicas	Byte
Sends to replica	sql-server.replica.sends.count	Number of messages queued to be sent to replica	Count
Bytes sent to transport	sql-server.replica.bytesSentToTransport.count	Dequeued message bytes sent across network to replicas	Byte
Sends to transport	sql-server.replica.sendsToTransport.count	Number of messages sent across network to replicas	Count
Bytes received from replica	sql-server.replica.bytesReceived.count	Message bytes received from replica	Byte
Receives from replica	sql-server.replica.receives.count	Number of messages received from replica	Count
Resent messages	sql-server.replica.resentMessages.count	Number of messages that had to be resent to replica	Count

Metric name	Metric key	Description	Unit
Log files size	sql-server.databases.log.filesSize	Cumulative size of all the transaction log files in the database	KiloByte
Log files used size	sql-server.databases.log.filesUsedSize	The cumulative used size of all the log files in the database	KiloByte
Log flush waits	sql-server.databases.log.flushWaits.count	Number of commits waiting for the log flush	Count
Log growths	sql-server.databases.log.growths.count	Number of times the transaction log for the database has been expanded	Count
Log shrinks	sql-server.databases.log.shrinks.count	Number of log shrinks for this database	Count
Log truncations	sql-server.databases.log.truncations.count	Number of times the transaction log has been truncated (in Simple Recovery Model)	Count
Percent log used	sql-server.databases.log.percentUsed	Percantage of space in the log that is in use	Percent

Metric name	Metric key	Description	Unit
Batch requests	sql-server.sql.batchRequests.count	Number of Transact-SQL command batches received	Count
SQL compilations	sql-server.sql.compilations.count	Number of SQL statement compilations	Count
SQL re-compilations	sql-server.sql.recompilations.count	Number of SQL statement re-compilations	Count

Metric name	Metric key	Description	Unit
Lock timeouts	sql-server.locks.timeouts.count	Number of lock requests that timed out, including requests for NOWAIT locks	Count
Deadlocks	sql-server.locks.deadlocks.count	Number of lock requests that resulted in a deadlock	Count
Lock waits	sql-server.locks.waits.count	Number of lock requests that required the caller to wait	Count
Lock wait time	sql-server.locks.waitTime.count	Wait time for locks	MilliSecond

Metric name	Metric key	Description	Unit
Minutes since last backup	sql-server.databases.backup.age	Number of minutes passed since last backup	Minute
Size of the last backup	sql-server.databases.backup.size	Size of the last backup of that type	Byte

Metric name	Metric key	Description	Unit
Database file size	sql-server.databases.file.size	Total size of files of specific types per database	KiloByte
Database file used size	sql-server.databases.file.usedSpace	Total size of space used in files of specific types per database	KiloByte
Database file empty size	sql-server.databases.file.emptySpace	Total size of empty space in files of specific types per database	KiloByte

Metric name	Metric key	Description	Unit
Automated backup preference	sql-server.always-on.ag.automatedBackupPreference	Preferred location for backups in this availability group	State
Primary recovery health	sql-server.always-on.ag.primaryRecoveryHealth	Indicates the recovery health of the primary replica	State
Secondary recovery health	sql-server.always-on.ag.secondaryRecoveryHealth	Indicates the recovery health of a secondary replica	State
Synchronization health	sql-server.always-on.ag.synchronizationHealth	Reflects a rollup of the synchronization health of all replicas the group	State
Availability mode	sql-server.always-on.ar.availabilityMode	The availability mode of the replica	State
Failover mode	sql-server.always-on.ar.failoverMode	The failover mode of the replica	State
Is replica local	sql-server.always-on.ar.isLocal	Whether the replica is local	State
Replica role	sql-server.always-on.ar.role	Current groups role of a local replica or a connected remote replica	State
Operational state	sql-server.always-on.ar.operationalState	Current operational state of the replica	State
Recovery health	sql-server.always-on.ar.recoveryHealth	Rollup of the database_state column	State
Synchronization health	sql-server.always-on.ar.synchronizationHealth	Rollup of the database synchronization state of all joined replicas and the availability mode of the replica	State
Connected state	sql-server.always-on.ar.connectedState	Whether a secondary replica is currently connected to the primary replica	State
Synchronization state	sql-server.always-on.db.synchronizationState	Data-movement state	State
Synchronization health	sql-server.always-on.db.synchronizationHealth	Intersection of the synchronization state of a database that is joined to the group on the replica and the availability mode of the replica	State
Database state	sql-server.always-on.db.state	State of the availability database	State
Log send queue size	sql-server.always-on.db.logSendQueueSize	Amount of log records of the primary database not sent to the secondary databases	KibiByte
Log send rate	sql-server.always-on.db.logSendRate	Average rate at which primary replica instance sends data	KiloBytePerSecond
Redo queue size	sql-server.always-on.db.redoQueueSize	Amount of log records in the log files of the secondary replica that has not yet been redone	KiloByte
Redo rate	sql-server.always-on.db.redoRate	Average Rate at which the log records are being redone on a given secondary database	KiloBytePerSecond
Filestream send rate	sql-server.always-on.db.filestreamSendRate	The rate at which the filestream files are shipped to the secondary replica	KiloBytePerSecond

Metric name	Metric key	Description	Unit
Free list stalls	sql-server.buffers.freeListStalls.count	Number of requests that had to wait for a free page	Count
Page reads	sql-server.buffers.pageReads.count	Number of physical database page reads that are issued	Count
Page writes	sql-server.buffers.pageWrites.count	Number of physical database page writes that are issued	Count
Checkpoint pages	sql-server.buffers.checkpointPages.count	Number of pages flushed to disk by a checkpoint or other operations that require all dirty pages to be flushed	Count
Page life expectancy	sql-server.buffers.pageLifeExpectancy	Number of seconds a page will stay in the buffer pool without references	Second
Connection memory	sql-server.memory.connection	Total amount of dynamic memory the server is using for maintaining connections	KiloByte
Memory grants outstanding	sql-server.memory.grantsOutstanding	Number of processes that have successfully acquired a workspace memory grant	Count
Memory grants pending	sql-server.memory.grantsPending	Number of processes waiting for a workspace memory grant	Count
Buffer cache hit	sql-server.buffers.cacheHitRatio	Percentage of pages found in the buffer cache without having to read from disk	Percent