Wednesday, March 28, 2012

how mucn RAM can SQL on Win2K3 EE support ?

How much RAM can SQL 2K EE on Win2K3 support ?This is a multi-part message in MIME format.
--000706020907070307060105
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
64GB
See http://www.microsoft.com/sql/evaluation/overview/default.mspx
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Jim wrote:
>How much RAM can SQL 2K EE on Win2K3 support ?
>
>
--000706020907070307060105
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>64GB<br>
<br>
See <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.microsoft.com/sql/evaluation/overview/default.mspx</a><br>">http://www.microsoft.com/sql/evaluation/overview/default.mspx">http://www.microsoft.com/sql/evaluation/overview/default.mspx</a><br>
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
Jim wrote:
<blockquote cite="midOWFUk3NZFHA.3648@.TK2MSFTNGP14.phx.gbl" type="cite">
<pre wrap="">How much RAM can SQL 2K EE on Win2K3 support ?
</pre>
</blockquote>
</body>
</html>
--000706020907070307060105--|||This is a multi-part message in MIME format.
--=_NextPart_000_0014_01C564F6.9A8B9AE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Yes. 64GB using PAE and AWE. If lot of memory is what you're after and =you haven't purchased yet, use 64 bit hardware and SQL Server instead. =Your limit then will be 512GB and all of it will be directly accessible. = Anyone using more than about 16GB of RAM should consider moving to 64 =bit. I mention 16GB as the cutoff because that's the limit of using the =/3GB switch.
Danny
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message =news:ubcnS$NZFHA.1040@.TK2MSFTNGP10.phx.gbl...
64GB
See http://www.microsoft.com/sql/evaluation/overview/default.mspx
--
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W =http://www.mallesons.com=20
Jim wrote: How much RAM can SQL 2K EE on Win2K3 support ?
--=_NextPart_000_0014_01C564F6.9A8B9AE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Yes. 64GB using PAE and AWE. If =lot of memory is what you're after and you haven't purchased yet, use 64 bit hardware =and SQL Server instead. Your limit then will be 512GB and all of it will =be directly accessible. Anyone using more than about 16GB of RAM =should consider moving to 64 bit. I mention 16GB as the cutoff because =that's the limit of using the /3GB switch.
Danny
"Mike Hodgson" wrote in message news:ubcnS$NZFHA.1040=@.TK2MSFTNGP10.phx.gbl...64GBSee http://www.microsoft.com/sql/evaluation/overview/default.mspx">ht=tp://www.microsoft.com/sql/evaluation/overview/default.mspx
--mike =hodgson | database =administrator | mallesons =stephen jaquesT +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907E mailto:mike.hodgson@.mal=lesons.nospam.com | W http://www.mallesons.com Jim wrote: How much RAM can SQL 2K EE on Win2K3 =support ?


--=_NextPart_000_0014_01C564F6.9A8B9AE0--|||Read it again guys; there are caveats. It is 32 GB on the 32-bit version
and 64 GB on the 64-bit version. On Datacenter Edition, it is 64 GB and 512
GB for 32 and 64-bit, respectively.
Well, that's how it use to read, now it looks like both the EE and DE at
64-bit support up to 1 TB of ram.
http://www.microsoft.com/windowsserver2003/evaluation/features/compareeditions.mspx
Sincerely,
Anthony Thomas
"Danny" <someone@.nowhere.com> wrote in message
news:V5Fme.6749$m%3.1993@.trnddc02...
Yes. 64GB using PAE and AWE. If lot of memory is what you're after and you
haven't purchased yet, use 64 bit hardware and SQL Server instead. Your
limit then will be 512GB and all of it will be directly accessible. Anyone
using more than about 16GB of RAM should consider moving to 64 bit. I
mention 16GB as the cutoff because that's the limit of using the /3GB
switch.
Danny
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message
news:ubcnS$NZFHA.1040@.TK2MSFTNGP10.phx.gbl...
64GB
See http://www.microsoft.com/sql/evaluation/overview/default.mspx
--
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
Jim wrote:
How much RAM can SQL 2K EE on Win2K3 support ?sql

No comments:

Post a Comment