max server memory and min server memory (MB) setting  
Author Message
Mwob





PostPosted: Wed Aug 10 03:55:57 CDT 2005 Top

SQL Server >> max server memory and min server memory (MB) setting

should these parameters be left to the server or should we set the min - max
according to let's say 90 percent of phyisical memory.
thanks

SQL Server262  
 
 
Uri





PostPosted: Wed Aug 10 03:55:57 CDT 2005 Top

SQL Server >> max server memory and min server memory (MB) setting Tal, shalom
It is recommended to set the memory to dynamic (default settings) , but if
you have some problems with a memory and identified them (by Perf.Monitor
for example) , you can set up max memory.




> should these parameters be left to the server or should we set the min -
> max
> according to let's say 90 percent of phyisical memory.
> thanks