MicroStrategy ONE
Server Processing Time Metric Names
Many metric subscription metric names are the same for Enterprise Manager and Platform Analytics; however, there are slight changes between the two.
| Enterprise Manager Metric Name | Platform Analytics Metric Name | Description |
|---|---|---|
| Successful Jobs < 1 min | Successful Jobs <1 min | Report jobs with execution time less than 1 minute. |
| Successful Jobs > 5 min | Successful Jobs > 5 min | Report jobs with execution time greater than 5 minutes. |
| Successful Jobs 1-5 min | Successful Jobs 1-5 min | Report jobs with execution time between 1 and 5 minutes. |
| Avg. CPU Duration per Job (secs) | Avg Job CPU Duration (s) | Average CPU time taken by the Intelligence server for processing a job. |
| RP Last Execution Request Timestamp | Last Job Request Timestamp (UTC) | Provides the request timestamp of the last job request. |
|
RP Max. Elapsed Duration per Job (hh:mm:ss) |
Max Job Elapsed Duration (s) |
Provides the maximum report duration per report job. |
| RP Max. Execution Duration per Job (hh:mm:ss) | Max Job Execution Duration (s) | Provides the maximum job execution duration per report job. |
|
RP Max. Queue Duration per Job (hh:mm:ss) |
Max Job Queue Duration (s) |
Provides the maximum queue duration per report job. |
| DP CPU Duration (secs) | Sum Job CPU Duration (s) | Total CPU time taken by the Intelligence server for processing a job. |
|
RP CPU Duration (msec) |
Sum Job CPU Duration (s) |
Total CPU time taken by the Intelligence server to process a job. |
| RP Average CPU Duration per Job (msecs) | Avg Job CPU Duration (s) | Average CPU time taken by the Intelligence server to process a job. |
|
RP Average Elapsed Duration per Job (secs) |
Avg Job Elapsed Duration (s) |
Average time taken by the Intelligence Server to process a job. This includes the amount of time the job was in the Intelligence Server queue and the amount of time taken by the Intelligence Server to execute a job. |
| RP Execution Duration (secs) | Max Job Execution Duration (s) | Total time taken by the Intelligence Server to execute the job, including the database execution time. |
|
RP Elapsed Duration (secs) |
Max Job Elapsed Duration (s) |
Total time taken by the Intelligence Server to process a job. This includes the amount of time a job was in the Intelligence Server queue and the amount of time taken by the Intelligence Server to execute a job. |
| RP Average Prompt Answer Time per Job (secs) | Avg Job Prompt Answer Duration (s) | Average time taken to answer the set of prompts for a job. For example, Prompt Answer Time. |
|
RP Prompt Answer Duration (secs) |
Sum Job Prompt Answer Duration (s) |
Total time taken to answer the set of prompts for a job. For example, Prompt Answer Time. |
| RP Average Queue Duration per Job (secs) | Avg Job Total Queue Duration (s) | Average time a job was in the Intelligence Server queue before the Intelligence Server started processing it. |
|
RP Queue Duration (secs) |
Max Job Total Queue Duration (s) |
Total time a job was in the Intelligence Server queue before the Intelligence Server started processing it. |
| RP Average Execution Duration per Job (secs) | Avg Job Execution Duration (s) | Average time taken by the Intelligence Server to execute a job, including the database execution time. |
| RP Data Request Error Elapsed Duration hh:mm:ss | Sum Data Request Error Elapsed Duration (s) | Measures the sum time taken by the Intelligence Server to process failed jobs. The jobs must be triggered manually. |
| RP Timed out jobs | Timeout Jobs | Counts the number of jobs that were timed out by the Intelligence server. |
| RP SQL Size | SQL Size | Measures SQL size in number of characters submitted by the Intelligence server to the database. |
| RP Session Count | Dashboard Job Sessions | Counts the number of distinct user sessions that executed dashboard jobs. |
| Documents Job Sessions | Counts the number of distinct user sessions that executed document jobs. | |
| Report Job Sessions | Counts the number of distinct user sessions that executed report jobs. | |
| RP Queue Duration (hh:mm:ss) | Sum Job Total Queue Duration (s) | Provides the overall Total Queue Duration (in seconds) of jobs. A jobs Total Queue Duration records the total time spent waiting in queue for the job to be executed, including initial queue time and the queue time between different steps. |
| RP Prompt Answer Duration (hh:mm:ss) | Sum Job Prompt Answer Duration (s) | Provides the total Prompt Answer Duration (in seconds) of jobs. A jobs Prompt Answer Duration records the total time spent answering a prompt during a job. |
| RP Execution Duration (secs) | Max Job Execution Duration (s) | Provides the max Execution Duration (in seconds) of jobs. A jobs Execution Duration records the total time spent during a job. |
| RP Execution Duration for SQL Executing Reports (hh:mm:ss) | Sum Database Job Execution Duration (s) | Measures total time taken by a job that does not hit a Cache/Intelligence Cube and runs against the database i.e. jobs that execute SQL. |
| RP Execution Duration (hh:mm:ss) | Sum Job Execution Duration (s) | Provides the total Execution Duration (in seconds) of jobs. A jobs Execution Duration records the total time spent during a job. |
| RP Elapsed Duration (secs) | Max Job Elapsed Duration (s) | Provides the max Elapsed Duration (in seconds) of jobs. A jobs Elapsed Duration records the total time spent during an execution including the total queue time. |
| RP Elapsed Duration (hh:mm:ss) | Sum Job Elapsed Duration (s) | Provides the total Elapsed Duration (in seconds) of jobs. A jobs Elapsed Duration records the total time spent during an execution including the total queue time. |
| RP Data Request Queue Duration hh:mm:ss | Sum Data Request Queue Duration (s) | Provides queue duration during a report, document, or dashboard job execution. |
| RP Data Request Prompt Answer Time hh:mm:ss | Sum Data Request Prompt Answer Time (s) | Provides the duration of time for answering the set of prompts in a report, document, or dashboard job. |
| RP Data Request Exec Duration hh:mm:ss | Sum Data Request Execution Duration (s) | Measures the sum time taken by the Intelligence server to execute jobs. The jobs must be manually triggered. |
| RP Data Request Elapsed Duration hh:mm:ss | Sum Data Request Elapsed Duration (s) | Measures the sum time taken by the Intelligence server to process jobs. The jobs must be manually triggered. |
| RP CPU Duration (msec) | Sum Job CPU Duration (s) | Provides the total CPU duration (in seconds) of jobs. A jobs CPU Duration calculates the time spent on CPU during the job execution. |
| RP Average View Report Result Rows | Average View Report Result Rows | Counts the average number of rows displayed for an Intelligent Cube view report. |
| RP Average Queue Duration per Job (hh:mm:ss) | Avg Job Total Queue Duration (s) | Provides the average Total Queue Duration (in seconds) of jobs. A jobs Total Queue Duration records the total time spent waiting in queue for the job to be executed, including initial queue time and the queue time between different steps. |
| RP Average Queue Duration per Data Request Job seconds | Average Queue Duration per Data Request Job (s) | Measures the average time a job waits in queue. This job must be triggered. |
| RP Average Prompt Answer Time per Job (hh:mm:ss) | Avg Job Prompt Answer Duration (s) | Provides the average Prompt Answer Duration (in seconds) of jobs. A jobs Prompt Answer Duration records the total time spent answering a prompt during a job. |
| RP Average Prompt Answer Duration per Data Request Job seconds | Average Prompt Answer Duration per Data Request Job (s) | Measures the average time taken by the Intelligence server to process a prompt answer. This job must be triggered. |
| RP Average Execution Duration per Job (hh:mm:ss) | Avg Job Execution Duration (s) | Provides the average Execution Duration (in seconds) of jobs. A jobs Execution Duration records the total time spent during a job. |
| RP Average Execution Duration per Data Request Job seconds | Average Execution Duration per Data Request Job (s) | Measures the average time taken by the Intelligence server to execute the failed job. This job must be triggered. |
| RP Average Elapsed Duration per Job (hh:mm:ss) | Avg Job Elapsed Duration (s) | Provides the average Elapsed Duration (in seconds) of jobs. A jobs Elapsed Duration records the total time spent during an execution including the total queue time. |
| RP Average Elapsed Duration per Data Request Job seconds | Average Elapsed Duration per Data Request Job (s) | Measures the average time taken by the Intelligence server to process the job. This job must be triggered. |
| RP Average Elapsed Duration per Data Request Error Job seconds | Average Elapsed Duration per Data Request Error Job (s) | Measures the average time taken by the Intelligence server to process the failed job. The job must be manually triggered. |