Multiple choice sql-server

Exchange and SQL 7.0 are running on the same server. You notice the performance in exchange is degraded. The Min server memory, Maximum server memory and set working area are set as they were automatically in the installation. What do you do to free memor

  1. Increase Min server memory

  2. Set working area to 1

  3. Set working area to 0

  4. Increase memory allocated to the procedure cache option

  5. Reduce Min server memory
Reveal answer Fill a bubble to check yourself
E Correct answer
AI explanation

Min server memory sets a guaranteed floor of RAM that SQL Server will never give back to the OS. If Exchange is memory-starved while SQL Server's settings are still at their large, dynamically-scaled installation defaults, increasing that floor only forces SQL Server to hold onto even more memory, worsening Exchange's problem. Reducing min server memory lowers SQL Server's guaranteed reservation, allowing the operating system to reclaim idle memory and make it available to Exchange.

Keep practicing — related questions