Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > SQL text is showing the incorrect database information in the SQL server

SQL text is showing the incorrect database information in the SQL server

Created by Mandeville, last modified by MindTouch on Jun 23, 2016

Views: 1,219 Votes: 0 Revisions: 7

Overview

A monitored SQL server instance is showing the incorrect database or text displayed in the SQL text (for example, for a database that no longer exists).

Environment

  • All DPA versions
  • All monitored SQL server versions

Cause

Initially, only SQL text is gathered when we see an SQL Statement. This is done for efficiencies and to lower the overhead on monitored instances. It could be a statement that runs against many databases within the same instance or even within any instance that DPA is monitoring.

DPA can be forced to recollect the SQL text by clearing old texts.

Resolution

  1. Run the following script in your DPA repository database as the schema owner:

    Select id, name from ignite.cond;

    -- Choose the id for the db instance that has the hash_value

     

    Select * from ignite.const_@id 
    Where h = @hash_value

     

    Delete from ignite.const_@id 
    Where h = @hash_value

  2. DPA will re-gather the sql_text in about 2 minutes if it's running.

 

Last modified

Tags

Classifications

Public