Attributes for SQL Monitors
The trace (root span) and span attributes in Trace Explorer are defined by tagging a span, which enable the effective monitoring of the various tiers of an application.
Attributes are key-value pairs attached to a span to provide additional information and context about the operation performed in the span. A trace has some trace only attributes as well as all the span attributes of the root span.
In Trace Explorer, you can use attributes to query and filter traces and spans. There are two types of attributes: Dimensions (string attributes) and Metrics (numeric attributes) which are available in the Attributes panel in Trace Explorer.
This section provides a complete list of the out-of-the-box attributes applicable to SQL monitors from Availability Monitoring. The below table includes:
- Name: Name of the attribute.
- Description: Brief description of the attribute.
- Trace/Span: Availability of the attribute. An attribute can be available for traces, spans, or both.
- Type: Type of attribute: Dimension or Metric.
| Name | Description | Trace/Span | Type |
|---|---|---|---|
CloseTime |
The time taken to close the Database connection. | Span attribute | Metric |
CloudWalletExpiry |
The days remaining from the current day for the expiry of cloud wallet. | Span attribute | Metric |
ConnectTime |
The time taken to create Database connection. | Span attribute | Metric |
ExecutionTime |
The time taken to execute the SQL query. | Span attribute | Metric |
FetchedRowCount |
The total number of rows fetched. | Span attribute | Metric |
PrepareTime |
The time taken to create the PreparedStatement object containing the pre-compiled SQL statement. | Span attribute | Metric |
SqlState |
The SQLSTATE is a database state function that returns a 5 character data type of CHARACTER with a default value of '00000'. | Span attribute | Dimension |