Which advanced server option should you modify?

You have a SQL Server 2012 instance that hosts a single-user database. The database does not contain user-created stored procedures or usercreated functions.
You need to minimize the amount of memory used for query plan caching.
Which advanced server option should you modify?
A. Scan for Startup Procs
B. Enable Contained Databases
C. Optimize for Ad hoc Workloads
D. Allow Triggers to Fire Others

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.