Submit a ticketCall us

Training ClassSign up for Network Performance Monitor (NPM) and Scalability instructor-led classes

Attend our instructor-led classes, provided by SolarWinds® Academy, to discuss the more advanced monitoring mechanisms available in NPM as well as how to tune your equipment to optimize its polling capabilities. NPM classes offered:
NPM Custom Monitoring and Polling
Orion Platform Scalability

Reserve your seat.

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