Multiple SPID''s with the same ID

• SA-1

  SSCrazy Eights

  Points: 8113

  More actions

  March 28, 2006 at 1:08 pm

  #365723

  Why do I see multiple SPIDs with the same process id in Current Process Info. When I kill it all of them disappear? Is this something to worry about?

  TIA

• Balmukund

  SSCertifiable

  Points: 6648

  More actions

  March 28, 2006 at 10:17 pm

  #629358

  You will see multiple SPIDs for the same process if the query is going for parallelism.

  There is nothing to worry about