To enhance performance in BMC Helix Dashboards, follow these best practices:
1. Optimize Data Queries
- Use filters and variables to narrow data scope.
- Avoid retrieving all records; apply time filters, drop-downs, or query variables.
2. Limit Query Result Size
- Use the LIMIT clause to retrieve only the required number of records.
3. Minimize Panels per Dashboard
- Each panel triggers at least one backend query.
- Limit dashboards to 10–15 panels for optimal performance.
4. Adjust Time Range Selectors
- Use shorter default time ranges (e.g., “last 7 days” instead of “last 30 days”) when appropriate.
5. Control Auto-Refresh Intervals
- Set refresh intervals to 1 minute or longer unless real-time data is necessary.
6. Simplify Calculated Fields
- Reduce the use of complex expressions within panels.
7. Analyze Slow-Loading Panels
- Review queries for optimization opportunities, such as removing unnecessary joins or adding filters.
- Consider dashboard-level adjustments, especially when using variables with multiple values.
- For more details, refer to article ID: 000408579.
8. Understand the Impact of Row-Level Security (RLS)
- RLS affects data access and query behavior for non-admin users, influencing performance.
9. Collect Logs for Analysis
- Use non-admin AR System accounts to replicate the issue, and an Admin AR System account to enable API and SQL logs to identify queries with performance issues.
- Once the SQL that goes to the AR System DB it captured in the logs, it can be provided to a DBA for analysis to review if any improvement at DB level like adding index can be applied.
- Follow the next steps to enable combined API/SQL logs:
9.1 Log in to MidTier with an Admin AR System account.
9.2 Follow the article 000436420 to enable combined API/SQL logs from:
Applications > Remedy Management Console > AR System Server Group Console >Logs > Logs Management
9.3 In another browser, log in to BMC Helix Dashboards with a non-admin AR System account.
9.4 Replicate the behavior by opening a dashboard with a slow performance when loading data.
9.5 With the Admin AR System account, collect the API/SQL logs from:
Applications > Remedy Management Console > AR System Server Group Console >Logs > View Logs
For additional guidance, visit the BEST FAQ on Using Helix Dashboards article