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

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 memory’, 4;
B. ALTER SYSTEM SET ‘max server memory’=4096;
C. sp_configure ‘max server memory’, 4;
D. sp_configure ‘max server memory’, 4096;

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.