SQL Server Books online defines the TRACEWRITE sql wait stat type as “Occurs when
the SQL Trace rowset trace provider waits for either a free buffer or a buffer with
events to process”
The trace rowset provider drops events from the internal buffer, if it needs the
If the buffer is full and data is consumed slowly or not at all, the rowset provider
allows a delay. If the buffer is still full – the rowset provider drops events to
allow progress. SQL Server Profiler creates an error message.
The TRACEWRITE sql wait stat type indicates if the internal buffer pressure is increasing
– prior to dropping events. TRACEWRITE increases as more worker threads waitv for
A few issues to consider and approaches to minimizing TRACEWRITE sql wait stat type
1) Check for intense long running sql queries.
2) Are there other sql server traces running?
The first query returns a recordset of the number of traces running .
The second query returns greater trace detail.
SELECT count(*) FROM :: fn_trace_getinfo(default) WHERE property = 5 and value = 1
SELECT * FROM :: fn_trace_getinfo(default)
3) Check disk IO performance
Republished from http://www.sqlserver-dba.com.
Republished from SQL Server DBA [65 clicks].
Read the original version here [32134 clicks].