This issue due to collections for the Deadlock List and StatementWaits
were timed out. This was what we recently found caused by SQL Server’s bug on the extended events.
This issue was disclosed in 10.5 because we started using the extended events function from 10.5.
To use the workaround you needs to upgrade to SoSSE version 10.5.1.
It allows user to switch the Extended Event off.
To turn it off:
1. Locate the file Agent\conf\product\44.xml in the Spotlight Diagnostic Server installation folder.
2. Edit the file.
3. Locate the line
<property dataType="BOOLEAN" description="useextendedevents" displayName="UseExtendedEvents" encryptStyle="NONE" hidden="true" name="useextendedevents">true</property>
4. Change true (the one between “>” and “</”) to false.
5. Save the file.
6. Restart the Spotlight Diagnostic Server.
