Which of the following statements will set the maximum amount of system memory that is managed by the SQL Serv

adminFebruary 5, 2019

Which of the following statements will set the maximum amount of system memory that is managed by the SQL Server Memory Manager to 4GB?

A. sp_configure -max memor

y-, 4;

B. ALTER SYSTEM SET -max server memory-=4096;

C. sp_configure -max server memory-, 4;

D. sp_configure -max server memory-, 4096;

References:

Get 50% Discount on All Your Purchases
at PrepAway.com - Latest Exam Questions