Can you tell us what the following counters on the system is.
Counter: PageFile Instance: %Useage%, %Useage Peak% DO not believe what you are seeing in task manager. Z Edward E. Ziots CISSP, Network +, Security + Network Engineer Lifespan Organization Email:[email protected] Cell:401-639-3505 From: G.Waleed Kavalec [mailto:[email protected]] Sent: Wednesday, March 16, 2011 4:50 PM To: NT System Admin Issues Subject: Re: Getting SQL 2008 to use 16GB RAM Then I really don't understand why we are paging at all. On Wed, Mar 16, 2011 at 3:48 PM, Kramer, Jack <[email protected]> wrote: 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]> Reply-To: NT System Admin Issues <[email protected]> Date: Wed, 16 Mar 2011 16:07:37 -0400 To: NT System Admin Issues <[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] 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 -- __________________ 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] 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
