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?
A.
Performance Monitor
B.
Database Engine Tuning Advisor
C.
Data Profile Viewer
D.
Extended Events
Explanation:
http://msdn.microsoft.com/en-us/library/bb677278.aspx
http://msdn.microsoft.com/en-us/library/bb630282.aspx
http://www.sql-server-performance.com/2006/query-execution-plan-analysis/
http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-insqlserver/http://www.sqlservercentral.com/articles/SQL+Server+2012/At+last%2c+execution+plans+sh
ow+true+thread+reservations./92458/
http://sqlblog.com/blogs/paul_white/archive/2011/12/23/forcing-a-parallel-queryexecutionplan.aspx
http://sqlblog.com/blogs/paul_white/archive/2012/05/02/parallel-row-goals-gone-rogue.aspx
http://msdn.microsoft.com/en-us/library/bb895310.aspx
http://msdn.microsoft.com/en-us/library/bb895313.aspx
http://msdn.microsoft.com/en-us/library/hh231122.aspx