These pages cover SQL Monitor 13, which is not the latest version. Help for other versions is also available.
Ignoring additional waits
Published 14 February 2023
SQL 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 SQL Monitor.
