Same sp_id multiple times in Process Info

When I go to Process Info in SQL Enterprise Manager, sometimes I can see
the same sp_id in there multiple times (5-10 different instances
sometimes). And sometimes the same sp_id is listed as blocking itself!?
It is the first time I am seeing this. It used to be that there was one
entry per sp_id.

As far as I can tell, this started after applying SP4.

Configuration: Win 2000 Server + SQL Server 2000 standard (SP4).


Do you guys see a problem with this and why is it happening?


Thanks.

Prior to SP4 you could see several lines for a single SPID if it was doing
some work in parallel.

After SP4 you can still see several lines, but SP4 added the ability to see
when a spid was blocking itself.  (This has always happened, but you (and I)
could not see it until SP4.)

So far as I know, there is no problem.

RLF
"FireStarter" <d@d.com> wrote in message
news:O$OLaaoJGHA.604@TK2MSFTNGP14.phx.gbl...
> When I go to Process Info in SQL Enterprise Manager, sometimes I can see
> the same sp_id in there multiple times (5-10 different instances
> sometimes). And sometimes the same sp_id is listed as blocking itself!?
> It is the first time I am seeing this. It used to be that there was one
> entry per sp_id.
>
> As far as I can tell, this started after applying SP4.
>
> Configuration: Win 2000 Server + SQL Server 2000 standard (SP4).
>
>
> Do you guys see a problem with this and why is it happening?
>
>
> Thanks.

Thank you.


Russell Fields  wrote:
> Prior to SP4 you could see several lines for a single SPID if it was doing
> some work in parallel.
>
> After SP4 you can still see several lines, but SP4 added the ability to se
e
> when a spid was blocking itself.  (This has always happened, but you (and 
I)
> could not see it until SP4.)
>
> So far as I know, there is no problem.