We are running SQL 2005 SP2 x64 on Windows 2003 SP2 X64. Server specs:Quad Core, each core runs at 2.33Ghz.4GB memoryOS and SQL on RAID 1 setTransaction log on RAID 1 setDatabases on RAID 5 set-The SQL service account is a domain account with the "lock pages in memory" rights. -The min memory use for sql server is 3000MBandÃÂ the maximum is 2147483647MB.ÃÂ
For whatever reason, the sqlsrvr.exe process uses much less physical memory than the Virtual Memory (VM). When I look at the Task manager, I see 230MB for Mem Usage column and 300MB for VM size column under full workload.ÃÂ ÃÂ WhyÃÂ is the SQL server process being paged out?ÃÂ ÃÂ I have 3GB for it to use. Should I be concerned about the my SQL server? I didn't configure the AWE as MS doesn't recomment using it on x64 bit systems.ÃÂ When I do "dbcc memorystatus", I get the following:
VM ReservedÃÂ 4269536VM CommittedÃÂ 196680AWE AllocatedÃÂ 0Reserved MemoryÃÂ 1024Reserved Memory In UseÃÂ 0
I thoughtÃÂ granting "lock pages in memory"ÃÂ rights to the sql service account automatically enables AWE in x64 bit version of SQL 2005 standard server.
View Complete Post