SQLTRACE_WAIT_ENTRIES

Overview

Occurs when waiting for SQL Trace buffer flushes. Extended Events is the modern replacement. High values indicate trace bottlenecks that may be mitigated by switching to XEvent sessions.

Key Metrics

Metric	Description
Wait Type	SQLTRACE_WAIT_ENTRIES
Category	Baseline
Severity	INFO

Troubleshooting

1. Identify the source

Use the following query to identify the top queries contributing to SQLTRACE_WAIT_ENTRIES waits:

SELECT TOP 10
 [Wait Type] = wait_type,
 [Wait Seconds] = wait_time_ms / 1000,
 [Wait Count] = waiting_tasks_count,
 [Avg Wait Ms] = wait_time_ms / NULLIF(waiting_tasks_count, 0)
FROM sys.dm_os_wait_stats
WHERE wait_type = 'SQLTRACE_WAIT_ENTRIES'
ORDER BY wait_time_ms DESC;

2. Related diagnostics

• Review overall wait statistics using sys.dm_os_wait_stats
• Check session-level waits via sys.dm_exec_session_wait_stats
• Correlate with sys.dm_exec_requests for blocking analysis

See Also

• sys.dm_os_wait_stats (Transact-SQL)
• sys.dm_exec_session_wait_stats (Transact-SQL)
• sys.dm_os_waiting_tasks (Transact-SQL)