August 29, 2009 at 4:42 pm
We are currently using sql2000 on windows 2003 enterprise edition, we just increased our RAM from 4gig to 8gig,
after runing
SP_CONFIGURE 'awe enabled',1
reconfigure
Go
&
Sp_configure 'max server memory',6144
reconfigure
go
and
enabling /PAE switch in boot.ini
I noticed that viewing sqlsever memory from task manager is still reading about 1,711,428
what can i do to make use of at least 6gig of memory out of the 8 we now have.
August 30, 2009 at 12:13 am
What values do you see under Target Server Memory and Total Server memory counters under memory manage in performance monitor?
Task manager won't show the awe mapped memory in it.
MJ
August 30, 2009 at 6:17 am
Target server memory is 1668592
Total server memory is reading 11672
August 30, 2009 at 7:04 pm
the figures changed when some processes were running on sql . the system was idle when i got out the earlier data
New data
Target server memory is 1668680
Total server memory is reading 1668680
August 30, 2009 at 7:47 pm
It sounds like AWE hasn't kicked in. Have a look in the ERRORLOG to see if there's an "AWE Enabled" message near the start.
You've mentioned configuring AWE Enabled with sp_configure, and turning on /PAE in boot.ini, but you haven't mentioned if you granted the account that the SQL Server process runs under the "Lock Pages In Memory" permission.
The other option that could stop AWE from being enabled is if some other process is stealing most of the physical memory in the machine before SQL Server starts.
August 31, 2009 at 12:01 pm
Clarification please ...
You state that you are using Windows Server 2003 Enterprise but only SQL 2000.
Is SQL 2000 'Standard' or 'Enterprise' ?
If it is 'Standard', well, the extra memory does not help since it cannot address it.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 31, 2009 at 1:04 pm
If it is 'Standard', well, the extra memory does not help since it cannot address it.
my understanding is that standard would be able to address that extra memory, but would not be able to lock it in case OS starts to page out memory held by programs.
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 31, 2009 at 1:31 pm
Sorry 2 Gb is all you can use in SQL Server 2000 Standard
here are some useful links:
http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx
http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1157395,00.html
http://support.microsoft.com/kb/274750
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply