I am using hints in my query to set the MAXDOP to 6 for a particular query. How to determine whether my SPID is using 6 processors or not. Bit urgent pls
Check the actual execution plan. In the properties of the various processes it will show you if you're using parallelism and how many threads were used by the process.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" - Theodore Roosevelt