March 2, 2012 at 8:49 am
Hi , all.
Please help me resolved problems with available AWE allocate for SQL.
SQL Server no used all available memory
We have Microsoft SQL Server 2008 Enterprise R2 (SP1) - 10.50.2772.0 (Intel X86) on Windows Server 2003 Enterprise R2 32Bit with those
hardware specification:
HP ProLiant DL380 G5
2x QuadCore Intel Xeon E5450, 3000 MHz
memory – 12 Gb (DDR2-667 Fully Buffered ECC DDR2 SDRAM)
Settings:
SQL:
Enable AWE Memory for SQL Server
Maximum server memory (in MB) - 11 000 Mb
Minimum server memory (in MB) - 11 000 Mb
WinServer2003R2 Ent
Enable the Lock Pages in Memory Option
In Task Manager available 12 Gb memory, but SQL used only 1,5-1,8 Gb memory.
Performance monitor - SQLServer:Memory Manager_Total Server Memory (KB) = 100%
sql query :
select cntr_value/1024 [memory, mb] from sys.sysperfinfo
where counter_name = 'Total Server Memory (KB)'
Resault:
memory, mb
1024
sql query :
SELECT * FROM sys.dm_os_performance_counters WHERE counter_name IN ('Target Server Memory (KB)','Total Server Memory (KB)','Logins/sec','Logouts/sec')
Resault:
object_name // counter_name// instance_name // cntr_value// cntr_type
SQLServer:General Statistics // Logins/sec // 1197 // 272696576
SQLServer:General Statistics // Logouts/sec // 1184 // 272696576
SQLServer:Memory Manager // Target Server Memory (KB) // 8323072 // 65792
SQLServer:Memory Manager // Total Server Memory (KB) // 1048576 // 65792
sql query :
DBCC MEMORYSTATUS
Resault:
Memory ManagerKB
VM Reserved1035824
VM Committed 52384
AWE Allocated 1048576
Reserved Memory1024
Reserved Memory In Use0
Thank you
March 2, 2012 at 8:52 am
March 2, 2012 at 10:19 am
This topic is closed.
Original topic http://www.sqlservercentral.com/Forums/Topic1260886-391-1.aspx
March 2, 2012 at 10:22 am
March 2, 2012 at 10:24 am
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply