Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

Symptoms

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.

Cause

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.

Procedure

1. Install the latest version of SquaredUp DS.

   Get the latest version of SquaredUp DS for SCOM

2. 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.

   See How to optimize the Data Warehouse - 5 Point Plan.

3. Reconfigure the dashboard.

   1. 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.

   2. 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.

   3. Try changing the visualization to a Performance line graph or sparkline to see if data is returned.
   4. Remove one or more of the Performance graphs from the dashboard.