Supported Metrics
The following tabs represent the Metric Category of MS SQL Cluster.
Availability
Performance
Usage
| Native Type | Metric Name | Display Name | Units | Application Version | Description |
|---|---|---|---|---|---|
| MSSQL Windows Failover Cluster | mssql_cluster_node_state | MSSQL Windows Failover Cluster Node State | 1.0.1 | State of all nodes of the cluster such as up or down. Possible values 0-DOWN,1-UP | |
| mssql_cluster_node_health | MSSQL Windows Failover Cluster Node Health | % | 1.0.1 | Cluster health - percentage of online nodes | |
| mssql_cluster_online_nodes_count | MSSQL Windows Failover Cluster Online nodes count | count | 1.0.1 | Count of nodes which are in Online state | |
| MSSQL Windows Failover Cluster Node | mssql_cluster_node_service_status | MSSQL Windows Cluster Node Service Status | 1.0.1 | State of each node's windows os service named cluster service which is responsible for windows failover cluster. Possible values 0-STOPPED,1-RUNNING,2-Start Pending, 3-Stop Pending, 4-Continue Pending, 5-Pause Pending, 6-Paused, 7-Unknown | |
| mssql_cluster_node_system_networkInterfaceOutErrors | MSSQL Windows Cluster Node System Network Out Errors | Errors per Sec | 2.0.0 | Monitors network out errors of each interface for windows Devices | |
| mssql_cluster_node_system_networkInterfaceInErrors | MSSQL Windows Cluster Node System Network In Errors | Errors per Sec | 2.0.0 | Monitors network in errors of each interface for windows Devices | |
| mssql_cluster_node_system_os_Uptime | MSSQL Windows Cluster Node System OS Uptime | m | 1.0.1 | Time lapsed since last reboot in minutes | |
| mssql_cluster_node_sqlservices_state | MSSQL Windows Cluster Node SQL services running state | 1.0.1 | Monitors sql services state. Possible values 0-STOPPED,1-RUNNING,2-Start Pending, 3-Stop Pending, 4-Continue Pending, 5-Pause Pending, 6-Paused, 7-Unknown | ||
| mssql_cluster_node_system_networkInterfaceOutDiscords | MSSQL Windows Cluster Node System Network Out discards | psec | 2.0.0 | Monitors Network Out discards of each interface for windows Devices | |
| mssql_cluster_node_system_networkInterfaceInDiscords | MSSQL Windows Cluster Node System Network In discards | psec | 2.0.0 | Monitors Network in discards of each interface for windows Devices | |
| MSSQL Windows Failover Cluster Role | mssql_cluster_group_listener_status | MSSQL Windows cluster group listener status | 1.0.1 | Monitors MSSQL cluster group listeners status. Possible values 0-OFFLINE, 1-ONLINE, 2-Initializing, 3-Failed, 4-Pending, 5-OnlinePending, 6-OfflinePending, 7-Unknown. | |
| mssql_cluster_AG_instance_status | MSSQL Windows cluster availability group instance status | 1.0.1 | Monitors MSSQL availability group cluster instance status. Possible values 0-OFFLINE,1-ONLINE 2-Initializing, 3-Failed, 4-Pending, 5-OnlinePending, 6-OfflinePending, 7-Unknown. This metric is applicable only for AAG clusters.Note: Applicable for only `AvailabilityGroup` cluster. | ||
| mssql_cluster_group_running_status | MSSQL Windows Cluster Group Running Status | 1.0.1 | State of cluster group of the failover cluster. Possible values 0-OFFLINE, 1-ONLINE, 2-Initializing, 3-Failed, 4-Pending, 5-OnlinePending, 6-OfflinePending, 7-Unknown. | ||
| mssql_cluster_group_failover_status | MSSQL Windows Cluster Group Failover Status | Whenever the owner node which is hosting all the cluster services, goes down any other node becomes owner node automatically. This metric explains whether the current node was the owner node, when the last failover happened. Possible instance values, 0-if there is no change in OwnerNode, 1-If there is a change in ownerNode, 2-If no OwnerNode | |||
| MSSQL Windows Failover Cluster Storage Disk | mssql_cluster_disk_Usedspace | MSSQL Windows System Disk UsedSpace | GB | 1.0.1 | Monitors disk used space in GB |
| mssql_cluster_disk_AvailabilityStatus | MSSQL Windows System Disk availability status | 1.0.1 | Monitors system disk availability status. Possible values 0-OFFLINE, 1-ONLINE, 2-Initializing, 3-Failed, 4-Pending, 5-OnlinePending, 6-OfflinePending, 7-Unknown. | ||
| MSSQL Server Instance | mssql_cluster_cpuIdle | MSSQL Cluster CPU Idle | microsec | 1.0.1 | MSSQL CPU IDLE |
| mssql_cluster_totalServerMemory | MSSQL Cluster Total Server Memory | KB | 1.0.1 | Total amount of dynamic memory the server is currently consuming | |
| mssql_cluster_cpuBusy | MSSQL Cluster Cluster CPU Busy | microsec | 1.0.1 | MSSQL CPU Busy | |
| mssql_cluster_alwaysOnDBAvailabilitySyncHealth | MSSQL Cluster AlwaysOn DB Avalability Sync Health | 1.0.1 | MSSQL AlwaysOn DataBase Availability Synchronization Health - Below are the possible states:0 : NOT_HEALTHY 1 : PARTIALLY_HEALTHY 2 : HEALTHY | ||
| MSSQL Server Instance | mssql_cluster_serverIOBusy | MSSQL Cluster Server IO Busy | % | 1.0.1 | Monitors MSSQL DB Server IO Busy |
| mssql_cluster_alwaysOnAGSyncHealth | MSSQL Cluster AlwaysOn AG Sync Health | 1.0.1 | MSSQL AlwaysOn Availability Group Synchronization Health - Below are the possible values: 0 : NOT_HEALTHY 1 : PARTIALLY_HEALTHY 2 : HEALTHY | ||
| mssql_cluster_databasesCount | MSSQL Cluster Databases Count | count | 1.0.1 | Show the count of total number of databases | |
| mssql_cluster_minsSinceLastLogBackup | MSSQL Cluster Mins since Last Log Backup | m | Monitors Database transaction log backup in minutes | ||
| MSSQL Node | mssql_node_system_CpuIdleTime | MSSQL Node System CPU IdleTime | % | 3.0.0 | Monitors cpu time in percentage spent in various program spaces. User - The processor time spent running user space processes System - The amount of time that the CPU spent running the kernel. IOWait - The time the CPU spends idle while waiting for an I/O operation to complete Idle - The time the processor spends idle Steal - The time virtual CPU has spent waiting for the hypervisor to service another virtual CPU running on a different virtual machine. Kernal Time Total Time |
| mssql_node_system_MemoryUsedspace | MSSQL Node System Memory Used Space | GB | 3.0.0 | Physical and virtual memory usage in GB | |
| mssql_node_system_NetworkInterfaceInDiscords | MSSQL Node System Network In discards | psec | 3.0.0 | Monitors Network in discards of each interface for windows Devices | |
| mssql_node_system_NetworkInterfaceOutErrors | MSSQL Node System Network Out Errors | Errors per Sec | 3.0.0 | Monitors network out errors of each interface for windows Devices | |
| mssql_node_diskdrive_UsedSpace | MSSQL Node Disk Drive UsedSpace | GB | 3.0.0 | Monitors disk drive used space in GB | |
| mssql_node_system_NetworkInterfaceOutPackets | MSSQL Node System Network out packets | packets/sec | 3.0.0 | Monitors Out packets of each interface for windows Devices | |
| MSSQL Node Server Instance | mssql_node_sqlinstance_DbWorkspaceMemory | MSSQL Node SQL Instance DB Workspace Memory | % | 3.0.0 | Monitors MSSQL Database Workspace Memory in Percentage. |
| mssql_node_sqlinstance_AlwaysOnAGSyncHealth | MSSQL Node SQL Instance AlwaysOn AG Sync Health | 3.0.0 | MSSQL AlwaysOn Availability Group Synchronization Health - Below are the possible values: 0 : NOT_HEALTHY 1 : PARTIALLY_HEALTHY 2 : HEALTHY.Note: Applicable for only `AvailabilityGroup` cluster. | ||
| mssql_node_sqlinstance_InstanceFreeConnections | MSSQL Node SQL Instance Free Connections | % | 3.0.0 | Monitors MSSQL Database Instance Free Connections in percentage | |
| mssql_node_sqlinstance_DaysSinceLastFullBackup | MSSQL Node SQL Instance Days since Last Full Backup | Days | 3.0.0 | MSSQL DB Backup Days Since Last Full Backup | |
| mssql_node_sqlinstance_AlwaysOnDBAvailabilitySyncHealth | MSSQL Node SQL Instance AlwaysOn DB Avalability Sync Health | 3.0.0 | MSSQL AlwaysOn DataBase Availability Synchronization Health - Below are the possible states:0 : NOT_HEALTHY 1 : PARTIALLY_HEALTHY 2 : HEALTHY.Note: Applicable for only `AvailabilityGroup` cluster. | ||
| mssql_node_sqlinstance_FullScans | MSSQL Node SQL Server Full Scans | psec | 5.0.0 | Number of unrestricted full scans. These can either be base table or full index scans. | |
| mssql_node_sqlinstance_LongRunningQueriesLast5minCount | MSSQL Node SQL Instance Long Running Queries Last 5min Count | count | 5.0.0 | Monitors MSSQL Database Long Running queries count Last 5 minutes | |
| MSSQL Server Database | mssql_sqlserver_dbBufferCacheHitRatio | MSSQL Sqlserver Buffer Cache Hit Ration | % | 5.0.0 | This metric displays the vcenter server total memory |
| mssql_sqlserver_dbFileGroupFreespaceWithAvailableDisk | MSSQL Sqlserver File Group Free Space with Available Disk | % | 6.0.0 | Monitor MSSQL DB Filegroup Freespace with Available Disk | |
| mssql_sqlserver_alwayson_database_replicaState | MSSQL Sqlserver AlwaysOn DataBase Replica State | 6.0.0 | It monitor the MSSQL Always On Database Replica synchronization state along with role description.It monitor the MSSQL Always On Database Replica synchronization state along with role description. Below are the possible states: PRIMARY_NOT SYNCHRONIZING - 0, PRIMARY_SYNCHRONIZING - 1, PRIMARY_SYNCHRONIZED - 2, PRIMARY_REVERTING - 3, PRIMARY_INITIALIZING - 4, SECONDARY_NOT SYNCHRONIZING - 5, SECONDARY_SYNCHRONIZING - 6, SECONDARY_SYNCHRONIZED - 7, SECONDARY_REVERTING - 8, SECONDARY_INITIALIZING - 9. This metric is applicable only for AAG clusters. | ||
| MSSQL Windows Service Group | mssql_cluster_serviceGroup_Status | MSSQL Windows Service Group Status | 6.0.0 | State of cluster group of the failover cluster. Possible values 0-OFFLINE,1-ONLINE, 2-Initializing, 3-Failed, 4-Pending, 5-OnlinePending, 6-OfflinePending, 7-Unknown | |
| mssql_cluster_serviceGroup_FailoverStatus | MSSQL Windows Service Group FailOver Status | 6.0.0 | Whenever the owner node which is hosting all the cluster services, goes down any other node becomes owner node automatically. This metric explains whether the current node was the owner node, when the last failover happened. Possible instance values, 0-if there is no change in OwnerNode, 1-If there is a change in ownerNode, 2-If no OwnerNode |
| Native Type | Metric Name | Display Name | Units | Application Version | Description |
|---|---|---|---|---|---|
| MSSQL Windows Failover Cluster Node | mssql_cluster_node_system_networkInterfaceInPackets | MSSQL Windows Cluster Node System Network In packets | packets/sec | 2.0.0 | Monitors in Packets of each interface for windows Devices |
| mssql_cluster_node_system_networkInterfaceOutPackets | MSSQL Windows Cluster Node System Network out packets | packets/sec | 2.0.0 | Monitors Out packets of each interface for windows Devices | |
| mssql_cluster_node_system_networkInterfaceOutTraffic | MSSQL Windows Cluster Node System Network Out Traffic | Kbps | 2.0.0 | Monitors Out traffic of each interface for windows Devices | |
| MSSQL Server Instance | mssql_cluster_longRunningQueriesLast5minCount | MSSQL Cluster Long Running Queries Last 5min Count | count | 1.0.1 | Monitors MSSQL Database Long Running queries count Last 5 minutes |
| mssql_cluster_dbInstanceCpuUtilization | MSSQL Cluster DB Instance CPU Utilization | % | 1.0.1 | Monitors MSSQL Database Instance CPU Utilization in percentage | |
| mssql_cluster_fullScans | MSSQL Cluster SQL Server Full Scans | psec | 1.0.1 | Number of unrestricted full scans. These can either be base table or full index scans. | |
| mssql_cluster_sqlCacheMemory | MSSQL Cluster Cache Memory | KB | 1.0.1 | Total amount of dynamic memory the server is using for the dynamic SQL cache | |
| mssql_cluster_instance_FailoverStatus | MSSQL Cluster Instance Failover Status | 1.0.1 | Monitors MSSQL cluster instance failover status. Possible instance values, 0-if there is no change in OwnerNode, 1-If there is a change in ownerNode, 2 If no OwnerNode | ||
| mssql_cluster_dbWorkspaceMemory | MSSQL Cluster DB Workspace Memory | % | 1.0.1 | Monitors MSSQL Database Workspace Memory in Percentage. | |
| mssql_cluster_daysSinceLastFullBackup | MSSQL Cluster Days since Last Full Backup | Days | 1.0.1 | MSSQL DB Backup Days Since Last Full Backup | |
| mssql_cluster_avgLockWaitTime | MSSQL Cluster Average Lock Wait Time | ms | 1.0.1 | The average amount of wait time (milliseconds) for each lock request that resulted in a wait. | |
| mssql_cluster_serverUptime | MSSQL Cluster Server Uptime | Days | 1.0.1 | Monitors the uptime (in days) of the database server | |
| mssql_node_system_NetworkInterfaceOutDiscords | MSSQL Node System Network Out discards | psec | 3.0.0 | Monitors Network Out discards of each interface for windows Devices | |
| mssql_node_system_MemoryUtilization | MSSQL Node System Memory Utilization | % | 3.0.0 | Physical and virtual memory usage in percentage. | |
| MSSQL Node Server Instance | mssql_node_system_CpuUtilization | MSSQL Node System CPU Utilization | % | 3.0.0 | The percentage of elapsed time that the processor spends to execute a non-Idle thread(This doesn't includes CPU steal time) |
| mssql_node_sqlinstance_DatabasesCount | MSSQL Node SQL Instance Databases Count | count | 3.0.0 | Show the count of total number of databases | |
| mssql_node_sqlinstance_MinsSinceLastLogFullBackup | MSSQL Node SQL Instance Mins since Last Log Full Backup | m | 3.0.0 | Monitors Database Backup status in Minutes since Last Full Backup | |
| mssql_node_sqlinstance_AlwaysOnDatabaseReplicaState | MSSQL Node SQL Instance AlwaysOn DataBase Replica State | 3.0.0 | It monitor the MSSQL Always On Database Replica synchronization state along with role description.--Below are the possible states:--PRIMARY_NOT SYNCHRONIZING - 0-PRIMARY_SYNCHRONIZING - 1-PRIMARY_SYNCHRONIZED - 2-PRIMARY_REVERTING - 3-PRIMARY_INITIALIZING - 4-SECONDARY_NOT SYNCHRONIZING - 5-SECONDARY_SYNCHRONIZING - 6-SECONDARY_SYNCHRONIZED - 7-SECONDARY_REVERTING - 8-SECONDARY_INITIALIZING - 9.Note: Applicable for only `AvailabilityGroup` cluster.Note: This metric will be available under new native type MSSQL Server Database from 5.0.0 version onwards. | ||
| mssql_node_sqlinstance_AlwaysOnListenerState | MSSQL Node SQL Instance AlwaysOn Listener State | 3.0.0 | MSSQL AlwaysOn Listener State - Below are the possible values: 0 : OFFLINE 1 : ONLINE 2 : ONLINE_PENDING 3 : FAILED.Note: Applicable for only `AvailabilityGroup` cluster. | ||
| mssql_node_sqlinstance_ServerUptime | MSSQL Node SQL Instance Server Uptime | Days | 3.0.0 | Monitors the uptime (in days) of the database server | |
| mssql_node_sqlinstance_DbInstanceCpuUtilization | MSSQL Node SQL Instance DB Instance CPU Utilization | % | 3.0.0 | Monitors MSSQL Database Instance CPU Utilization in percentage | |
| mssql_node_sqlinstance_DaysSinceLastLogBackup | MSSQL Node SQL Instance Days since Last Log Backup | Days | 5.0.0 | MSSQL DB Backup Days Since Last Log Backup | |
| mssql_node_sqlinstance_CpuIOBusy | MSSQL Node SQL Instance CPU IO Busy | microsec | 5.0.0 | MSSQL CPU IoBusy | |
| MSSQL Server Database | mssql_sqlserver_databaseStatus | MSSQL Sqlserver Database Status | 5.0.0 | 0 = ONLINE 1 = RESTORING 2 = RECOVERING SQL Server 2008 and later 3 = RECOVERY_PENDING SQL Server 2008 and later 4 = SUSPECT 5 = EMERGENCY SQL Server 2008 and later 6 = OFFLINE SQL Server 2008 and later 7 = COPYING Azure SQL Database Active Geo-Replication 10 = OFFLINE_SECONDARY Azure SQL Database Active Geo-Replication | |
| mssql_sqlserver_databaseFreeSpace | MSSQL Sqlserver Database Free Space | % | 5.0.0 | Monitors Database Freespace in Percentage | |
| mssql_sqlserver_databaseActiveUsers | MSSQL Sqlserver Database Active Users | count | 5.0.0 | Monitors the number of active user transactions per database | |
| mssql_sqlserver_databasepageReads | MSSQL Sqlserver Database Page Reads | rps | 5.0.0 | Number of physical database page reads issued | |
| mssql_sqlserver_databasepageWrites | MSSQL Sqlserver Database Page Writes | wps | 5.0.0 | Number of physical database page writes issued. |
| Native Type | Metric Name | Display Name | Units | Application Version | Description |
|---|---|---|---|---|---|
| MSSQL Windows Failover Cluster Node | mssql_cluster_node_system_memory_Utilization | MSSQL Windows Cluster Node System Memory Utilization | % | 1.0.1 | Physical and virtual memory usage in percentage. |
| mssql_cluster_node_sqlprocesses_cpuUsage | MSSQL Windows Cluster Node SQL processes CPU usage in Seconds | s | 1.0.1 | Monitors sql processes cpu usage in seconds | |
| mssql_cluster_node_system_cpu_Load | MSSQL Windows Cluster Node System CPU Load | 1.0.1 | Monitors the system's last 1min, 5min and 15min load. It sends per cpu core load average. | ||
| mssql_cluster_node_sqlprocesses_handles | MSSQL Windows Cluster Node SQL processes number of handles | count | 1.0.1 | Monitors sql processes handles count | |
| mssql_cluster_node_system_cpu_Utilization | MSSQL Windows Cluster Node System CPU Utilization | % | 1.0.1 | The percentage of elapsed time that the processor spends to execute a non-Idle thread(This doesn't includes CPU steal time) | |
| mssql_cluster_node_system_networkInterfaceInTraffic | MSSQL Windows Cluster Node System Network In Traffic | Kbps | 2.0.0 | Monitors In traffic of each interface for windows Devices | |
| mssql_cluster_node_system_cpu_IdleTime | MSSQL Windows Cluster Node System CPU IdleTime | % | 1.0.1 | Monitors cpu time in percentage spent in various program spaces. User - The processor time spent running user space processes System - The amount of time that the CPU spent running the kernel. IOWait - The time the CPU spends idle while waiting for an I/O operation to complete Idle - The time the processor spends idle Steal - The time virtual CPU has spent waiting for the hypervisor to service another virtual CPU running on a different virtual machine. Kernal Time Total Time | |
| mssql_cluster_node_system_memory_Usedspace | MSSQL Windows Cluster Node System Memory Used Space | GB | 1.0.1 | Physical and virtual memory usage in GB | |
| MSSQL Windows Failover Cluster Storage Disk | mssql_cluster_disk_FailoverStatus | MSSQL Windows System Disk Failover status | 1.0.1 | Whenever the owner node which is hosting storage disk, goes down any other node becomes owner node automatically. This metric explains whether the current node was the owner node, when the last failover happened. Possible instance values, 0-if there is no change in OwnerNode, 1-If there is a change in ownerNode, 2-If no OwnerNode | |
| mssql_cluster_disk_Freespace | MSSQL Windows System Disk FreeSpace | GB | 1.0.1 | Monitors the Free Space usage in GB | |
| mssql_cluster_disk_Utilization | MSSQL Windows System Disk Utilization | % | 1.0.1 | Monitors disk utilization in percentage | |
| MSSQL Server Instance | mssql_cluster_daysSinceLastDifferentialBackup | MSSQL Cluster Days since Last Differential Backup | Days | 1.0.1 | MSSQL DB Backup Days Since Last Differential Backup |
| mssql_cluster_cpuIOBusy | MSSQL Cluster CPU IO Busy | microsec | 1.0.1 | MSSQL CPU IoBusy | |
| mssql_cluster_alwaysOnListenerState | MSSQL Cluster AlwaysOn Listener State | 1.0.1 | MSSQL AlwaysOn Listener State - Below are the possible values: 0 : OFFLINE 1 : ONLINE 2 : ONLINE_PENDING 3 : FAILED | ||
| mssql_cluster_datafileSize | MSSQL Cluster Data File Size | KB | 1.0.1 | The cumulative size of all the data files in the database. | |
| mssql_cluster_instanceFreeConnections | MSSQL Cluster Instance Free Connections | % | 1.0.1 | Monitors MSSQL Database Instance Free Connections in percentage | |
| mssql_cluster_instance_RunningStatus | MSSQL Cluster Instance Running Status | 1.0.1 | Monitors MSSQL failover cluster instance running status. Possible values 0-OFFLINE, 1-ONLINE, 2-Initializing, 3-Failed, 4-Pending, 5-OnlinePending, 6-OfflinePending, 7-Unknown. | ||
| mssql_cluster_datafilesFreeSpace | MSSQL Cluster Data Files Free Space | % | 1.0.1 | Monitors datafiles free space regardless of auto-growth | |
| mssql_cluster_minsSinceLastLogFullBackup | MSSQL Cluster Mins since Last Log Full Backup | m | 1.0.1 | Monitors Database Backup status in Minutes since Last Full Backup | |
| mssql_cluster_daysSinceLastLogBackup | MSSQL Cluster Days since Last Log Backup | Days | 1.0.1 | MSSQL DB Backup Days Since Last Log Backup | |
| MSSQL Cluster Shared Volume | mssql_cluster_shared_volume_OperationalStatus | Mssql CSV Operational Status | 2.0.0 | Mssql cluster shared volume operational status. Possible values - Offline : 0,Failed : 1,Inherited : 2,Initializing : 3,Pending : 4,OnlinePending : 5,OfflinePending : 6,Unknown : 7,Online : 8, Degraded : 9, Lost Communication : 10, No Contact : 11, Not Available : 12 | |
| mssql_cluster_shared_volume_Utilization | Mssql CSV Utilization | % | 2.0.0 | Mssql cluster shared volume utilization in percentage | |
| mssql_cluster_shared_volume_Usage | Mssql CSV Usage | GB | Mssql cluster shared volume usage in GB | ||
| MSSQL Node | mssql_node_system_NetworkInterfaceOutTraffic | MSSQL Node System Network Out Traffic | Kbps | 3.0.0 | Monitors Out traffic of each interface for windows Devices |
| mssql_node_system_NetworkInterfaceInPackets | MSSQL Node System Network In packets | packets/sec | 3.0.0 | Monitors in Packets of each interface for windows Devices | |
| mssql_node_system_NetworkInterfaceInErrors | MSSQL Node System Network In Errors | Errors per Sec | 3.0.0 | Monitors network in errors of each interface for windows Devices | |
| mssql_node_SqlServicesState | MSSQL Node SQL services running state | 3.0.0 | Monitors sql services state. Possible values 0-Stopped,1-Running,2-StartPending, 3-StopPending, 4-ContinuePending, 5-PausePending, 6-Paused, 7-Unknown | ||
| mssql_node_system_NetworkInterfaceInTraffic | MSSQL Node System Network In Traffic | Kbps | 3.0.0 | Monitors In traffic of each interface for windows Devices | |
| mssql_node_diskdrive_FreeSpace | MSSQL Node Disk Drive FreeSpace | GB | 3.0.0 | Monitors the disk drive Free Space usage in GB | |
| mssql_node_system_CpuLoadAverage | MSSQL Node System CPU Load | 3.0.0 | Monitors the system's last 1min, 5min and 15min load. It sends per cpu core load average. | ||
| mssql_node_system_OsUptime | MSSQL Node System OS Uptime | m | 3.0.0 | Time lapsed since last reboot in minutes | |
| mssql_node_diskdrive_Utilization | MSSQL Node Disk Drive Utilization | % | 3.0.0 | Monitors disk drive utilization in percentage | |
| MSSQL Node Server Instance | mssql_node_sqlinstance_ServerIOBusy | MSSQL Node SQL Instance Server IO Busy | % | 3.0.0 | Monitors MSSQL DB Server IO Busy |
| mssql_node_sqlinstance_TotalServerMemory | MSSQL Node SQL Instance Total Server Memory | KB | 3.0.0 | Total amount of dynamic memory the server is currently consuming | |
| mssql_node_sqlinstance_DataFilesFreeSpace | MSSQL Node SQL Instance Data Files Free Space | % | 3.0.0 | Monitors datafiles free space regardless of auto-growth | |
| mssql_node_sqlinstance_CpuBusy | MSSQL Node SQL Instance CPU Busy | microsec | 3.0.0 | MSSQL CPU Busy | |
| mssql_node_sqlinstance_SqlCacheMemory | MSSQL Node SQL Instance Cache Memory | KB | 3.0.0 | Total amount of dynamic memory the server is using for the dynamic SQL cache | |
| mssql_node_sqlinstance_AvgLockWaitTime | MSSQL Node SQL Instance Average Lock Wait Time | ms | 3.0.0 | The average amount of wait time (milliseconds) for each lock request that resulted in a wait. | |
| mssql_node_sqlinstance_MinsSinceLastLogBackup | MSSQL Node SQL Instance Mins since Last Log Backup | m | 3.0.0 | Monitors Database transaction log backup in minutes | |
| mssql_node_sqlinstance_CpuIdle | MSSQL Node SQL Instance CPU Idle | microsec | 3.0.0 | MSSQL CPU IDLE | |
| mssql_node_sqlinstance_DataFileSize | MSSQL Node SQL Instance Data File Size | KB | The cumulative size of all the data files in the database. | ||
| mssql_node_sqlinstance_DaysSinceLastDifferentialBackup | MSSQL Node SQL Instance Days since Last Differential Backup | Days | 5.0.0 | MSSQL DB Backup Days Since Last Differential Backup | |
| MSSQL Server Database | mssql_sqlserver_dbLogfilesFreeSpace | MSSQL Sqlserver DB Logfiles Free Space | % | 5.0.0 | Monitors MSSQL database LogFiles free space |
| mssql_sqlserver_database_snapshotIsolationState | MSSQL Sqlserver Snapshot Isolation State | 5.0.0 | It monitor the MSSQL snapshot isolation state.Below are the possible states:OFF- 0, ON - 1 | ||
| mssql_sqlserver_dbLogCacheHitRatio | MSSQL Sqlserver DB Log Cache Hit Ratio | % | 5.0.0 | Monitors MSSQL database log cache-hit ratio | |
| mssql_sqlserver_databaseTransactions | MSSQL Sqlserver Database Transactions | psec | 5.0.0 | The number of transactions started for the database. | |
| mssql_sqlserver_logfileFreespaceWithAvailableDisk | MSSQL Sqlserver Logfile Free Space with Available Disk | % | 5.0.0 | Monitors MSSQL DB Logfile Freespace with Available Disk in percentage | |
| mssql_sqlserver_dbFileGroupFreespace | MSSQL Sqlserver DB File Group Free Space | % | 5.0.0 | Monitors MSSQL DB Filegroup Freespace |
Default Monitoring Configurations
mssql-cluster has default Global Device Management Policies, Global Templates, Global Monitors and Global metrics in OpsRamp. You can customize these default monitoring configurations as per your business use cases by cloning respective global templates and global Device Management Policies. OpsRamp recommends performing the below activity before installing the application to avoid noise alerts and data.
Default Global Device Management Policies
You can find the Device Management Policy for each Native Type at Setup > Resources > Device Management Policies. Search with suggested names in global scope:
{appName nativeType - version - MSSQL Type}Example: mssql-cluster MSSQL Windows Failover Cluster - 1 - CLUSTER (i.e, appName = mssql-cluster, nativeType =MSSQL Windows Failover Cluster, version = 1 , MSSQL Type = CLUSTER)
Default Global Templates
You can find the Global Templates for each Native Type at Setup > Monitoring > Templates. Search with suggested names in global scope. Each template adheres to the following naming convention:
{appName MSSQL Type nativeType 'Template' - version}Example: mssql-cluster CLUSTER MSSQL Windows Failover Cluster Template - 1 (i.e, appName = mssql-cluster ,MSSQL Type=CLUSTER, nativeType = MSSQL Windows Failover Cluster, version = 1)
Default Global Monitors
You can find the Global Monitors for each Native Type at Setup > Monitoring > Monitors. Search with suggested names in global scope. Each Monitors adheres to the following naming convention:
{monitorKey appName nativeType - version}Example: MSSQL Windows Failover Cluster Monitor mssql-cluster MSSQL Windows Failover Cluster 1 (i.e, monitorKey = MSSQL Windows Failover Cluster Monitor, appName = mssql-cluster , nativeType = MSSQL Windows Failover Cluster , version= 1)