CREATE proc track_waitstats & CREATE proc get_waitstats - useful code for diagnosing SQL 2000 performance

CREATE proc track_waitstats & CREATE proc get_waitstats - useful code for diagnosing SQL 2000 performancehttp://blogs.technet.com/mat_stephen/archive/2005/01/25/359848.aspxFor those attending my TechNet SQL 2000 performance tuning session at TVP Reading on Tuesday 25th Jan, here is the code for the track_waitstats and get_waitstats stored procedures I refer to during the presentation. CREATE proc track_waitstats (@num_samplesen-GBCommunityServer 2.1 SP1 (Build: 61025.2)SQL Server Performance Top Tip: Degrees of Parallelism and a Degree of Uncertaintyhttp://blogs.technet.com/mat_stephen/archive/2005/01/25/359848.aspx#369121Tue, 08 Feb 2005 18:50:00 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:369121Mat Stephen's WebLogSQL Server Performance Top Tip: Degrees of Parallelism and a Degree of Uncertaintyhttp://blogs.technet.com/mat_stephen/archive/2005/01/25/359848.aspx#369125Tue, 08 Feb 2005 18:58:00 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:369125Mat Stephen's WebLogSQL Server Performance Top Tip: Degrees of Parallelism and a Degree of Uncertaintyhttp://blogs.technet.com/mat_stephen/archive/2005/01/25/359848.aspx#378151Tue, 22 Feb 2005 21:15:00 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:378151Mat Stephen's WebLog