September 26, 2008 at 3:23 am
Please help.
We are using SQL 2005 Enterprise edition, running on Windows 2003 Server, also Enterprise edition.
Total RAM is 12Gig
1. I have given an administrator type user access to "Lock Pages in Memory" option.
2. I have started the SQL service with this userid.
3. I configured SQL to enable AWE running the following script against the master database:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
4. I restarted the SQL Server Box.
5. I configured the Memory running the following script against the master database
sp_configure 'min server memory', 1024
RECONFIGURE
GO
sp_configure 'max server memory', 11264
RECONFIGURE
GO
6. I restarted the SQL Service
There are 40 users retrieving and updating data in SQL currently, but task manager informs me that the SQL service is only using 150MB of memory!!!
What am i doing wrong?
September 26, 2008 at 4:04 am
AWE memory usage doesn't show up in task manager.
Use DBCC MemoryStatus, or the perfmon counters 'Target Server Memory (KB)' and 'Total Server Memory (KB) to see how much is actually being used.
September 26, 2008 at 4:25 am
Thanks a million. Yeah, it's cookin' all right!!!:D
September 26, 2008 at 12:28 pm
In 2005 you have an advantage of checking it through DMVs too:
Query sys.dm_os_memory_clerks
This DMV will help to know how much memory SQL Server has allocated through AWE.
SELECT
SUM(awe_allocated_kb) / 1024 as [AWE allocated, Mb]
FROM sys.dm_os_memory_clerks
HTH
MJ
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply