Which setting should you configure?

HOTSPOT
You administer a Microsoft SQL Server 2012 database instance.
The instance is running on a server with the following configuration:
1TB RAM
SAN storage for database and log files
4 quad-core processors
64-Bit Windows 2008R2 operating system
This instance hosts a database with large partitioned tables. Users report that complex queries are
taking a long time to complete.
While troubleshooting, you discover that CPU utilization is low (less than 20 percent), disk activity is
low (little or no waiting processes), and no significant blocking is occurring.
You need to ensure that the instance can process queries as quickly and efficiently as possible.
Which setting should you configure?

HOTSPOT
You administer a Microsoft SQL Server 2012 database instance.
The instance is running on a server with the following configuration:
1TB RAM
SAN storage for database and log files
4 quad-core processors
64-Bit Windows 2008R2 operating system
This instance hosts a database with large partitioned tables. Users report that complex queries are
taking a long time to complete.
While troubleshooting, you discover that CPU utilization is low (less than 20 percent), disk activity is
low (little or no waiting processes), and no significant blocking is occurring.
You need to ensure that the instance can process queries as quickly and efficiently as possible.
Which setting should you configure?

Answer:

Explanation:

Show Hint

Leave a Reply 1

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

Kevin Burgess

Kevin Burgess

It is all well and good Setting the “Max Degree of Parallelism” but it is not likely to make Things very much faster if “Cost Threshold for Parallelism” remains so low…..

Don’t like this question….

Reply