Microsoft SQL Server Database

There are no Microsoft SQL Server specific configuration metrics supported. All configuration metrics are inherited from parent entities as listed below.

Table 1-261 Supported Configuration Metrics for Relational Database

Metric Group Name Unit Description
Creation Date Creation Date N/A Date when the database was created
Total Memory Capacity Host Memory GB Total host memory capacity in GB
Resource Allocation Instance Name N/A RDB Instance
Resource Allocation Host Name N/A Host name of the instance
Resource Allocation Total CPUs N/A total number of CPUs allocated or available in this instance
Resource Allocation Total Memory GB Total amount of usable Physical RAM allocated or available to this instance.
Lookup Config Metrics Value NA Value

Table 1-262 Supported Configuration Metrics for Hosted Target

Metric Group Name Unit Description
Resource Allocation Total CPUs N/A Total number of CPUs allocated or available to the entity
Resource Allocation Total Memory GB Total amount of usable Physical RAM allocated or available to the entity

Table 1-263 Supported Status and Performance Metrics for Microsoft SQL Server Database

Metric Group Category Name Unit Description
Throughput Load Transactions Per Second txns/sec Number of transactions per second
Throughput N/A Logins Per Seconds logons/sec Number of logins per second
Throughput N/A Current Logons Count N/A Count of current logons
Throughput N/A Executions Per Seconds executions/sec Number of executions per second
Top Wait Events Load Wait event name N/A Wait event time
Top Wait Events N/A Total wait time sec Total wait time
Top Wait Events N/A Total wait count N/A Total wait count
Top Wait Events N/A Average wait time sec Average wait time
Cluster Nodes Response SQL Server Cluster Node Name N/A Name of the cluster node
Cluster Nodes N/A SQL Server Cluster Node Status N/A Status of the cluster node

Table 1-264 Supported Status and Performance Metrics for Hosted Target

Metric Group Category Name Unit Description
CPU Utilization CPU Usage sec All CPUs usage during the interval
CPU N/A CPU Utilization % Percentage of CPU that was utilized
CPU N/A Interval sec Interval of metric collection
Memory Load Memory Usage GB Memory used in GB
Memory Utilization Memory Utilization % Percentage of memory that is utilized
Memory N/A Interval sec Interval of metric collection

Table 1-265 Status and Performance Metrics for Generic Target

Metric Group Category Name Unit Description
Response Availability Status N/A Status of the target