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

Tchater maintenant avec le support

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

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

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.
Cause

The statements run by the user session may not have enough activity to be displayed in the list.
Résolution

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.

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Contenu recommandé

Produit(s) :: 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

Historique de l’article :: Créé le : 11/16/2017
Dernière mise à jour le : 1/19/2026

Titre