Bold BI Insights: Tools for Monitoring and Improving Dashboard Performance and Query Execution

Published:

Monitoring the performance and query execution time of dashboards is essential for ensuring optimal user experience and efficient data retrieval. There are built-in dashboards included with Bold BI in the usage analytics category for this purpose. You can choose to show or hide the usage analytics category on the dashboard listing page by selecting the Usage analytics option in the dashboard settings page.

NOTE: The Usage Analytics option is available only to admin users, and usage analytics dashboards are read-only.

Performance Monitoring Dashboard

The performance monitoring dashboard is predefined and allows you to monitor the performance of each dashboard in order to better understand which dashboard is affecting performance.

Performance Monitoring Dashboard Widgets Details

Widgets	Description
Filter Date	Filter the data by start date.
User	Filter the data based on user.
Query Execution Place	Filter data based on query execution place.
Query Status	Filter Data based on successful or failed query request.
Tenant	Filter data based on tenant.
Dashboard	Filter data based on dashboard.
Widget	Filter data based on widget.
Data Source	Filter data based on Datasource.
Slow Dashboard Based on Average Time	Shows which dashboard ran slow with Query execution time.
Slow Widget based on Average Time	Shows which widget ran slow with Query execution time.
Slow Data Source Based on Average Time	Shows which data source ran slow with Query execution time.

Query Performance Tracking

The Query Performance Tracking is predefined and enables you to monitor the performance of each query to better understand which query impacts performance.

Query Performance Tracking Widgets Details

Widgets	Description
Start Date	Filter the data by start date.
Tenant	Filter the data based on tenant.
Detailed Query Information	Tracking ID represents each instance of Dashboard / Widgets being rendered/invoked at a time. Provides information about Dashboard name, widget name, Datasource name, query start and end time, Query execution time, Query status, and Query type (Widget/Dashboard).
Executed Query by Tracking ID	Tracking ID represents each instance of Dashboard / Widgets being rendered/invoked at a time. Provides executed query by tracking ID.