We are running SQL 2005 SP2 x64 on Windows 2003 SP2 X64.
Server specs:
Quad Core, each core runs at 2.33Ghz.
4GB memory
OS and SQL on RAID 1 set
Transaction log on RAID 1 set
Databases 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 3GB
For whatever reason, the sqlsrvr.exe process uses less physical memory and use more Virtual Memory (VM). When I look at the Task manager (TM), I see 157MB for Mem Usage column and 238MB for VM size column. Why would the SQL server process is being paged out? I have 3GB for it to use. Should be concerned about the my SQL server?
I didn't configure the AWE as MS doesn't recomment using it on x64 bit systems.
Thanks
Server specs:
Quad Core, each core runs at 2.33Ghz.
4GB memory
OS and SQL on RAID 1 set
Transaction log on RAID 1 set
Databases 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 3GB
For whatever reason, the sqlsrvr.exe process uses less physical memory and use more Virtual Memory (VM). When I look at the Task manager (TM), I see 157MB for Mem Usage column and 238MB for VM size column. Why would the SQL server process is being paged out? I have 3GB for it to use. Should be concerned about the my SQL server?
I didn't configure the AWE as MS doesn't recomment using it on x64 bit systems.
Thanks