The Overview view displays detailed information about key metrics for the selected session. The metric values provide a view of the query status on the system.
Query Information
| Query Information |
Description |
|---|
| Process ID |
Process identifier |
| State |
Process state, such as active, canceled, pending |
| In State |
How long the process has been in the current state |
| Start |
Time the process started running |
Workload Information
| Workload Information |
Description |
|---|
| Workload Policy |
Name of the workload policy used to manage the process. Defines a set of related queries, and allows them to be prioritized in a similar manner. |
| Service Class |
Name of the service class used by the workload policy. Specifies the share of system resources allocated to a workload as a function of the class's priority and weight values. |
| Priority |
Indicates the importance of the process.
|
| Weight |
Number ranging from 1 to 100 that indicates the precedence of the process within the priority level, increasing the resources that can be allocated for the process. A higher value indicates a greater level of precedence. |
Session Information
| Session Information |
Description |
|---|
| User |
Name of user that submitted the query |
| Database |
Name of the database on which the process ran |
| IP Address |
IP address of the user that submitted the process |