Solved

SQL Server Windows 2003 AWE PAE 3GB

Posted on 2004-09-19
5
1,612 Views
Last Modified: 2012-05-05
I just upgraded the RAM in our SQL server from 2GB to 10GB and the SQL DB is only using 2.7GB of RAM.  I have read many places things like:

"AWE memory cannot be dynamically managed, like memory is normally managed in SQL Server. This means that SQL Server will automatically grab all the RAM it can when it starts (except for about 128MB, which is reserved for the operating system), but it will not release any of this RAM until SQL Server is turned off. "
http://www.sql-server-performance.com/awe_memory.asp

I set BOTH the /3GB and /PAE switch in my boot.ini file, and I enabled AWE in SQL server via the following commands:

SP_CONFIGURE 'show advanced options', 1
RECONFIGURE                              
GO

SP_CONFIGURE 'awe enabled', 1
RECONFIGURE
GO

SP_CONFIGURE 'max server memory', 9216
RECONFIGURE
GO

From what I had gathered I assumed the SQL server would use 9GB of RAM and leave 1GB for the system. I look in Perfmon->SQL Server:MemoryManager->Target Server Memory(KB) and it is saying roughly 2.7GB

What am I missing?
0
Comment
Question by:SpreadTheWord
  • 3
5 Comments
 
LVL 42

Expert Comment

by:EugeneZ
ID: 12098195
What edition of Windows 2003 do you have?
And what sql server 2k edition?


please read the Maximum Capacity Specifications for sql server 2000
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp

0
 

Author Comment

by:SpreadTheWord
ID: 12099104
SQL Server 2000 Ent. Ed.
Windows 2003 Ent Ed.

The 10 GB of RAM is seen by windows.
0
 

Author Comment

by:SpreadTheWord
ID: 12102617
BTW - the SQL server memory consumption climbed up to 2.7GB over time and then stuck there.
0
 
LVL 34

Accepted Solution

by:
arbert earned 500 total points
ID: 12109051
This is how SQL works (even with AWE).  Unless you put a minimum memory setting, SQL will grow to your maximum memory amount...
0
 

Author Comment

by:SpreadTheWord
ID: 12118265
arbert--

I am completely new to this stuff - so it seems normal for my memory usage to slowly climb to 2,792,540K exactly and then stay there?

-Sam
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL - SP needs a little help 9 25
Microsoft SQL Server 2016 Setup..error 7 34
Sql Query 4 19
MSDN Licensing query 5 59
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

862 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now