Which advanced server option should you modify?

You have a database for a mission-critical web application. The database is stored on a SQL
Server 2012 instance and is the only database on the instance.
The application generates all T-SQL statements dynamically and does not use stored
procedures.
You need to maximize the amount of memory available for data caching.
Which advanced server option should you modify?

You have a database for a mission-critical web application. The database is stored on a SQL
Server 2012 instance and is the only database on the instance.
The application generates all T-SQL statements dynamically and does not use stored
procedures.
You need to maximize the amount of memory available for data caching.
Which advanced server option should you modify?

A.
Optimize for Ad hoc Workloads

B.
Enable Contained Databases

C.
Allow Triggers to Fire Others

D.
Scan for Startup Procs

Explanation:



Leave a Reply 0

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