After migrating from NT4 to Windows Server 2003, one of the sites I host had a very annoying problem. Each page (with a MSSQL backend) took 7 seconds to load. This delay could not be attributed to CPU or I/O load, and after googling for god knows how long, I found many others had similar problems. I then came across this page;

http://www.developersdex.com/sql/message.asp?p=&r=3913370&Page=1

It seems others had similar problems to myself, so after applying SP3 for SQL Server 2000, and the hotfix found at http://support.microsoft.com/?id=815495, my problems were fixed!

URLS which may be of some help:

Hotfix patch: http://support.microsoft.com/default.aspx?kbid=821277

Link to download: http://www.microsoft.com/downloads/details.aspx?familyid=9814AE9D-BD44-40C5-ADD3-B8C99618E68D&displaylang=en