multiple SIDS sql2005

underprocessableOne reason can be a query which is executed over several processors.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Mark Broadbent" <nospam@.nospam.com> wrote in message news:OGo$BeOVHHA.4832@.TK2MSFTNGP04.phx
.gbl...
> Hi all, I was a bit surprised upon performing a sp_who2 to find several
> groups of spids (see screen shot). Could this be explained because
> asynchronous queries might be being used (I am not aware that they are) or
> is this something specific to the .net provider.
> Could someone explain, I would only have expected one spid only for each
> executing batch.
> Best Regards,
> Mark.
>
>
>