Alert wait cycles fail to operate properly with the Microsoft SQL Server Adapter.
VMware Aria Operations 8.18.x
Microsoft SQL Server adapter is sending the same metric value three times during a single collection cycle. This incorrectly shortens the symptom wait cycle.
A workaround is to set the wait/cancel cycle for the Condition to '1 and 1' and adjust the alert wait/cancel cycle as required.
Subscribe to this article for future updates on the permanent fix.