[THIN] Re: OT: SQL 2000 on Win2K3 Server, /PAE /3GB again

  • From: Henry Sieff <hsieff@xxxxxxxxxxxx>
  • To: "'thin@xxxxxxxxxxxxx'" <thin@xxxxxxxxxxxxx>
  • Date: Tue, 20 Apr 2004 14:33:18 -0500

You misunderstood me: w/o the /3GB switch it'll cap at 2 GB on a 4 GB box,
was what I meant. The OS will still use the additional memory, just not for
SQL.



> -----Original Message-----
> From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx]On
> Behalf Of Brian Madden
> Sent: Tuesday, April 20, 2004 1:22 PM
> To: thin@xxxxxxxxxxxxx
> Subject: [THIN] Re: OT: SQL 2000 on Win2K3 Server, /PAE /3GB again
> 
> 
> I don't agree with the statement that SQL will cap at 2GB on 
> a 4GB box.
> Using the /3GB switch will allow the SQL service to address 3GB of RAM
> instead of 2GB.
> 
> I do believe you need to be using the Enterprise Edition of SQL for it
> to access more than 2GB of RAM, though.
> 
> Brian
> 
> Brian Madden
> brian@xxxxxxxxxxxxxxx
> +1.202.302.3657
> Visit www.brianmadden.com for in-depth Citrix, Terminal Server, and
> server-based computing news and analysis, white papers, downloadable
> videos, and product reviews.
> 
> -----Original Message-----
> From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On
> Behalf Of Henry Sieff
> Sent: Tuesday, April 20, 2004 11:57 AM
> To: 'thin@xxxxxxxxxxxxx'
> Subject: [THIN] Re: OT: SQL 2000 on Win2K3 Server, /PAE /3GB again
> 
> It'll 'use' it, but it won't use it for SQL or exchange - 
> that'll cap at
> 2
> GB on a 4 GB box. I do the same thing; pretty much the only servers I
> don't
> do that with are Citrix and file/print. Also played around with AWE on
> SQL,
> but it actually didn't work out for me (this was early on in SQL2K,
> though,
> so maybe I will revisit the issue).
> 
> Henry
> 
> > -----Original Message-----
> > From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx]On
> > Behalf Of Evan Mann
> > Sent: Tuesday, April 20, 2004 11:53 AM
> > To: thin@xxxxxxxxxxxxx
> > Subject: [THIN] Re: OT: SQL 2000 on Win2K3 Server, /PAE /3GB again
> >=20
> >=20
> > I opted for /3GB on my SQL Boxes and Exchange Boxes (both 4GB=20
> > of RAM and
> > dedicated to their respective apps).  I wasn't sure if the system
> > actually used the 4GB w/o the /3GB switch, but the 3 GB to=20
> > user mode is
> > definitely what I want.
> >=20
> > Thanks,
> >=20
> > Evan=3D20
> >=20
> > -----Original Message-----
> > From: thin-bounce@xxxxxxxxxxxxx 
> [mailto:thin-bounce@xxxxxxxxxxxxx] On
> > Behalf Of Brian Madden
> > Sent: Tuesday, April 20, 2004 12:45 PM
> > To: thin@xxxxxxxxxxxxx
> > Subject: [THIN] Re: OT: SQL 2000 on Win2K3 Server, /PAE /3GB again
> >=20
> > You do not need PAE.
> >=20
> > By default, the 4GB of RAM is split 50/50 between the 
> kernel and your
> > applications (i.e. SQL). You would probably be well served to=20
> > use /3GB,
> > because that will give you 3GB for the apps (SQL) and leave=20
> > only 1GB for
> > the kernel. If this is a dedicated SQL server, 1GB should be=20
> > plenty for
> > the SQL server.
> >=20
> > (If this is also, for example, a busy file server or DC, I probably
> > wouldn't mess with /3GB and leave the memory split 50/50.
> >=20
> > Brian
> >=20
> > Brian Madden
> > brian@xxxxxxxxxxxxxxx
> > +1.202.302.3657
> > Visit www.brianmadden.com for in-depth Citrix, Terminal Server, and
> > server-based computing news and analysis, white papers, downloadable
> > videos, and product reviews.
> >=20
> > -----Original Message-----
> > From: thin-bounce@xxxxxxxxxxxxx 
> [mailto:thin-bounce@xxxxxxxxxxxxx] On
> > Behalf Of Henry Sieff
> > Sent: Tuesday, April 20, 2004 10:48 AM
> > To: 'thin@xxxxxxxxxxxxx'
> > Subject: [THIN] Re: OT: SQL 2000 on Win2K3 Server, /PAE /3GB again
> >=20
> > The 3GB switch operates as before. Not sure about the PAE.=20
> > You also have
> > more flexibility ib the memory tuning.
> >=20
> > http://support.microsoft.com/default.aspx?scid=3D3D3Dkb;en-us;31
> > 6739&Produc=3D
> > t
> > =3D3D3D=3D3D
> > w
> > insv
> > r2003
> >=20
> > > -----Original Message-----
> > > From: thin-bounce@xxxxxxxxxxxxx 
> [mailto:thin-bounce@xxxxxxxxxxxxx]On
> > > Behalf Of Evan Mann
> > > Sent: Tuesday, April 20, 2004 10:41 AM
> > > To: thin@xxxxxxxxxxxxx
> > > Subject: [THIN] OT: SQL 2000 on Win2K3 Server, /PAE /3GB=20
> > again =3D3D20 =3D
> > =3D3D20
> >=20
> > >I have SQL 2000 SP3a Enterprise on Windows 2003 Enterprise=20
> > server with
> >=20
> > >4GB of ram.
> > > Do I need either the /3GB or the /PAE switch to use the 
> 4GB of RAM?
> > >=3D3D20
> > >=3D3D20
> > >=3D3D20
> > > ********************************************************
> > > This week's sponsor - Neoware Thin Clients  Neoware makes=20
> > computing=3D20
> > >open, secure, reliable,=3D3D20  affordable, manageable and=3D20
> > >obsolete-free.=3D3D20  Starting at $199!=3D3D20  =3D
> > http://www.neoware.com=3D3D20
> > > **********************************************************
> > > Useful Thin Client Computing Links are available at:
> > > http://thin.net/links.cfm
> > > ***********************************************************
> > > For Archives, to Unsubscribe, Subscribe or=3D3D20  set 
> Digest or =3D
> > Vacation=3D20
> > >mode use the below link:
> > > http://thin.net/citrixlist.cfm
> > >=3D3D20
> > ********************************************************
> > This week's sponsor - Neoware Thin Clients Neoware makes=20
> > computing open,
> > secure, reliable,=3D3D20 affordable, manageable and =
> obsolete-free.=3D3D20
> > Starting at $199!=3D3D20 http://www.neoware.com=3D3D20
> > **********************************************************
> > Useful Thin Client Computing Links are available at:
> > http://thin.net/links.cfm
> > ***********************************************************
> > For Archives, to Unsubscribe, Subscribe or=3D3D20 set Digest or =
> Vacation
> > mode use the below link:
> > http://thin.net/citrixlist.cfm
> >=20
> > ********************************************************
> > This week's sponsor - Neoware Thin Clients Neoware makes=20
> > computing open,
> > secure, reliable, affordable, manageable and obsolete-free.=3D20
> > Starting at $199!=3D20
> > http://www.neoware.com
> > **********************************************************
> > Useful Thin Client Computing Links are available at:
> > http://thin.net/links.cfm
> > ***********************************************************
> > For Archives, to Unsubscribe, Subscribe or set Digest or 
> Vacation mode
> > use the below link:
> > http://thin.net/citrixlist.cfm
> >=20
> >=20
> > ********************************************************
> > This week's sponsor - Neoware Thin Clients
> > Neoware makes computing open, secure, reliable,=20
> > affordable, manageable and obsolete-free.=20
> > Starting at $199!=20
> > http://www.neoware.com=20
> > **********************************************************
> > Useful Thin Client Computing Links are available at:
> > http://thin.net/links.cfm
> > ***********************************************************
> > For Archives, to Unsubscribe, Subscribe or=20
> > set Digest or Vacation mode use the below link:
> > http://thin.net/citrixlist.cfm
> >=20
> ********************************************************
> This week's sponsor - Neoware Thin Clients
> Neoware makes computing open, secure, reliable,=20
> affordable, manageable and obsolete-free.=20
> Starting at $199!=20
> http://www.neoware.com=20
> **********************************************************
> Useful Thin Client Computing Links are available at:
> http://thin.net/links.cfm
> ***********************************************************
> For Archives, to Unsubscribe, Subscribe or=20
> set Digest or Vacation mode use the below link:
> http://thin.net/citrixlist.cfm
> 
> ********************************************************
> This week's sponsor - Neoware Thin Clients
> Neoware makes computing open, secure, reliable, 
> affordable, manageable and obsolete-free. 
> Starting at $199! 
> http://www.neoware.com 
> **********************************************************
> Useful Thin Client Computing Links are available at:
> http://thin.net/links.cfm
> ***********************************************************
> For Archives, to Unsubscribe, Subscribe or 
> set Digest or Vacation mode use the below link:
> http://thin.net/citrixlist.cfm
> 
********************************************************
This week's sponsor - Neoware Thin Clients
Neoware makes computing open, secure, reliable, 
affordable, manageable and obsolete-free. 
Starting at $199! 
http://www.neoware.com 
**********************************************************
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or 
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm

Other related posts: