InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 23:43:51 GMT20http://www.sqlservercentral.com/Forums/Topic1386124-391-1.aspx[quote][b]sqlfriends (11/18/2012)[/b][hr]I have a dedicated SQl server that has 12 gb physical memory.[/quote] then MAx memory can go upto 10 gbMon, 19 Nov 2012 02:04:11 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1386124-391-1.aspxAre there other applications/sql instances on the server ? 8.5GB is too low if your instance is alone on the server.Min server memory is not so important to set, especially do not set it high. Maybe if your sql instance is competing with other apps for the server memory.Mon, 19 Nov 2012 00:28:12 GMTVedran Kesegichttp://www.sqlservercentral.com/Forums/Topic1386124-391-1.aspxThe min server memory server configuration option can be used to ensure that SQL Server does not release memory below the configured minimum server memory once that threshold is reached. This configuration option can be set to a specific value based on the size and activity of your SQL Server. If you choose to set this value, set it to some reasonable value to ensure that the operating system does not request too much memory from SQL Server, which can affect SQL. Hope this help.Sun, 18 Nov 2012 18:53:39 GMTSQLSeTTeRhttp://www.sqlservercentral.com/Forums/Topic1386124-391-1.aspxI have a dedicated SQl server that has 12 gb physical memory.I manually change the default max memory to 8.5 GB(8704).Do I need also to setup minimum memory?for example to 1 GB(1024)?ThanksSun, 18 Nov 2012 18:51:24 GMTsqlfriends