Which tool should you use?

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?

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *