Ignoring additional waits
Published 28 March 2024
Redgate Monitor ignores a number of waits by default. It may be necessary or desirable to ignore additional waits.
Step-by-step guide
Ignorable waits can be added to the table settings.KeyValuePairs
using the settings.AppendValueToCSV
stored procedure:
- EXEC [settings].[AppendValueToCSV] 'WaitStatsCollection-WaitsToIgnore', 'SQLTRACE_WAIT_ENTRIES'
This will append the new wait, SQLTRACE_WAIT_ENTRIES, at the end of the list of waits to ignore.
settings.KeyValuePairs
are maintained after an update to Redgate Monitor.