Top servers
The Top Servers dashboard provides a summary of activity and performance metrics for the given time frame and filter set. It also provides a bubble chart comparing three key metrics for your top servers together with a corresponding data grid. You can customize the bubble chart by selecting the number of servers to view and the three metrics to plot, including the Rank By metric, the X-Axis metric and the Y-Axis metric. The Rank By selection in the bubble chart will also control the sorting of the data in the grid below. You can also choose whether to rank the bubble chart data in Ascending or Descending order. The grid can be further customized as described in Customizing task columns.
For the specified filters, the Top Servers dashboard displays the following key metrics:
Server utilization
The Server Utilization section contains the following metrics:
- Average Memory - The average memory consumed by all tasks on a server.
- Average Disk Utilization - The average memory consumed by all tasks on a server.
- Average Qlik CPU - The average Qlik CPU (as a percentage) for each server.
- Average Machine CPU - The average machine CPU (as a percentage) for each server.
- Average Task CPU - The average CPU per task (as a percentage of server CPU) for each server.
Full load
The Full Load section contains the following metrics:
- Total Tables: The total number of tables for all tasks on a server.
- Total Records: The total number of records for all tasks on a server.
- Max Load Duration: The longest duration of the load process (in seconds).
- Average Load Duration: The average duration of the load process for all completed tasks on a server (in seconds).
- Average Source Throughput (rec/sec): The average source throughput (in rec/sec) per task.
- Average Source Throughput (kb/sec): The average source throughput (in kb/sec) per task.
- Average Target Throughput (rec/sec): The average target throughput (in rec/sec) per task.
- Average Target Throughput (kb/sec): The average target throughput (in kb/sec) per task.
Change processing
The Change Processing section contains the following metrics:
- Total Applied Changes: The total number of applied changes for all tasks on a server.
- Total INSERTs: The total number of INSERTs applied.
- Total UPDATEs: The total number of UPDATEs applied.
- Total DELETEs: The total number of DELETEs applied.
- Total DDLs: The total number of DDLs applied.
- Total COMMIT Change Volume: The total COMMIT change volume for all tasks on a server.
- Total COMMIT Change Records: The total number of COMMIT change records for all tasks on a server.
- Total Applied Transactions: The total number of COMMIT transactions for all tasks on a server.
- Average Changes in Memory (Source): The average number of changes accumulated in memory until source commit per task.
- Average Changes on Disk (Source): The average number of changes accumulated on disk until source commit per task.
- Average Changes for Apply in Memory (Target): The average number of changes in memory during apply and until target commit per task.
- Average Changes for Apply on Disk (Target): The average number of changes on disk during apply and until target commit per task.
- Average Source Throughput (rec/sec): The average source throughput (in rec/sec) per task.
- Average Source Throughput (kb/sec): The average source throughput (in kb/sec) per task.
- Average Target Throughput (rec/sec): The average target throughput (in rec/sec) per task.
- Average Target Throughput (kb/sec): The average target throughput (in kb/sec) per task.
- Average Apply Latency (secs): The average apply latency (in seconds) per task.
- Average Source Latency (secs): The average source latency (in seconds) per task.