PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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