You administer a Microsoft SQL Server 2012 database instance.
The instance is running on a server with the following configuration:
1 TB RAM
SAN storage for database and log files
4 quad-core processors
64-Bit Windows 2008 R2 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?
Hot Area:
- Hotspot You Adm 1 (71.88 KiB) Viewed 80 times