March 19, 2014 at 5:30 am
Hi,
OS: Win 32 bit EE sp2
SQL instance:SQL 2008 X86 RTM
We have some memory performance issue on it and so we have tried to enable Awe.
When have enable AWE and restarted the SQL Server but ,in error log it showing as
"
SQL Server is not configured to use all of the available system memory. To enable SQL Server to use more memory, set the awe enabled option to 1 by using the sp_configure stored procedure.
"
We have set max and min memory 0 and 6 GB but in task manger it is showing around 1.6 GB,Please lt me know how to increase
6 GB to utilize sql
DO i need to enable .../3GB or /PAE,which one i need to enable to use SQL more than 4 GB.
Please help to solve the problem.Thanks.
March 24, 2014 at 8:35 am
This link gives you an outline of what you need to do to use AWE effectively: http://sqlserverfinebuild.codeplex.com/wikipage?title=SQL%20Server%20Memory%20Management
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
March 24, 2014 at 9:15 am
Hi There,
This is a good starting point for AWE:
http://technet.microsoft.com/en-us/library/ms175581(v=sql.100).aspx
http://technet.microsoft.com/en-us/library/ms190673(v=sql.100).aspx
You will need the /pae switch, as well as lock pages in memory in secpol. don't forget to set the max memory setting in SQL Server.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply