You have the following Microsoft SQL Server instances. The instances are members of a cluster.
Server1 has 42 gigabytes (GB) of memory and Server 2 has 48 GB of memory. The operating system and other processes on each server require 4 GB of memory. Instance2 does not failover successfully to Server1. You need to resolve the issue.
What should you do? NOTE: Each correct selection is worth one point.
A . Set the value of the Maximum server memory option for Instance1 to 24576
B . Set the value of the Minimum server memory option for Instance2 to 0
C . Set the value of the Maximum server memory option for Instance2 to 32768
D . Set the value of the Minimum server memory option for Instance1 to 16384
Answer: C
Explanation:
References: https://blogs.msdn.microsoft.com/pamitt/2010/11/06/sql-server-2008-and-r2-cluster-best-practices/
Leave a Reply