再来围观一下这道题，关于CXPACKET waits

[谁是谁的谁]

You are designing a new SQL Server instance that will support a Web application. The Web application
is hosted on a Web farm that contains 32 nodes. The server has 128 GB of memory and 16 processor cores. The application contains two databases and supports both online analytical processing (OLAP) and
online transaction processing (OLTP) workloads. When testing the application, you discover that some
queries run extremely slow and some queries run very fast. You need to ensure that the server processes database queries as fast as possible. What should you do? (More than one answer choice may achieve
A.Execute the following command on the server: exec sp_configure 'maximum degree of parallelism', 1
B.Execute the following command on the server: exec sp_configure 'maximum degree of parallelism',8
C.Use SQL Profiler to identify queries that experience CXPACKET waits. Add ( OPTION MAXDOP 1) to
each query.
D.Use SQL Profiler to identify queries that experience CXPACKET waits.Add (OPTION MAXDOP 8) to
each query.

这道题标准答案是C，为何选C？

[谁是谁的谁]

[Quote=引用 3 楼 fredrickhu 的回复:]

引用 2 楼 perfectaction 的回复:
引用 1 楼 fredrickhu 的回复:

怎么全是E文 ？


你不是考过吗？考的中文？

几年前的了 忘记光了。
[/Quote]MS跑题了。。。

[Ubuntu_Fedora]

C

CXPACKET waits 是并行等待

找出CXPACKET waits对应的语句，改为最大用1个cpu

[--小F--]

怎么全是E文 ？

[nzperfect]

[Quote=引用 1 楼 fredrickhu 的回复:]

怎么全是E文 ？
[/Quote]

你不是考过吗？考的中文？

[--小F--]

[Quote=引用 2 楼 perfectaction 的回复:]
引用 1 楼 fredrickhu 的回复:

怎么全是E文 ？


你不是考过吗？考的中文？
[/Quote]
几年前的了 忘记光了。