The master.dbo.sysprocesses table in Microsoft SQL Server 2000 and SQL Server 2005 is a system table that contains information about the active server process IDs (SPIDs) that are running on SQL Server. If you are using SQL Server 2005, you can also access this table by using the sys.sysprocesses compatibility view.The waittype column, the lastwaittype column, the waittime column, and the waitresource column in the master.dbo.sysprocesses system table provide information about the resources that the processes are waiting on.
References:
How to monitor blocking in SQL Server 2005 and in SQL Server 2000Blocked Process Report Event ClassDescription of the waittype and lastwaittype columns in the master.dbo.sysprocesses table in SQL Server 2000 and SQL Server 2005
Cross Posted from blogs.technet.com/rob