SQL Server Performance Tuning

When Was the Last Time Your SQL Server Wait Stats Were Cleared?

Updated July 13, 20262 min read

SQL Server wait stats: a ticket dispenser spooling tickets beside waiting chairs

What are SQL Server wait statistics?

They are data about all the waits encountered by SQL Server threads at the instance level.

Using the Dynamic Management Views (DMVs) sys.dm_os_wait_stats, you can return information that the SQL Server is permanently tracking – why execution threads have to wait.

Why should you care about them?

You should not clear your wait statistics data frequently.

Wait statistics are one of the most important metrics you can use when troubleshooting performance issues in SQL Server.

There are some valid reasons to clear wait stats, but it shouldn’t be done arbitrarily.

How to discover when SQL Server wait stats were cleaned?

You can use the query below to return the date of the last cleaning.

T-SQL
SELECT DATEADD(ms, - [wait_time_ms], getdate()) AS [ClearedDateTime]
FROM [sys].[dm_os_wait_stats]
WHERE [wait_type] = 'SQLTRACE_INCREMENTAL_FLUSH_SLEEP'
Figure 1 - Query output
Figure 1 - Query output

How to fix them?

  1. Try to figure out if a job or someone is clearing the wait statistics (probably there is not a good reason).
  2. The result from the script above will give you initial indications for an analysis.

More information

Check Red9's SQL Server Services

SQL Server Consulting

Perfect for one-time projects like SQL migrations or upgrades, and short-term fixes such as performance issues or SQL remediation.

Discover More ➜

SQL Server Managed Services

Continuous SQL support, proactive monitoring, and expert DBA help with one predictable monthly fee.

Discover More ➜

Emergency SQL Support

Take the stress out of emergencies with immediate access to a SQL Server Sr. DBA 24x7x365

Discover More ➜

Explore All Services ➜