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

x
?
Solved

AWE and PAE

Posted on 2007-08-07
2
Medium Priority
?
1,791 Views
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)?
0
Comment
Question by:wbrooksjr
2 Comments
 
LVL 11

Accepted Solution

by:
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:
http://www.databasejournal.com/features/mssql/article.php/1437371
0
 
LVL 12

Expert Comment

by:patrikt
ID: 19652611
0

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