A 32-bit application will consume a max of 3GB of ram per process. PAE will allow multiple apps to exist within a larger-than-3GB space without paging; however your individual programs are still memory limited.
---- Jack Kramer Computer Systems Specialist University Relations, Michigan State University w: 517-884-1231 / c: 248-635-4955 From: "G.Waleed Kavalec" <[email protected]<mailto:[email protected]>> Reply-To: NT System Admin Issues <[email protected]<mailto:[email protected]>> Date: Wed, 16 Mar 2011 16:07:37 -0400 To: NT System Admin Issues <[email protected]<mailto:[email protected]>> Subject: Getting SQL 2008 to use 16GB RAM Due to a third party app we have some servers running W2K8 32-bit SQL 2008 on said machines does not seem to want to use the full 16GB The vendor has NO plans to upgrade their product. (yeah I'm looking at YOU Sterling Software) I have PAE and AWE turned on, and the machine is still using 3GB of the page file and running slow. Any suggestions? -- __________________ Gregory Waleed Kavalec --------------------------------------------- Fajr... It's the Believers' cup of coffee with extra caffeine. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected]<mailto:[email protected]> with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
