Process ID 152:3 Owns Resources That Are Blocking Processes On Scheduler 2.

Last night I received this error


Process ID 152:3 owns resources that are blocking processes on Scheduler 2.



When I did an BCC INPUTBUFFER I found it was sp_MSadd_repl_commands27hp which is doing the insert into MSrepl_commands has any else noticed and issue w/ sp_MSadd_repl_commands27hp blocking itself. At the time I had about 10 million records to move. I was using the default log reader settings so I was batching them in 500 chunk intervals.



I am wondering if any else has had problems like this? I basically see it whenever I move too much data through my replication server.



I found the followoing link http://support.microsoft.com/kb/319892




Sample Scenario

Client 1 connects to SQL Server.

Client 1 runs a Transact-SQL command that starts a transaction and performs data modification.

For example: begin tran
update authors set au_lname = 'test'
Client 1 becomes IDLE, shows up as sleeping, and awaiting a command with an open transaction in the sysprocesses system table.

Clients 2 through 255: Approximately 254 more clients log on to SQL Server and issue a SELECT from the authors table. These clients will all become blocked on the original update.

Client 1 tries to commit the transaction but it becomes queued because all the worker threads are tied up by clients 2 through 255.


I am afraid that I am seeing this more then I would like does anyone know a way to prevent this from happening?