This alarm is raised when a (specified collection) failed to run against the server.
Refer to the message details for this alarm.
- If the message details alert you to a problem in your environment then take the action required to resolve that problem.
- If the message details alert you to a problem within Spotlight then contact Quest Support.
Note: Collection ‘Create Event Session’ failure can occur when the total memory allocated to Azure SQL Extended Event sessions exceeds the allowed limit.
As per Microsoft’s official guidance it is recommended to configure 1 MB or less of memory per session (extended event configuration).
In the observed case, multiple Spotlight connections created Extended Event sessions, and several old stopped sessions remained in the database. Although inactive, these sessions continued to reserve memory, causing the overall memory limit to be exceeded and preventing new sessions from being created.
Immediate Resolution: Remove unused stopped Extended Event sessions to free memory. Currently, the Azure SQL Database implementation does not automatically clean up stopped Extended Event sessions.
As per Microsoft’s official guidance it is recommended to configure 1 MB or less of memory per session (extended event configuration).
In the observed case, multiple Spotlight connections created Extended Event sessions, and several old stopped sessions remained in the database. Although inactive, these sessions continued to reserve memory, causing the overall memory limit to be exceeded and preventing new sessions from being created.
Immediate Resolution: Remove unused stopped Extended Event sessions to free memory. Currently, the Azure SQL Database implementation does not automatically clean up stopped Extended Event sessions.