Which setting should you configure?

HOTSPOT
You administer a Microsoft SQL Server 2012 database instance. Other applications run on the server.
Some of the applications are throwing errors because of insufficient memory.
You need to ensure that the other applications have sufficient memory.
Which setting should you configure?

HOTSPOT
You administer a Microsoft SQL Server 2012 database instance. Other applications run on the server.
Some of the applications are throwing errors because of insufficient memory.
You need to ensure that the other applications have sufficient memory.
Which setting should you configure?

Answer:

Explanation:



Leave a Reply 2

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


God

God

Maximum Server Memory (in MB)

Kevin

Kevin

Maximum server memory:

The max server memory server configuration option can be used to specify the maximum amount of memory SQL Server can allocate when it starts and while it runs. This configuration option can be set to a specific value if you know there are multiple applications running at the same time as SQL Server and you want to guarantee that these applications have sufficient memory to run.

https://technet.microsoft.com/en-us/library/ms177455(v=sql.105).aspx