I have a sql 2005 SP3 box (OS W2K3 ENT SP2) hosting SharePoint Farm 2007 has physical memory of 6GB. Memory utilisation is constantly hitting 94%. I have enabled AWE and set min memory to 128 MB and Max mem to 4096 MB (screen shot attached).
Please advise how to go about reducing memory contention?
Thanks and Regards