SQL Server 2000 Wait Types

The various wait types in SQL Server don't make much sense by just looking at them. There is a excellent list on http://sqldev.net/misc/WaitTypes.htm with good descriptions and possible fixes.

You see these wait types when running the system stored procedure sp_lock or though Enterprise Manager (Management, Current Activity tree).

On a system that is running optimal, you should not see many of them (maybe one or two infrequently).

 

 

Published Wed, Nov 3 2004 13:42 by Mike Epprecht
Filed under: