Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Server & Application Monitor (SAM) > 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.1 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
18:21, 20 Jul 2017

Tags

Classifications

Public