SQL PI filter by database functionality shows code executed on a different SQL Server database (4301053)

SQL PI may display the wrong SQL Statement when multiple database are running similar code with all having the same procedures but the statements inside point to a specific object in another specific database. 

• Other databases appear in the SQL Statement list.
• Other databases appear to block objects in this filter by database
  The same situation occurs when you filter by users, other databases appear in the SQL Statement list and Blocking history even though this user does not have access to the other databases.
• It seems to appear only on databases that share common code bases 

The scenario is that that environment has multiple databases that have similar code in all of them.

The procedure names may be the same but the code inside those procedures will reference different objects.

Although the statements reference different objects, the query hash on all procedures is the same. This causes a statement that was already resolved, not to be resolved again thus pointing to the wrong statement, in the UI.

WORKAROUND

None

STATUS

This issue has been logged as defect SSFOG-482 and will be fixed in a future version of the Foglight SQL Server cartridge.