MS SQL Server - Same sp_id multiple times in Process Info

Author

Same sp_id multiple times in Process Info

FireStarter

2006-01-31, 11:23 am

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.

Russell Fields

2006-01-31, 1:23 pm

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.

FireStarter

2006-01-31, 8:23 pm

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 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.

Sponsored Links