Is there a way to filter RESOURCE_SEMAPHORE wait events in Foglight for SQL Server?
Is there any rule for this type of wait event?
Foglight has the following alarms on Database dashboard for the wait events:
A RESOURCE_SEMAPHORE is a type of memory wait event that will trigger the DBSS - Memory Wait Baseline Deviation rule.
Currently there is not a specific filter for this type of memory wait event.
If a specific collection for this type of memory wait event or other wait event type is needed, a custom collection could be considered; these can be created from Databases | Administration | User-defined Collections - for example:
select wait_time_ms from sys.dm_os_wait_stats where wait_type = 'RESOURCE_SEMAPHORE'
Additional information on how user defined collections are configured is available on the Foglight for SQL Server User Guide within the section "Configuring User-defined Collections". For the latest documentation, please visit the Foglight - Technical Documentation section from our Support Site.
Once a custom collection is created, a custom rule could be made for it. Please refer to KB114172.