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
You have a database for a mission-critical web application. The database is stored on a SQL Server 2012 instance and is
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You have a database for a mission-critical web application. The database is stored on a SQL Server 2012 instance and is
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!