Submit a ticketCall us

WebinarVisual Monitoring Tactics: Getting More Log Search Value from SolarWinds Log & Event Manager with nDepth Webcast

Do things seem to make more sense when they are visualized? Are you an IT professional or security expert with a wish for more cybersecurity tools that provide an intuitive visual experience? Join Alexis Horn and Jamie Hynds from SolarWinds as they demonstrate how the nDepth feature in LEM can help make visualizing log search results a reality.

Register now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > Monitored SQL database server instance displays the incorrect database in DPA

Monitored SQL database server instance displays the incorrect database in DPA

Updated January 4, 2019

Overview

A monitored SQL Server database instance displays the incorrect database or text in DPA (for example, the database no longer exists).

Environment

  • All DPA versions
  • All monitored SQL Server versions

Cause

The first time DPA sees a SQL statement, DPA collects only SQL text. This is done to minimize the overhead on the monitored instances. The SQL statement may run 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

We need to know the instance ID of the DPA monitored server and the SQL hash value and we can remove the incorrect text and DPA will recollect the newly corrected text. We can find these on the web console.

clipboard_e01959837eae6272ab34968591dce4504.png

It is possible that the SQL text has been named and in this case, the hash will not display here. If this is the case then follow below. 

clipboard_e5d9fec64ee1423c7b7de0e00cc5ad597.png

Run the following script on your DPA repository database as the schema owner:

Select id, name from ignite.cond;

Choose the ID for the database instance with the hash_value.

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

DPA recollects the SQL text in about two minutes (if it is running). 

in DPA 12.0 and up you must also restart the DPA service

 

Last modified

Tags

Classifications

Public