.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Configuring AWE and memory usage in SQL Server 2005

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :Sql Server
Dear Sirs,
I installed SQL Server 2005 Enterprise Edition (with SP3) on a server running Windows Server 2003 Enterprise Editon SP2 with 8GB RAM and with "Physical Address Extension".
I want the SQL Server 2005 makes use of memory that is in excess of 4 GB and will perform the following steps to accomplish this:

1) I'll add the SQL service account to the
policy "lock his pages in memory"

2) I'll include the /PAE switch in Boot.ini

3) I'll change the "awe enabled" with the following commands:

sp_configure 'show advanced options', 1
sp_configure 'awe enabled', 1

4) I'll change "min server memory" and "max server memory" with the following commands:

sp_configure 'min server memory', 1024
sp_configure 'max server memory', 8192

View Complete Post

More Related Resource Links

Configuring SQL Server 2005 to use only IPv6

Hi, I need to configure my SQL Server 2005 Express to use only IPv6. I understand this is done in the Configuration Manager but do not know exactly where. Can someone kindly advise? Thank you.

Configuring AWE and SQL 2005 Memory ! Is this right ??

Hi All     I would appreciate any help from you all with regards to this:   I have a SQL 2005 standard installation with windows server 2003 enterprise Operating system The server has 7GB of memory available to it, but as I know SQL 2003 standard edition would make use of the total server memory available to it.   Here are the changes that I have made. (I have converted it all to GB for easy reading)   I added the 3GB switch to the boot.ini file I enabled AWE I set mini server memory to 5GB I set max server memory to 6GB I turned on Performance monitor and the Target server memory counter  = 6GB, the total server memory is also set to 6GB.   Now after all the changes above, the server seems to run slower and looking at task manager, the PF usage is around 6GB. If I change the max server memory, the PF usage shoots up again, it MAX server memory is set to 5GB, PF usage jumps to 5GB as well..   Can anyone please confirm that the changes I made were indeed correct and possibly educate me on the configuration and how to make the best use of server memory etc.   I look forward to hearing from you all.   Thanks

SQL 2005 (32-bit) cluster memory usage

We recently did an in-place upgrade of our cluster from SQL 2000 Enterprise to 2005 Enterprise.  We are seeing memory utilization on the server that is not expected and wanted to get an idea from others if this is normal.  Here is our setup:

32-bit Windows Server 2003 SP1
SQL 2005 SP2, 2-node cluster
16 GB memory on each node
/3GB /PAE switches in the boot.ini file
AWE Enabled, min memory=0, max memory=14000

The strange bit is that in the Task Manager the SQL service is showing as only using 205 MB of memory and the pagefile usage is at 13 GB.  This is troublesome since it looks like SQL is using virtual memory instead of physical memory.  We recently upgraded the memory from 4 GB to 16 GB, the sql cluster service account was added to the Lock Pages in Memory policy, the boot.ini switches were set and the AWE enabled/max_server_memory script was run before upgrading to 2005.  Can anyone confirm either 1) this is normal or 2) how to correct the memory usage?

I have also questioned using the /3GB switch; would it be better to remove that and set the max memory for SQL to 12000?

Any help would be greatly appreciated.  If I left off any information that would be helpful, please let me know.


SQL Server 2008 Memory Usage


We are using SQL Server 2008 x64 SP1 CU8 EE, and we have 32 GB of RAM on the server. We currently have the instance restricted to 14 GB of RAM, the "Lock Pages in Memory" security setting on the service account, and AWE enabled in SQL Server. This server is part of a 3 node active/active/passive cluster. My question is:


How do I know how much memory sql server is actually using, or if the server is under memory pressure? 

John M. Couch

sql server high memory usage


Hello Guys

just wondering how do you handle similar situation, we had a call from angry client saying they are unable to do anything and things take too long to complete. when i logged in i noticed that sql server taking all memory (6GB) for some reason. interestingly CPU usage is normal.

I know i can run profiler to see what queries are taking such huge memory before it happens but what if it already happened and you want to see whats currently eating all that memory ? thanks for the advise.

sql server is 2008 and our desktop app is C# 2008.


SQL Server 2008 - High Memory Usage


Hi ,

  We are facing problem with the high memory usage with SQL Server 2008. 64 bit , standard edition sp2 . 8 GB RAM , 8 processors .

Memory usage keep on growing ..sometimes it will reach to 7.5 GB also .... and its not coming down ..untill we restart the service...

These are the details of DBCC MEMORYSTATUS :: Please suggest how to overcome this problem

Memory Manager                           KB
---------------------------------------- -----------
VM Reserved                              8484792
VM Committed                             4220368
Locked Pages Allocated                   0
Reserved Memory                          1024
Reserved Memory In Use      &n

SQL Server 2008 R2 on Windows Server 2008 R2 Memory Usage issues and not giving memory back


Okay so i have a physical server i am trying to replace with a virtual server. Its doing a large load process every night, about 190GB on one disk.

The VM is:

On vSphere 4.1 ESXi

O/S is Windows Server 2008 R2 Enterprise

SQL version is SQL Server 2008 R2 Enterprise.

4 vCpus

Now 20GB of memory

Disks assigned to this virtual are all seperate LUNs except for the O/S which is on a shared LUN which is not busy. So 1 LUN/Datastore per 'disk drive on this SQL virtual. Data/Log/TempDB/Backup are on their own LUNs.

All the recommended exclusions are in place for McAfee on a SQL Server.

ESXi 4.1 Enterprise host is not overcommitted. Has 4 x 6core 2.6Ghz AMD processors. BL685c G6 and 128GB of memory. Almost nothing else is running at the time i am testing this load and host is not overcommited or stressed or anywhere near it.

SQLServer process shows 127,236K Working Set and 130,040K Peak working set and memory Private working set 88,828k and Commit Size of 302,792k.

It seems when i check the memory usage in task manager it doesn't show much. In Windows 2003 X64 in would show the GB being used, like 8GB right in task manager. But i don't see that in Windows 2008 R2 task manager. I downloaded SysInternals and it shows the memory on the Windows 2008 r2 box as 15Gb of AWE memory. How can this be? The case is th

ASP.NET Server Memory usage



My name is Johnathan and I work as an asp.net web devoloper.

My company is starting to transfer from classic asp to asp.net 4.0 in our websites. During the transition I have encountred a few issues:

  1. It seems that asp.net uses a lot more memory then classic asp on the server that hosts the websites. Is that true, and if so how can I minimize the memory usage?
  2. Does asp.net 4 transitiond out of the beta phase? I have a website that is built in the asp.net 4.0 technology that is running smooth on the localhost, but on the server sometimes it doesn't connect to the database. Does this mean it is the host provider's fault or is it something in the code? (here is the website: http://www.sospets2.co.cc/)

Thanks alot and have a nice day!


SQL Server 2005 SP2 - AppDomain was unloaded by escalation policy. Out of memory while accessing a c


I am posting this in the .NET Framework inside SQL Server forum as I assume the issue is related to CLR / SQL Server.  Please let me know if this is the incorrect forum.

I am receiving the following error in the event log:

AppDomain [DB_NAME].dbo[runtime].5253 was unloaded by escalation policy to ensure the consistency of your application. Out of memory happened while accessing a critical resource. 
System.Threading.ThreadAbortException: Exception of type 'System.Threading.ThreadAbortException' was thrown.

The system that this is occurring on is a Windows Server 2003 R2 SP2 (32 bit), SQL Server 2005 SP2 with 8 GB of RAM:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

9.00.3042.00	SP2	Standard Edition

The CLR assembly is relatively simple and is referenced by both store procedures as well as by a table trigger (update).  Essentially the CLR assembly instantiates an object (in a referenced webservice on a separate&

SQL Server 2000 is getting very slow, memory usage also very high but restarted db service it comes



I am facing slow down problem in SQL Server 2000. SQL Server is very very slow during that time memory also very high usage but when I restart SQL Service it comes to normal. Please advice, if anyone who has experienced in this type of situation. Appreciate if you help to resolve this problem. Thanks





What is the usage of RowGUID under SQL Server 2005?


Hi All

What is the usage of Row Guid under SQL Server 2005? It seems not much information state the main purpose of it?





Usage Report "Server Out of Memory



in one of our SiteCollections we cannot start den Usage Report. It says "Server Out of Memory". We have lot of SiteCollections and it happens only in this one. Fyi: We have 16GB RAM.

Any Ideas? Thanks alot..

System.out of memory exception in sql server 2005 repoting services



this is ram,

I am new to the reporting services,just one month back i joined in the company.there i got trained in ssrs 2005 .

nd my pblm is i inserted one of the csv file into the sql server 2005,it contains 102866 records,nd then i started generating summarized record through sql server 2005 reporting services.when i started generating the reports with few columns i didnt get any pblm,but when i started including more columns with aggregate functions i am getting the ecxeption called system out of memory exception.and by google search i found some solutions like enabling the AWE,but still i am getting the same exception

my server configuration is

64 bit windows server 2003,






How to find out how memory is allocated in SQL Server 2005/2008?


I want to find out how to get memory information from SQL Server using DMVs that will equal to or be very close to the memory shown in Mem Usage column of Windows Task Manager for sqlservr.exe.   I have tried to sum single_pages_kb, multi_pages_kb, and virtual_memory_committed_kb from sys.dm_os_memory_clerks but the combined total is still less than the Mem Usage from Windows Task Manager.  

SQL Server 2005 Try and Catch Exception Handling

I'm pretty excited to see that there is some real error handling for T-SQL code in SQL Server 2005. It's pretty painful to have your wonderfully architected .NET solution tainted by less-than-VBScript error handling for stored procedures in the database. The big difference being the addition of TRY..CATCH blocks. Let's take a look:

Configuring User Profiles in SharePoint Server 2010

Note: I've added the necessary links relating to SharePoint Server 2010 prerequisites, along with instructions for configuring the user profile synchronization service, at the end of this

sql server 2000 vs 2005


i would like to ask what the difference between sql server 2000 and 2005 

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend