Read more about Data Workbench’s End-of-life announcement.
The following dimensions are available for use in the data workbench Server Status profile.
Server | Built from the x-trackingid field, this countable dimension represents the Servers currently running data workbench. |
Agent Version | The cs-uri-query(af) value is used for this Simple Dimension. It is the Last Nonblank value for a Server. This displays the build date and time for the version(s) of the monitoring agent running. |
Any Profile Reprocessing | The cs-uri-query(aa) field is used for this Numeric Dimension, it is the value of the Last Row for a given Server, conditional on cs-uri-query(k) is not empty. This dimension is used to indicate if any profiles are Reprocessing. |
Capacity Row Percentage | The cs-uri-query(r) field is used for this Numeric Dimension, it is the value of the Last Row for a given Server, conditional on cs-uri-query(k) is not empty. |
Capacity Size Percentage | The cs-uri-query(n) field is used for this Numeric Dimension, it is the value of the Last Row for a given Server, conditional on cs-uri-query(k) is not empty. |
Common Name | The sc-ur-query(am) field is used for this Simple Dimension, it is the value of the Last Nonblank value for a given Server. It displays the Common Name of the servers being monitored. |
Component Check Success | The cs-uri-query(v) field is used for this Simple Dimension, it is the value of the Last Row for a given Server. This dimension checks on the components of the server to verify they are properly functioning. |
Components in Error | A Crossrows transformation takes the Last Row value of the cs-uri-query(ao) and copies it into the x-components-in-error field. This Many to Many dimension displays any components in error on servers being monitored. |
Environment | The cs-uri-query(c) value is used for the Environment ID. The Last Row for a Block is used as the value for the dimension. This Simple Dimension will display the Environment in which your Servers are running (provided it is configured properly). Note: This dimension is set in insight_monitor_agent.cfg. |
Estimated Sweep Dekaseconds | The x-estimated-sweep-dekaseconds field is used in this Numeric Dimension. This is the estimated sweep time of the servers divided by ten (reduced resolution of sweep measurement to make dimension more reasonably sized). Note: This dimension is hidden because it is only useful when averaged into a metric. |
Host | The cs-uri-query(b) value is used for this dimension. The Simple dimension's value is the Last Row for a Block. |
Last Ping | x-last-ping is x-unixtime divide by 10 (to accommodate Numeric dimensions size constraints). Last Ping is the Last Row for a given Block, and it represents the last time the monitoring agent logged the system health. |
Load Average | This is a Numeric dimension using the Last Row for a given Server's cs-uri-query(i) value. It is conditioned on cs-uri-query(k) not being empty. This dimension is used to calculate the average load on the servers in the system being monitored. Note: This dimension is hidden because it is only useful when averaged into a metric. |
Memory Page File Percentage | This is a Numeric dimension using the Last Row for a given Server's cs-uri-query(o) value. It is conditioned on cs-uri-query(k) not being empty. This dimension is used to calculate the percent of page file memory usage. Note: This dimension is hidden because it is only useful when averaged into a metric. |
Memory Physical MegaBytes Total | This is a Numeric dimension using the Last Row for a given Server's cs-uri-query(ag) value. It is conditioned on cs-uri-query(k) not being empty. Note: This dimension is hidden because it is only useful when averaged into a metric. |
Memory Physical Percentage | This is a Numeric dimension using the Last Row for a given Server's cs-uri-query(ag) value. It is conditioned on cs-uri-query(k) not being empty. This dimension is used to calculate the percent of physical memory usage of each Server. Note: This dimension is hidden because it is only useful when averaged into a metric. |
Memory Query Percentage | This is a Numeric dimension using the Last Row for a given Server's cs-uri-query(s) value. It is conditioned on cs-uri-query(k) not being empty. This dimension is used to calculate the percent of query memory usage of each Server. Note: This dimension is hidden because it is only useful when averaged into a metric. |
Network Connections | This is a Numeric dimension using the Last Row for a given Server's cs-uri-query(q) value. It is conditioned on cs-uri-query(k) not being empty. This is used to show the number of network connections there are for a given server. Note: This dimension is hidden because it is only useful when averaged into a metric. |
Poll Latency Centiseconds | This dimension is used to calculate the poll latency. The cs-uri-query(m) value is divided by 10 to reduce dimension size, and copied into the x-poll-latency-centiseconds field. This is a Numeric dimension which takes the Last Row for a given server. Note: This dimension is hidden because it is only useful when averaged into a metric. |
Quick Check Success | This is a Simple dimension built from the cs-uri-query(g) value of the Last Row for a given Server. It is used to calculate the quick check metric. |
Temp DB Space Percentage | The last row of the cs-uri-query(an) value is copied into the x-temp-db-space-percentage field. This is a Numeric Dimension that is used to calculate the percentage of used Temp DB space on a given server. Note: This dimension is hidden because it is only useful when averaged into a metric. |
Insight Version | The cs-uri-query(ab) value is used for this Simple Dimension. It is the Last Nonblank value for a Server. This displays the version(s) of data workbench server running on each server. |
Group | Grouping word that gives you another way to filter the resulting dataset. Note: This dimension is set in insight_monitor_agent.cfg. |
Metrics | The following lists the metrics included in the data workbench Profile Monitoring Profile and how they are derived. |
Capacity Overall | This is the Capacity Size metric times two plus the Capacity Row metric divided by 3. |
Capacity Row | This is the sum of the Capacity Row Percentage for each Server divided by Servers metric. |
Capacity Size | This is the sum of the Capacity Size Percentage for each Server divided by the Servers metric. |
Component Check | This is the number of Servers where Component Check Success equals one, divided by the Server where Service is DPU or FSU, all multiplied by 100 (to make it a percentage). |
Disk "x" | The Disk metrics are calculated by taking the sum of their Disk Used Percentage for each Server, divided by the Servers metric. |
Estimated Sweep Minutes | This is the sum of the Estimated Sweep Dekaseconds for each Server, divided by the Servers metric where Estimated Sweep Dekaseconds is greater than zero, all divided by 6. |
Last Ping Time | The sum of Last Ping for each Block divided by Blocks, then multiplied by 10. |
Load | This is the sum of the Load Average for each Server, divided by the Servers metric. |
Memory Page File | This is the sum of the Memory Page File Percentage for each Server, divided by the Servers metric. |
Memory Physical | This is the sum of the Memory Physical Percentage for each Server, divided by the Servers metric. |
Memory Query | This is the sum of the Memory Query Percentage for each Server, divided by the Servers metric. |
Network Connections | This is the sum of the Network Connections for each Server divided by the Servers metric. |
Poll Latency Milliseconds | This is the sum of the Poll Latency Centiseconds for each Server, divided by the Servers metric, all of which is multiplied by 10. |
Quick Check | This is the number of Servers where Quick Check Success equals one, divided by the Servers metric, all of which is multiplied by 100. |
Servers | This is the sum of one for each Server, or the total number of monitored Servers. |
Temp DB | This is the sum of the Temp DB Space Percentage for each Server, divided by the Servers metric. |