sp_configure returns the following values on a server.
name minimum maximum config_value run_value max degree of parallelism 0 32767 8 8
sp_WhoIsActive show that some spids have more than 8 rows (like 18 or so). Shouldn't it be at most 8 rows in this case?
This query returns a lot of rows from time to time:
SELECT * FROM sys.sysprocesses sp where exists ( select spid from sys.sysprocesses where spid =sp.spid and sp.waitresource = '' group by spid having count(*)>9 )