Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium



Posted on 2007-08-07
Medium Priority
Last Modified: 2013-11-05
I am running into problems where it appears that some process in SQL is eating a large chunk of memory, tying up my server.  I am running Windows 2003 R2 Standard (32-bit) and SQL 2005 Standard.  All with default settings (no PAE and AWE is not running on SQL).  My server has 4GB of RAM.

1)  Based on my OS and 32-bit version, I'm assuming I don't need to enable PAE.  Am I right?
2)  Does it make sense to enable AWE in SQL with this hardware config (4GB RAM)?
Question by:wbrooksjr
LVL 11

Accepted Solution

Sven earned 500 total points
ID: 19652017
1) Yes, you are right. PAE will only enable access to memory above 4 GB. But it will not give you more than 2 GB of RAM per process.

2) It would make sense if you need more than 2 GB of RAM for SQL Server. AWE will enable 3 GB of RAM per process. We activated it because of some memory problems and it solved them. Remember that the system should get enough memory. If you have 3 GB only, AWE should not be enabled. In your configuration it should be save to enable AWE.

Here are some more things to think about:
LVL 12

Expert Comment

ID: 19652611

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question