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.