April 6, 2009 at 12:09 pm
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
Thanks,
Sudhie.
April 6, 2009 at 1:00 pm
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
April 7, 2009 at 1:33 pm
Thank You, it helped me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply