How to improve BMC Helix Dashboards performance?

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