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.
Verify that your changes to
settings.KeyValuePairs are maintained after an update to Redgate Monitor.