You have a SQL Server 2012 instance that hosts a single-user database. The database does not contain user-created stored procedures or user-created 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

  Discussion forum


Leave an answer