Description
This wait accumulates when a trace (commonly run as Profiler) is waiting for event processing to complete in order for the trace to shutdown. This wait type is uncommon and generally occurs because a trace has been configured to capture too many events. As traces are generally used for diagnostic purposes this wait typically does not effect end-users. If values are excessive see suggestions below
Resolved by
DBAs
Suggested solutions
- When using Profiler or trace only capture the appropriate events and columns. Filter when possible
- Do not run traces over the network
- Send trace output to file rather than to table
- Ensure that the trace destination file is to a fast disk