DBCC sqlperf(waitstats) contains signal wait time longer than last time waitstats was cleared 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?
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.