I'm trying to troubleshoot some performance problems on our SQL2000 production server.
I ran DBCC SQLPERF(waitstats) and noticed the stats hasn't been cleared in a long time. So I cleared them and did some refreshing and noticed after only a few minutes, OLEDB reported a signal wait time in the order of hundreds of millions of milliseconds. How is this possible?
Sql-server – DBCC sqlperf(waitstats) contains signal wait time longer than last time waitstats was cleared
performanceperformance-tuningsql-server-2000
Related Question
- Sql-server – Auto Update Statistics Duration and Interruptions
- Mysql – Lock time not involved in MySQL slow query selection
- How to Collect Wait Stats in SQL Server 2012
- Mongodb high lock percentage / slow queries
- What might be the cause of regular periodic slow transactions on an OLTP system
- SQL Server 2012 Performance – Super Slow with No Queries
- MySQL intermittent slow queries
- SQL Server Query Performance – Methodology for Tracing Sporadically Long Running Queries
Best Answer
The signal wait time is aggregated across all cores. Any system with more than one core can have total signal waits longer than the last time you clear the wait stats.