sp_who2 active on box box and get multiple rows per single SPID. For example, see below. Does this mean that SQL Server has broken the query into 23 parallel sub-queries? If that's the case, why is it ignoring MaxDegreeOfParallelism setting of 8? Or is this something else?
why is it ignoring MaxDegreeOfParallelism setting of 8?
the MAXDOP setting is used to limit the number of threads per operation in the execution plan and does not limit the number of threads used to execute the query. So it is normal to see threads per SPID in sysprocesses greater than MAXDOP setting.
As a side note: use sp_whoIsActive - there are many options and uses DMVs
-- sp_who2 is legacy, uses old deprecated tables and was written during ice age 1995/11/03 10:16 :-)