You use Microsoft Azure Resource Manager to deploy two new Microsoft SQL Server instances in an Azure virtual machine (VM). VM has 28 gigabytes (GB) of memory. The instances are named Instance1 and Instance2, respectively.

The various databases on the instances have the following characteristics:

You run the following Transact-SQL statements:



You need to configure each SQL Server instance to correctly allocate memory.

What should you do?

A. On Instance1, run the following Transact-SQL code:

On Instance2, run the following Transact-SQL code:



B. A. On Instance1, run the following Transact-SQL code:



On Instance2, run the following Transact-SQL code:



C. On Instance1, run the following Transact-SQL code:



On Instance2, run the following Transact-SQL code:



D. On Instance1, run the following Transact-SQL code:



On Instance2, run the following Transact-SQL code:



Incorrect Answers:

A, C: The awefeature will be removed in newer version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

B: Automatic soft-NUMA is disabled by default, and this setting is not relevant here.

References: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-configuration-options-sql-server