Submit a ticketCall us

WebinarFREE IT Monitoring Webcast

Don’t miss out on our webcast, Essential IT Monitoring with SolarWinds ipMonitor, where we will show you how to keep an eye on your IT environment from one centralized, affordable, and lightweight monitoring tool: SolarWinds® ipMonitor®.

Register now.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > AppInsight for SQL: Top Tables for Database displays a timeout error

AppInsight for SQL: Top Tables for Database displays a timeout error

Updated July 21, 2017

Overview

The Top Tables for Database component in AppInsight for SQL displays the following error:

No valid data was received. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Environment

SAM 6.2 and later

Cause 

A large table in one or more databases causes the query to pull information before the query timeout expires.

Resolution

  1. Open the Orion Web Console.
  2. Go to the AppInsight for SQL instance in question, and then click Edit Application Monitor.
  3. Find and expand Top Tables for Database.
  4. Click Override Template (next to Query Timeout).
  5. Update the value from 30 to 60 seconds.
  6. Click Submit.

There should be no errors in the next polling period.

 

Last modified

Tags

Classifications

Public