Duplicate Process ID

I have a stored procedure that uses cursers. This stored
procedure executed by a user from MTS server. At times,
when I refresh the 'Current Activity' and look
into 'Process Info' window in EM, I see two process ID (ID
54) for the same stored proc. Shouldn't the ID's be unique
and assigned only 1 for this SP ? Would this be a SP
issue ?
It is on Win 2K SQL 2K SP2 (With latest patch before SP3)
Thanks.
That means, the query inside your sp is doing parallel processing. SQL
Server can make use of more than one processor, if available - based on the
query.
More information on parallelism can be found in SQL Sever 2000 Books Online.
You can restrict parallelism by using the MAXDOP hint.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:73ba01c47647$1c37efc0$a401280a@.phx.gbl...
I have a stored procedure that uses cursers. This stored
procedure executed by a user from MTS server. At times,
when I refresh the 'Current Activity' and look
into 'Process Info' window in EM, I see two process ID (ID
54) for the same stored proc. Shouldn't the ID's be unique
and assigned only 1 for this SP ? Would this be a SP
issue ?
It is on Win 2K SQL 2K SP2 (With latest patch before SP3)
Thanks.
|||Thanks.

>--Original Message--
>That means, the query inside your sp is doing parallel
processing. SQL
>Server can make use of more than one processor, if
available - based on the
>query.
>More information on parallelism can be found in SQL Sever
2000 Books Online.
>You can restrict parallelism by using the MAXDOP hint.
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"Dan" <anonymous@.discussions.microsoft.com> wrote in
message
>news:73ba01c47647$1c37efc0$a401280a@.phx.gbl...
>I have a stored procedure that uses cursers. This stored
>procedure executed by a user from MTS server. At times,
>when I refresh the 'Current Activity' and look
>into 'Process Info' window in EM, I see two process ID (ID
>54) for the same stored proc. Shouldn't the ID's be unique
>and assigned only 1 for this SP ? Would this be a SP
>issue ?
>It is on Win 2K SQL 2K SP2 (With latest patch before SP3)
>Thanks.
>
>.
>