Retour
-
Titre
Spotlight opening several extended events sessions -
Description
Spotlight creates a new connection to the SQL almost every 24 hours. Each new connection replaces the previous by its activity but the old one doesn't close. -
Résolution
WORKAROUND
Find attached a script to drop all extended event sessions created by Spotlight CloudThe script should be executed by user with "ALTER ANY EVENT SESSION" permission, no other prerequisites.After the event sessions are dropped, it can take 5-10 minutes till Spotlight recreates a new session.In order to make it faster (create new session) and not miss data till the new session is created, it is possible to restart the Diagnostic Server after script execution.By doing this, the new session will be created right after restart.STATUS
Waiting for fix in a future release of Spotlight Cloud
-
Identifiant du défaut
SCMM-3557 -
Pièces jointes