You are a professional level SQL Sever 2008 Database Administrator. An instance runs on a computer, and the computer has eight quad-core processors and 128-GB RAM. The instance is utilized by four…

Question

Options

• ATo accomplish the goal, software non-uniform memory access (soft-NUMA) should be
• BTo accomplish the goal, the Resource Governor should be configured.
• CTo accomplish the goal, the Windows System Resource Manager should be configured.
• DTo accomplish the goal, an increase should be configured in the maximum degree of

• A
  77% (41)
• B
  6% (3)
• C
  4% (2)
• D
  13% (7)

Explanation

The instance is utilized by four different applications. Not only a low number of CXPACKET waits but also a large number of lazy writer waits are experienced by the instance with software non-uniform memory access, we could set multiple threads to ifo see example below: Consider the following example. A computer with eight CPUs does not have hardware NUMA. Three soft-NUMA nodes are configured. Database Engine instance A is configured to use CPUs 1 through 4. A second instance of the Database Engine is installed and configured to use CPUs 5 through 8. The example can be visually represented as: Claus 1 2 3 4 5 6 7 8 Soft:--NUMA <--N0----><--N1-->< -------- N2 -------- > SQL Server <insurance A ><instance B> Instance A, which experiences significant IIO, now has two UO threads and two lazy writer threads, while instance B, which performs processor-intensive operations, has only one IIO thread and one lazy writer thread. Differing amounts of memory can be assigned to the instances, but unlike hardware NUMA, they both receive memory from the same operating system memory block and there is no memory-to-processor affinity.

No community discussion yet for this question.