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.This documentation contains proprietary information and is protected by copyright law.
Copyright © 2026 Red Gate Software Limited. All rights reserved