RE: Getting SQL 2008 to use 16GB RAM

2011-03-22 Thread Ziots, Edward
:24 PM To: NT System Admin Issues Subject: Re: Getting SQL 2008 to use 16GB RAM AWE is turned on in this case. Ed - Still getting the Counters you asked about. Ken - we are going to try the two-server trick. On Mon, Mar 21, 2011 at 1:10 PM, Brad DeHart wrote: Through SQL Server Management

Re: Getting SQL 2008 to use 16GB RAM

2011-03-22 Thread G.Waleed Kavalec
il.com] > Sent: Saturday, March 19, 2011 6:25 AM > To: NT System Admin Issues > Subject: Re: Getting SQL 2008 to use 16GB RAM > > On Sat, Mar 19, 2011 at 1:50 AM, Ken Schaefer > wrote: > > AWE just lets the application use different "chunks" of 4GB address >

RE: Getting SQL 2008 to use 16GB RAM

2011-03-21 Thread Brad DeHart
. Thanks, Brad -Original Message- From: Ben Scott [mailto:mailvor...@gmail.com] Sent: Saturday, March 19, 2011 6:25 AM To: NT System Admin Issues Subject: Re: Getting SQL 2008 to use 16GB RAM On Sat, Mar 19, 2011 at 1:50 AM, Ken Schaefer wrote: > AWE just lets the application use differe

Re: Getting SQL 2008 to use 16GB RAM

2011-03-19 Thread Ben Scott
On Sat, Mar 19, 2011 at 1:50 AM, Ken Schaefer wrote: > AWE just lets the application use different “chunks” of 4GB address space. Something I've been wondering about: Does one have to do anything special to get MS-SQL 2008 to actually use AWE? Is any tuning involved? (I'm not a database guy

RE: Getting SQL 2008 to use 16GB RAM

2011-03-18 Thread Ken Schaefer
32bit app server to connect to the remote x64 SQL Server. Cheers Ken From: G.Waleed Kavalec [mailto:kava...@gmail.com] Sent: Saturday, 19 March 2011 5:42 AM To: NT System Admin Issues Subject: Re: Getting SQL 2008 to use 16GB RAM It tells me 2004188 Which makes NO sense. AWE is on. /3GB is on.

RE: Getting SQL 2008 to use 16GB RAM

2011-03-18 Thread Ziots, Edward
+, Security + Network Engineer Lifespan Organization Email:ezi...@lifespan.org Cell:401-639-3505 From: G.Waleed Kavalec [mailto:kava...@gmail.com] Sent: Friday, March 18, 2011 5:42 PM To: NT System Admin Issues Subject: Re: Getting SQL 2008 to use 16GB RAM It tells me 2004188 Which

Re: Getting SQL 2008 to use 16GB RAM

2011-03-18 Thread G.Waleed Kavalec
ization > > Email:ezi...@lifespan.org > > Cell:401-639-3505 > > > > *From:* G.Waleed Kavalec [mailto:kava...@gmail.com] > *Sent:* Wednesday, March 16, 2011 4:08 PM > > *To:* NT System Admin Issues > *Subject:* Getting SQL 2008 to use 16GB RAM > > > > Due to a thi

RE: Getting SQL 2008 to use 16GB RAM

2011-03-17 Thread Ziots, Edward
...@lifespan.org Cell:401-639-3505 From: G.Waleed Kavalec [mailto:kava...@gmail.com] 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, K

RE: Getting SQL 2008 to use 16GB RAM

2011-03-17 Thread Ziots, Edward
Email:ezi...@lifespan.org Cell:401-639-3505 From: G.Waleed Kavalec [mailto:kava...@gmail.com] Sent: Wednesday, March 16, 2011 4:08 PM To: NT System Admin Issues 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 machine

Re: Getting SQL 2008 to use 16GB RAM

2011-03-16 Thread Ben Scott
On Wed, Mar 16, 2011 at 4:07 PM, G.Waleed Kavalec wrote: > 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 Okay, this gets complicated. Some 'splaining is needed: On any 32-bit x86 system, each process

Re: Getting SQL 2008 to use 16GB RAM

2011-03-16 Thread Andrew S. Baker
: <248-635-4955>248-635-4955 >> >> From: "G.Waleed Kavalec" >> Reply-To: NT System Admin Issues >> Date: Wed, 16 Mar 2011 16:07:37 -0400 >> To: NT System Admin Issues >> Subject: Getting SQL 2008 to use 16GB RAM >> >> Due to a thir

Re: Getting SQL 2008 to use 16GB RAM

2011-03-16 Thread G.Waleed Kavalec
Wed, 16 Mar 2011 16:07:37 -0400 > To: NT System Admin Issues > 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 N

Re: Getting SQL 2008 to use 16GB RAM

2011-03-16 Thread G.Waleed Kavalec
We are Enterprise. 2008 R2 is only 64bit. On Wed, Mar 16, 2011 at 3:25 PM, Jeff Bunting wrote: > Think you need windows enterprise to support more than 4GB. Or R2 > > > On Wed, Mar 16, 2011 at 4:07 PM, G.Waleed Kavalec wrote: > >> Due to a third party app we have some servers running W2K8 *32-

Re: Getting SQL 2008 to use 16GB RAM

2011-03-16 Thread Kramer, Jack
software.com>> 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)

RE: Getting SQL 2008 to use 16GB RAM

2011-03-16 Thread Mayo, Bill
Not if you are 64-bit, though, right? From: Jeff Bunting [mailto:bunting.j...@gmail.com] Sent: Wednesday, March 16, 2011 4:25 PM To: NT System Admin Issues Subject: Re: Getting SQL 2008 to use 16GB RAM Think you need windows enterprise to support more than 4GB. Or R2 On Wed, Mar 16

Re: Getting SQL 2008 to use 16GB RAM

2011-03-16 Thread Jeff Bunting
Think you need windows enterprise to support more than 4GB. Or R2 On Wed, Mar 16, 2011 at 4:07 PM, G.Waleed Kavalec wrote: > 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 t

Getting SQL 2008 to use 16GB RAM

2011-03-16 Thread G.Waleed Kavalec
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