SQL Server Metrics
Database metrics are a comprehensive collection of database workloads and resource usages. The WhaTap monitoring service continuously collects metrics to identify bottlenecks in the database and provides data to help identify the root causes of performance issues.
For more information about columns, see the link.
agent_status_summary
This category collects metrics related to agent status every 10 seconds.
Fields
| Field name | Unit | Description | Remarks |
|---|---|---|---|
inActTime | Millisecond(ms) | Amount of time the agent remains inactive | - |
isActive | - | Whether the agent is active or not | true / false |
isRestart | - | Whether the agent has been recently restarted | true / false |
lastActTime | Millisecond(ms) | Time when the agent was last activated | 0: If disabled |
oid | - | Unique IDs for each agent in the project | - |
startTime | Millisecond(ms) | Timestamp when the agent was started. | - |
db_mssql_counter
Tags
The following lists the tags that are collected in the db_mysql_counter category.
| Tag name | Description | Remarks |
|---|---|---|
agentIp | IP address per agent. | - |
dbIsMulti | Whether to support the multitenant or not. | - |
dbName | Database name. | - |
dbType | Database type. | - |
dbVersion | Version of the database in use. | - |
oname | Agent name | Unique value |
Field
The following lists the fields that are collected in the db_mysql_counter category.
| Metrics | Description |
|---|---|
active_sessions | Number of active sessions. |
connect_error | Number of connection errors. |
cpu | Total rate of the CPU used by the SQL Server instances. |
cpu_cores | Number of available CPU cores |
fatal_count | Number of fatal errors. |
lock_wait_sessions | Number of sessions delayed due to locks. |
long_running_sessions | Number of long running sessions. |
memory | Total amount of memory used by SQL Server. |
sys_cpu | Total rate of the system CPU used by the SQL Server instances. |
total_elapsed_time | Total elapsed time for all requests run by SQL Server. |
total_sessions | Total number of sessions connected to SQL Server. |
user_cpu | Rate of the CPU used by SQL Server operations run in user mode. |
warning_count | Number of warnings occurred. |
ASYNC_NETWORK_IO(count) | Number of requests processed asynchronously while waiting for network I/O. |
ASYNC_NETWORK_IO(time) | Total time (milliseconds) for the requests processed asynchronously while waiting for network I/O. |
Batch_Requests/sec | Number of batch requests per second. |
Buffer_cache_hit_ratio | Rate of the data read from the buffer cache when requesting data. |
Buffer_cache_hit_ratio_base | Reference value for calculating Buffer_cache_hit_ratio. |
Cache_Hit_Ratio | Rate at which data was found in the cache. |
Cache_Hit_Ratio_Base | Reference value for calculating Cache_Hit_Ratio. |
Cache_Pages | Number of pages used in the cache of SQL Server. |
Cache_Pages(Bound_Trees) | Number of pages stored in the bind tree cache. |
Cache_Pages(Extended_Stored_Procedures) | Number of cache pages used by extended stored procedures. |
Cache_Pages(Object_Plans) | Number of cache pages used in the SQL object plans. |
Cache_Pages(SQL_Plans) | Number of cache pages used in the SQL plans. |
Cache_Pages(Temporary_Tables_&_Table_Variables) | Number of cache pages used for temporary tables and table variables. |
Checkpoint_pages/sec | Number of checkpoint pages per second. |
Database_Cache_Memory_(KB) | Amount of memory (KB) used in the database cache. |
Database_pages | Number of pages used in the database of SQL Server. |
Errors/sec | Number of errors per second. |
FreeSpace_Scans/sec | Number of free space scans per second. |
Free_Memory_(KB) | Available memory size (KB). |
Full_Scans/sec | Number of full scans per second in the table or index. |
LATCH_EX(count) | Number of exclusive latch requests. |
LATCH_SH(count) | Number of shared latch requests. |
LATCH_SH(time) | Total time spent on shared latch requests. |
LCK_M_U(count) | Number of update lock requests. |
LCK_M_U(time) | Total time spent on update lock requests. |
Latch_Waits/sec | Number of latch waits per second. |
Lazy_writes/sec | Number of delayed pages written to disk per second. |
Lock_Requests/sec | Number of lock requests per second. |
Log_Flushes/sec | Number of log flushes per second. |
MEMORY_ALLOCATION_EXT(count) | Number of memory allocation expansions. |
MEMORY_ALLOCATION_EXT(time) | Total time spent expanding memory allocations. |
Memory_Grants_Outstanding | Number of requests that have completed waiting for memory allocation. |
Memory_Grants_Pending | Number of requests waiting for memory allocation. |
Number_of_Deadlocks/sec | Number of deadlocks per second. |
PAGEIOLATCH_EX(count) | Number of exclusive latch requests made during I/O operations. |
PAGEIOLATCH_EX(time) | Total time spent on exclusive latch requests during I/O operations. |
PAGEIOLATCH_UP(count) | Number of update latch requests made during I/O operations. |
PAGEIOLATCH_UP(time) | Total time spent on update latch requests during I/O operations. |
PAGELATCH_EX(count) | Number of exclusive latch requests at the page level. |
PAGELATCH_EX(time) | Total time spent on exclusive latch requests in the page level. |
PAGELATCH_SH(count) | Number of shared latch requests at the page level. |
PAGELATCH_SH(time) | Total time spent on shared latch requests in the page level. |
PREEMPTIVE_OS_AUTHENTICATIONOPS(count) | Number of pre-emptive operation requests for authentication. |
PREEMPTIVE_OS_AUTHENTICATIONOPS(time) | Time spent on pre-emptive operation requests for authentication. |
PREEMPTIVE_OS_AUTHORIZATIONOPS(count) | Number of pre-emptive operation requests for role allocation. |
PREEMPTIVE_OS_DELETESECURITYCONTEXT(count) | Number of pre-abortive operation requests for security context deletion operation. |
PREEMPTIVE_OS_DELETESECURITYCONTEXT(time) | Total time spent deleting security contexts. |
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE(count) | Number of pre-emptive operation requests for named pipe disconnect operations. |
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES(count) | Number of pre-emptive operation requests for context property query operations. |
PREEMPTIVE_OS_QUERYREGISTRY(count) | Number of pre-emptive operation requests for registry query operations. |
PREEMPTIVE_OS_QUERYREGISTRY(time) | Total time spent on registry query operations. |
PREEMPTIVE_OS_REVERTTOSELF(count) | Number of pre-emptive operation requests for reverting to itself. |
PREEMPTIVE_OS_REVERTTOSELF(time) | Total time spent on operations reverting to itself. |
PREEMPTIVE_XE_CALLBACKEXECUTE(count) | Number of pre-emptive operation requests for event tracing callback operations. |
PREEMPTIVE_XE_CALLBACKEXECUTE(time) | Total time spent executing event tracing callbacks. |
PREEMPTIVE_XE_GETTARGETSTATE(count) | Number of pre-emptive operation requests for the event tracing target status checking. |
PREEMPTIVE_XE_GETTARGETSTATE(time) | Total time spent checking the status of the event tracing targets. |
PREEMPTIVE_XE_SESSIONCOMMIT(count) | Number of pre-emptive operation requests for event tracing session commit operations. |
PREEMPTIVE_XE_SESSIONCOMMIT(time) | Total time spent on event tracing session commit operations. |
PREEMPTIVE_XE_TARGETFINALIZE(count) | Number of pre-emptive operation requests for event tracing target finalization. |
PREEMPTIVE_XE_TARGETINIT(count) | Number of pre-emptive operation requests for event tracing target initialization. |
Page_life_expectancy | Average time a page spends waiting in memory. |
Page_lookups/sec | Number of page views per second. |
Page_reads/sec | Number of pages read from disk per second. |
Page_writes/sec | Number of pages written to disk per second. |
RESERVED_MEMORY_ALLOCATION_EXT(count) | Number of reserved memory allocation expansions. |
RESERVED_MEMORY_ALLOCATION_EXT(time) | Total time spent expanding reserved memory allocations. |
Range_Scans/sec | Number of range scans per second. |
SOS_SCHEDULER_YIELD(count) | Number of cases the scheduler has yielded to process tasks. |
SOS_SCHEDULER_YIELD(time) | Total time the scheduler has yielded to process tasks. |
SOS_WORK_DISPATCHER(count) | Number of cases the SOS work dispatcher processed tasks. |
SOS_WORK_DISPATCHER(time) | Total time the SOS work dispatcher processed tasks. |
SQL_Compilations/sec | Number of SQL compilations per second. Compilation occurs when the SQL code is first executed. |
SQL_Re-Compilations/sec | Number of SQL recompilations per second. Recompilation occurs when the cached plan is invalid. |
Stolen_Server_Memory_(KB) | Amount of memory (KB) that SQL Server has taken for internal use. |
Total_Latch_Wait_Time_(ms) | Total waiting time (milliseconds) caused by latch wait. |
Total_Server_Memory_(KB) | Total amount of memory (KB) currently used by SQL Server. |
Transactions/sec | Number of transactions processed per second |
User_Connections | Number of user sessions currently connected to SQL Server. |
WAIT_ON_SYNC_STATISTICS_REFRESH(count) | Number of requests to wait for statistics synchronization. |
WAIT_ON_SYNC_STATISTICS_REFRESH(time) | Total time spent waiting for statistics synchronization requests. |
WRITELOG(count) | Number of log write operations. |
WRITELOG(time) | Total time spent writing logs. |
XE_BUFFERMGR_ALLPROCESSED_EVENT(count) | Number of events in the trace buffer manager where all events have been processed. |
XE_BUFFERMGR_ALLPROCESSED_EVENT(time) | Event processing time of the trace buffer manager where all events have been processed. |