September 30, 2009 at 10:47 pm
Respected All
Can I set Min & Max Memory in sql server without AWE Enabled
means that If I set Min Server memory & Max Server Memory in sp_configure without enabling AWE , will It Work.
Please Guide me
Thanks
Ghanshyam
September 30, 2009 at 11:49 pm
The short answer is Yes. But sometimes depends upon how much exact memory your server has.
Look in to this thread and I believe,it will help you in understanding the things.
I will also recommend reading SQL Server memory configuration from Books Online (BOL)
October 1, 2009 at 12:21 am
Sir
I am having 2 GB RAM
Thanks
Ghanshyam
October 2, 2009 at 3:43 am
2GB ram is very little memory to run SQL Server. If this is a production machine I recommend you get more memory as it is relatively cheap.
My recommemdation is that you should set SQL max memory. With 2GB on the box and allowing room for Windows, max memory should probably be set to 1.2GB to start with, but you may have to reduce this to 1GB or even 800MB if you have memory pressure. The max memory value will not force SQL to use all that memory, but it will stop it trying to use more.
See http://blogs.msdn.com/psssql/archive/2009/09/11/fun-with-locked-pages-awe-task-manager-and-the-working-set.aspx for a discussion on AWE. My recommendation is to enable AWE on all systems (apart from Express edition wheer AWE is not supported).
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply