How to switch the Extended Event off in version 10.5.1 and 10.5.2? (4339825)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

How to switch the Extended Event off in version 10.5.1 and 10.5.2?
Description

What is the procedure to switch the Extended Event off when Spotlight hangs ( it runs for a minute or 2 then hangs) or it can cause issues in SQL Audit.
Resolution

10.5.1 allows the user to switch the Extended Event 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 to false (in both places !).
5.            Save the file.
6.            Restart the Spotlight Diagnostic Server.
Please note that this is for adding an option to stop using the Extended Event to avoid the SQL Server’s bug in case the SQL Server cannot be be updated with the latest Microsoft patches.
If you don't want to edit original file, then please place the backedup file in top directory (like C drive) otherwise you will get an error about duplicate 44.xml file.
Additional Information

The workaround will stop the collection for the Statement Waits because the extended events is the only way to perform the collection. However, the DS will keep collecting the Deadlock list because the DS will switch the method for the collection from the extended event to the conventional deadlock trace.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title