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- December 12, 2005 I have 2003 x64 and SQL 2005 x64 set up on a AMD64 processor. Physical mem is 8 GB and Pagefile is 12. I have set min SQL memory to 6 GB and Max to 7GB. When doing index rebuilds I can see the mem usage to up to 7 GB but it alway drops under the minimum threshhold. I have 'Lock Pages in Memory' giving to the SQL Account. Is this by design Why would it drop below the minimum thresholdhttp://blogs.msdn.com/slavao/archive/2005/11/15/493019.aspx#502744 |