PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

Answer:

Explanation:

2 Comments on “Which setting should you configure?

  1. Kevin says:

    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




    0



    0

Leave a Reply