A Performance tile shows the following error instead of data:
timeout-command: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The Performance tile accesses data from the Data Warehouse directly using the published schema.
The SQL timeout is 30 seconds by default and it is not configurable.
It is not configurable for two reasons:
a) If the query is taking longer than 30 seconds then it's already putting a significant load on your Data Warehouse
b) 30 seconds is already a long time for a user to wait.
A. Install the latest version of SquaredUp
Firstly, ensure you are running the latest version of SquaredUp.
B. Check the Data Warehouse
One option to address these timeouts is to check the performance and load on the SCOM Data Warehouse server, and if necessary provide your Data Warehouse with more compute resources.
C. Reconfigure the dashboard
Alternatively you can reconfigure your dashboard.
- Reduce the scope of the dashboard to fewer servers, by clicking on Scope and selecting a group with fewer members. i.e. create a small group in SCOM for testing.
Performance bar charts are expensive. In the metric section check the resolution.
If raw is selected this may account for the Data Warehouse timeout, change this to hourly as this is the recommended and faster setting.
If hourly is selected, then change it to daily, or perhaps raw just to see if this then displays data.
- Try changing the visualization to a Performance line graph or sparkline to see if data is returned.
- Remove one or more of the Performance graphs from the dashboard.