Note: This question is part of a series of questions that present the same scenario. Each question in
the series contains a unique solution. Determine whether the solution meets stated goals.
You have a mission-critical application that stores data in a Microsoft SQL Server instance. The application
runs several financial reports. The reports use a SQL Server-authenticated login named Reporting_User. All
queries that write data to the database use Windows authentication.
Users report that the queries used to provide data for the financial reports take a long time to complete. The
queries consume the majority of CPU and memory resources on the database server. As a result, read-write
queries for the application also take a long time to complete.
You need to improve performance of the application while still allowing the report queries to finish.
Solution: You configure the Resource Governor to set the MAXDOP parameter to 0 for all queries against the
database.
Does the solution meet the goal?
A.
Yes
B.
No
Explanation:
SQL Server will consider parallel execution plans for queries, index data definition language (DDL) operations,
and static and keyset-driven cursor population.
You can override the max degree of parallelism value in queries by specifying the MAXDOP query hint in the
query statement.
https://technet.microsoft.com/en-us/library/ms181007(v=sql.105).aspx