Q and A: x64 & AWE mechanismToday I received following question: Hello, We will be running Windows Server 2003 x64 with SQL Server 2005 x64. I would think AWE would not come into the picture in this scenario. I'm trying to find out more about SQL Server 2005 memory management onre: Q and A: x64 & AWE mechanism- November 13, 2006 If I understand you correctly, you are worried about SQL Server process's being paged out. TM 's "PF Usage" counter doesn't show that. In order to find out if SQL Server process is paged out, you need to look at TM's "Mem Usage" counters vs "VM Size". If "Mem Usage" counter is significantly lower than VM Size than a process is paged out. If you see that SQL Server process is paged out you can cope with that by enabling "locked pages in...http://blogs.msdn.com/slavao/archive/2005/11/15/493019.aspx#1070778 |