You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows
Server 2012 servers running SQL Server 2012.
You have configured parallel execution plans on a server named ABC-SQL1.
You suspect that some of the parallel execution plans may be running in serial.
How can you view which parallel execution plans are running in serial?
A.
By viewing the processes in Task Manager.
B.
By configuring counters in Performance Monitor.
C.
By configuring a Dynamic Management View.
D.
By configuring an Extended Events session.
Explanation:
A & B cannot ; numeric one
C Ok using sys.dm_exec_query_stats in witch there is the cached plan
0
0