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

  • From: "Evan Mann" <emann@xxxxxxxxxxxxxxxxxxxxx>
  • To: <thin@xxxxxxxxxxxxx>
  • Date: Tue, 20 Apr 2004 12:52:57 -0400

I opted for /3GB on my SQL Boxes and Exchange Boxes (both 4GB 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 user mode is
definitely what I want.

Thanks,

Evan=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

You do not need PAE.

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 use /3GB,
because that will give you 3GB for the apps (SQL) and leave only 1GB for
the kernel. If this is a dedicated SQL server, 1GB should be plenty for
the SQL server.

(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.

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 10:48 AM
To: 'thin@xxxxxxxxxxxxx'
Subject: [THIN] Re: OT: SQL 2000 on Win2K3 Server, /PAE /3GB again

The 3GB switch operates as before. Not sure about the PAE. You also have
more flexibility ib the memory tuning.

http://support.microsoft.com/default.aspx?scid=3D3Dkb;en-us;316739&Produc=
t
=3D3D=3D
w
insv
r2003

> -----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 again =3D20 =
=3D20

>I have SQL 2000 SP3a Enterprise on Windows 2003 Enterprise server with

>4GB of ram.
> Do I need either the /3GB or the /PAE switch to use the 4GB of RAM?
>=3D20
>=3D20
>=3D20
> ********************************************************
> This week's sponsor - Neoware Thin Clients  Neoware makes computing=20
>open, secure, reliable,=3D20  affordable, manageable and=20
>obsolete-free.=3D20  Starting at $199!=3D20  =
http://www.neoware.com=3D20
> **********************************************************
> Useful Thin Client Computing Links are available at:
> http://thin.net/links.cfm
> ***********************************************************
> For Archives, to Unsubscribe, Subscribe or=3D20  set Digest or =
Vacation=20
>mode use the below link:
> http://thin.net/citrixlist.cfm
>=3D20
********************************************************
This week's sponsor - Neoware Thin Clients Neoware makes computing open,
secure, reliable,=3D20 affordable, manageable and obsolete-free.=3D20
Starting at $199!=3D20 http://www.neoware.com=3D20
**********************************************************
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or=3D20 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.=20
Starting at $199!=20
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: