Dimensions in the Data Workbench Historic profile

Last update: 2022-10-04
  • Created for:
  • User
    Admin
IMPORTANT

Read more about Data Workbench’s End-of-life announcement.

The following dimensions are available for use in the data workbench Historic profile.

Dimensions in the Data Workbench Historic profile

The following dimensions are available for use in the data workbench Historic profile.

Block This is the only countable in this configuration, it is the root for all dimensions. A block can be considered a server. It is using the x-trackingid field.

Note: The block ID is a hash of the server name plus host name, so there will be approximately one block per server per profile.

Ping This is a countable dimension built off of the Block countable. Each row of data in the profile is a ping from the monitoring agent.
Alert Critical Numeric Dimension built from the cs-uri-query(ad) value. It is built at the Ping level conditioned that cs-uri-query(a) matches "1".
Alert Down Numeric Dimension built from cs-uri-query(ac) value. It is built at the Ping level, conditioned that cs-uri-query(a) matches "1".
Alert Warning Numeric Dimension built from cs-uri-query(ae) value. It is built at the Ping level conditioned that cs-uri-query(a) matches "1".
Any Profile Reprocessing Numeric Dimension built from cs-uri-query(aa) value. It is built at the Ping level conditioned that cs-uri-query(a) matches "1" and cs-uriquery(k) is not empty.
As of Delay Minutes cs-uri-query(bi) is placed into the x-as-of-delay-minutes field and rounded to the nearest minute. It is built at the Ping level conditioned that cs-uri-query(a) matches "1".
Capacity Row Percentage Numeric Dimension built from cs-uri-query(r) value. It is built at the Ping level conditioned that cs-uri-query(a) matches "1" and cs-uriquery(k) is not empty.
Capacity Size Percentage Numeric Dimension built from cs-uri-query(n) value. It is built at the Ping level conditioned that cs-uri-query(a) matches "1" and cs-uriquery(k) is not empty.
Component Check Success Simple Dimension built from cs-uri-query(v) value. It is built at the Ping level, and conditioned that cs-uri-query(a) matches "1".
Components in Error cs-uri-query(ao) is split by the "|" delimiter and copied into the x-components-in-error field. Many to Many Dimension built from the x-components-in-error field. Built at the Ping level.
Detailed Check Seconds Numeric Dimension built from cs-uri-query(l) value. It is built at the Ping level conditioned that cs-uri-query(k) is not empty.
Detailed Check Success Simple Dimension built from the cs-uri-query(k) value. It is built at the Ping level conditioned that cs-uri-query(a) matches "1".
Dimension GigaBytes cs-uri-query(bc) is copied into the x-dimension-gigabytes field. The x-dimension-gigabytes field is user for this Simple Dimension, conditioned on cs-uri-query(a) matching "2".
Disk "x" Used Percentage These Numeric Dimensions are configured from the cs-uri-query(ah, ai, aj, ak, al) values. They are built at the Ping level and conditioned on cs-uri-query(a) matches "1" and cs-uri-query(k) is not empty.
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.

Fast Input MegaBytes per Minute The cs-uri-query(bj) value is used for this dimension. The Last Row for a block is used as the value for the dimension. If the dataset is in Fast Input this Numeric Dimension's value will display the MB per minute at which the system is inputting data.

Note: This dimension is hidden because it is only useful when averaged into a metric.

Fast Merge MegaBytes per Minute The cs-uri-query(bk) value is used for this dimension. The Last Row for a Block is used as the value for the dimension. If the dataset is in Fast Merge This Numeric Dimension's value will display the MB per minute at which the system is merging.

Note: This dimension is hidden because it is only useful when averaged into a metric.

Field GigaBytes The cs-uri-query(bg) value is used for this dimension. The value is divided by 1000 and rounded to the nearest whole number. This Numeric Dimension's value will display the amount of space the Fields in the dataset are using.

Note: This dimension is hidden because it is only useful when averaged into a metric.

Group Simple Dimension built at the Ping level from the cs-uri-query(x) value.
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 the x-unixtime field is copied into x-last-ping and divided by 10 to reduce the cardinality. The Numeric Dimension is built at the Block level and uses the x-last-ping field.
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.

Log Reading Percentage the cs-uri-query(be) value is used for this numeric dimension, built at the Ping level. This dimension is used to calculate the percentage of logs being read.

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 cs-uri-query(o) value, built at the Ping level. It is conditioned on cs-uri-query(k) not being empty, and cs-uri-query(a) matching "1". 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 cs-uri-query(ag) value, built at the Ping level. It is conditioned on cs-uri-query(k) not being empty, and cs-uri-query(a) matching "1.

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 cs-uri-query(ag) value, built at the Ping level. It is conditioned on cs-uri-query(k) not being empty, and cs-uri-query(a) matching "1. 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 cs-uri-query(s) value at the Ping level. It is conditioned on cs-uri-query(k) not being empty and cs-uri-query(a) matching "1. 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 cs-uri-query(q) value built at the Ping level. It is conditioned on cs-uri-query(k) not being empty and cs-uri-query(a) matching "1. 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.

Output Rows cs-uri-query(bh) value is divided by 100000 and copied into the x-output-rows field to reduce the size of the dimension. X-output-rows is used in a Numeric Dimension built at the Ping level, conditioned that cs-uri-query(a) matches "2".
Ping Type ID Simple Dimension built using the cs-uri-query(a) value at the Ping level. This shows what kind of Ping was recorded.
Poll Latency Centiseconds 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 built at the Ping level, conditioned that cs-uri-query(k) is not empty, and cs-uri-query(a) matches "1"/ This dimension is used to calculate the poll latency.

Note: This dimension is hidden because it is only useful when averaged into a metric.

Processing Mode ID The cs-uri-query(bb) value is used for this Simple Dimension, built at the Ping level. It is conditioned that cs-uri-query(bb) is not empty, and that cs-uri-query(a) matches "2" Processing Mode ID allows one to see what mode of processing the system is in (Fast Input, Fast Merge, Real Time).

Note: This dimension is hidden then re-exposed with friendly values in the client-side dimension Processing Mode.

Profile The cs-uri-query(ba) value is used for this Simple Dimension, it is built at the Ping level. This dimension displays the name(s) of the profile(s) currently being monitored.
Quick Check Seconds The cs-uri-query(h) value is used for this Numeric Dimension. It is built at the Ping level conditioned that cs-uri-query(a) matches "1".
Quick Check Success This is a Simple dimension built from the cs-uri-query(g) value built at the Ping level. It is used to calculate the quick check metric.
Real Time Processing Percentage Numeric Dimension using the cs-uri-query(t) value built at the Ping level. It is conditioned that cs-uri-query(a) matches "1".
Source Furthest Behind Simple Dimension built from the cs-uri-query(bl) value built at the Ping level. This dimension displays the when the last contact with a data source occurred.
Temp DB Space Percentage Numeric Dimension built using the cs-uri-query(an) value, built at the Ping level. It is conditioned that cs-uri-query(k) is not empty, and cs-uri-query(a) matches "1". It 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.

Transformation Percentage the cs-uri-query(bf) value is used for this numeric dimension. It is built at the Ping level. This dimension is used to calculate the percentage of complete data transformation.

Note: This dimension is hidden because it is only useful when averaged into a metric.

Data Workbench Version The cs-uri-query(ab) value is used for this Simple Dimension. It is built at the Ping level and conditioned that cs-uri-query(ab) is not empty, and cs-uri-query(a) matches "1". This displays the version(s) of data workbench server running on each server.
Data Workbench Version Major The cs-uri-query(ab) value is split and the major release value is copied into the x-insight-version-major field. It is a Simple Dimension built at the Ping level and conditioned that x-insight-version-major is not empty, and cs-uri-query(a) matches "1".
Previous page
Next page

On this page