Release number | sql-server.releaseNumber | Release number of SQL Server | Unspecified |
Physical memory | sql-server.memory.physical | Total amount of physical memory on the machine | KiloByte |
Virtual memory | sql-server.memory.virtual | Total amount of virtual address space available to the process in user mode | KiloByte |
Total server memory | sql-server.memory.total | Amount of memory the server has committed using the memory manager | KiloByte |
Target server memory | sql-server.memory.target | Amount of memory that can be consumed by memory manager | KiloByte |
Time spent in kernel mode | sql-server.cpu.kernelTime.count | Time spent by all threads in kernel mode | MilliSecond |
Time spent in user mode | sql-server.cpu.userTime.count | Time spent by all threads in user mode | MilliSecond |
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 |
Logins | sql-server.general.logins.count | Number of logins started, excluding pooled connections | Count |
User connections | sql-server.general.userConnections | Number of users currently connected to SQL Server | Count |
Processes blocked | sql-server.general.processesBlocked | Number of currently blocked processes | Count |
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 |
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 |
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 |
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 |