Microsoft
70-459 · Question #30
You have a server that has SQL Server 2012 installed. You need to identify which parallel execution plans are running in serial. Which tool should you use?
The correct answer is C. Extended Events. show+true+thread+reservations./92458/
Maintain a database
Question
You have a server that has SQL Server 2012 installed. You need to identify which parallel execution plans are running in serial. Which tool should you use?
Options
- APerformance Monitor
- BDatabase Engine Tuning Advisor
- CExtended Events
- DData Profile Viewer
How the community answered
(31 responses)- A6% (2)
- B3% (1)
- C81% (25)
- D10% (3)
Explanation
show+true+thread+reservations./92458/
Topics
#parallel execution#Extended Events#execution plan#query performance
Community Discussion
No community discussion yet for this question.