Find attached a script to drop all extended event sessions created by Spotlight Cloud
The 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.
Waiting for fix in a future release of Spotlight Cloud