Follow the steps below in order to exclude these events:
The file of {Diagnostic Server folder}\Agent\conf\Package\sqlserver_spotlight\def_wait_events.txt defines the wait category, You can edit this file to exclude wait type by set it to idle type, for example to exclude "HADR_CLUSAPI_CALL" :
1. Go to {Diagnostic Server folder}\Agent\conf\Package\sqlserver_spotlight\
2. Backup file def_wait_events.txt
3..Open and find "HADR_CLUSAPI_CALL" and update its sub_category from "S_WAIT_OTHER_HADR" to "WAIT_IDLE";
4.Save and restart Diagnostic server to take effect.
An Enhancement Request(DS-1308) has been created to be able to exclude the following waits:
HADR_SYNC_COMMIT
HADR_CLUSAPI_CALL
HADR_DB_COMMAND
PREEMPTIVE_OS_WSASETLASTERROR
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center