[THIN] Re: SV: Re: OT: SQL 2000 on Win2K3 Server, /PAE /3GB again
- From: "Evan Mann" <emann@xxxxxxxxxxxxxxxxxxxxx>
- To: <thin@xxxxxxxxxxxxx>
- Date: Wed, 21 Apr 2004 08:49:38 -0400
I'm glad Microsoft doesn't try to get you for 2 processors licenses for
every single HT enabled processor you have. 2 dual Xeon boxes is bad
enough to licenses, but if you had to pay for 8 CPUs total, ouch!
=20
-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On
Behalf Of Svein Arild Haugum
Sent: Wednesday, April 21, 2004 5:39 AM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] SV: Re: OT: SQL 2000 on Win2K3 Server, /PAE /3GB again
Yes, its true, you need SQL Enterprise edition to use more than 2GB for
=3D SQL. And that cost like hell.
Mvh
Svein Arild
-----Opprinnelig melding-----
Fra: Brian Madden [mailto:brian@xxxxxxxxxxxxxxx]
Sendt: 20. april 2004 20:22
Til: thin@xxxxxxxxxxxxx
Emne: [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
>=3D3D20 =3D3D20 I opted for /3GB on my SQL Boxes and Exchange Boxes =
(both=20
>4GB=3D3D20 of RAM and dedicated to their respective apps). I wasn't=20
>sure if the system actually used the 4GB w/o the /3GB switch, but the=20
>3 GB to=3D3D20 user mode is definitely what I want.
>=3D3D20
> Thanks,
>=3D3D20
> Evan=3D3D3D20
>=3D3D20
> -----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
>=3D3D20 You do not need PAE.
>=3D3D20
> 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=3D3D20 =
use
>/3GB, because that will give you 3GB for the apps (SQL) and =
leave=3D3D20
>only 1GB for the kernel. If this is a dedicated SQL server, 1GB should
>be=3D3D20 plenty for the SQL server.
>=3D3D20
> (If this is also, for example, a busy file server or DC, I probably =20
>wouldn't mess with /3GB and leave the memory split 50/50.
>=3D3D20
> Brian
>=3D3D20
> Brian Madden
> brian@xxxxxxxxxxxxxxx
> +1.202.302.3657
> Visit www.brianmadden.com for in-depth Citrix, Terminal Server, and =20
>server-based computing news and analysis, white papers, downloadable =20
>videos, and product reviews.
>=3D3D20
> -----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
>=3D3D20 The 3GB switch operates as before. Not sure about the =
PAE.=3D3D20
>You also have more flexibility ib the memory tuning.
>=3D3D20
> http://support.microsoft.com/default.aspx?scid=3D3D3D3D3Dkb;en-us;31
> 6739&Produc=3D3D3D
> t
> =3D3D3D3D3D=3D3D3D3D
> w
> insv
> r2003
>=3D3D20
> > -----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=3D3D20
> again =3D3D3D3D20 =3D3D3D
> =3D3D3D3D20
>=3D3D20
> >I have SQL 2000 SP3a Enterprise on Windows 2003 Enterprise=3D3D20
> server with
>=3D3D20
> >4GB of ram.
> > Do I need either the /3GB or the /PAE switch to use the 4GB of RAM?
> >=3D3D3D3D20
> >=3D3D3D3D20
> >=3D3D3D3D20
> > ********************************************************
> > This week's sponsor - Neoware Thin Clients Neoware makes=3D3D20
> computing=3D3D3D20
> >open, secure, reliable,=3D3D3D3D20 affordable, manageable =
and=3D3D3D20=20
> >obsolete-free.=3D3D3D3D20 Starting at $199!=3D3D3D3D20 =3D3D3D
> http://www.neoware.com=3D3D3D3D20
> > **********************************************************
> > Useful Thin Client Computing Links are available at:
> > http://thin.net/links.cfm
> > ***********************************************************
> > For Archives, to Unsubscribe, Subscribe or=3D3D3D3D20 set Digest or =
=3D
=3D3D3D
> Vacation=3D3D3D20
> >mode use the below link:
> > http://thin.net/citrixlist.cfm
> >=3D3D3D3D20
> ********************************************************
> This week's sponsor - Neoware Thin Clients Neoware makes=3D3D20=20
> computing open, secure, reliable,=3D3D3D3D20 affordable, manageable =
and=20
> =3D3D
obsolete-free.=3D3D3D3D20
> Starting at $199!=3D3D3D3D20 http://www.neoware.com=3D3D3D3D20
> **********************************************************
> Useful Thin Client Computing Links are available at:
> http://thin.net/links.cfm
> ***********************************************************
> For Archives, to Unsubscribe, Subscribe or=3D3D3D3D20 set Digest or =
=3D3D
Vacation
> mode use the below link:
> http://thin.net/citrixlist.cfm
>=3D3D20
> ********************************************************
> This week's sponsor - Neoware Thin Clients Neoware makes=3D3D20 =20
>computing open, secure, reliable, affordable, manageable and=20
>obsolete-free.=3D3D3D20 Starting at $199!=3D3D3D20 =
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
>=3D3D20
>=3D3D20
> ********************************************************
> This week's sponsor - Neoware Thin Clients Neoware makes computing=20
>open, secure, reliable,=3D3D20 affordable, manageable and=20
>obsolete-free.=3D3D20 Starting at $199!=3D3D20 =20
>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=20
>Vacation mode use the below link:
> http://thin.net/citrixlist.cfm
>=3D3D20
********************************************************
This week's sponsor - Neoware Thin Clients Neoware makes 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
********************************************************
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:
