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.