Ignoring additional waits

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:

  1. 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.



Didn't find what you were looking for?