Dynamicly or fixed memory config.? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Dynamicly or fixed memory config.?

If I have some app. running on SQL server is that like a
rule that I have to configure SQL to use fixed memory?
General recommendation is to leave SQL memory settings to dynamic and if any other application is sharing server resources then setting fixed memory may be ideal only after testing which may prove useful. For informationhttp://www.sql-server-performance.com/performance_monitor_counters_memory.asp refer to this link/. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.