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:
