Some user sessions connected to database are not displayed in SQL Performance Investigator (4291949)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

Some user sessions connected to database are not displayed in SQL Performance Investigator
Beschreibung

While investigating an issue using session information, it is noticed that Foglight does not show the user session within SQL Performance Investigator (SQL PI). The session does appear under the "Overview | Activity | Session" section.
Ursache

The statements run by the user session may not have enough activity to be displayed in the list.
Lösung

This is an expected behavior.
From the SQL PI dashboard, when trying to filter by user it will show the most active users on the selected time frame. This will be based on the Top x statements as selected on the "Tops: x" filter in PI and sorted by active time.
Increasing the filter to show up to "1000" statements may provide additional session information, but if the statements used by the applications the users are running are not part of the top x statements group, they will not appear on the list.
The "Overview | Activity | Sessions" section will show information on all sessions for the past 60 minutes.

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Produkt(e):: Foglight Cloud
Hosted; Foglight
8.1.0, 8.0.0, 7.3.0, 7.1.0, 6.3.0, 6.1.0, 6.0.0, 5.9.8, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2, 5.7.5; Foglight for Databases
8.1.0, 8.0.0, 7.3.0, 7.1.0, 6.3.0, 6.1.0, 6.0.0, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2

Artikelhistorie:: Erstellt am: 11/16/2017
Letzte Aktualisierung am: 1/19/2026

Titel