What is the max memory (RAM) SQL Server 2000 SP3 can use
when installed on a Windows 2K3 Enterprise Edition with 16
Gb of memory?
On the properties of the server it only displays 3,5 Gb!!
Thanks
CaioStandard edition can use 2GB. Enterprise Edition can use up to 64GB, depending on the limitations of
the OS. For SQL Server to use more than 2GB (or 3GB, depending on whether boot.ini has the /3GB
switch), then you need to PAE and AWE memory addressing.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Caio" <anonymous@.discussions.microsoft.com> wrote in message
news:030601c398ea$18301780$a601280a@.phx.gbl...
> What is the max memory (RAM) SQL Server 2000 SP3 can use
> when installed on a Windows 2K3 Enterprise Edition with 16
> Gb of memory?
> On the properties of the server it only displays 3,5 Gb!!
> Thanks
> Caio|||Hi Caio,
If you want to use large memory configurations with SQL(>3gb) you will need
to use /PAE in the boot.ini file, and enable AWE within SQL, then set a Max
Server Memory to the memory that you want to allocate to SQL, but there are
some things to note
1) You could also use /3GB to limit the kernel space to 1GB and give you an
extra 1GB, but this only works up to 16GB, your server is right on that
limit and running with these settings can cause problems as you aproach
this limit. So I would let the kernel have its 2GB
2) AWE is not dynamic so SQL will take that memory and it won't give it
back, if AWE is not used SQL will release memory as the OS comes under
pressure. So if you have other applications running on the server you may
want to set the max server memory a little lower.
3) If this server is clustered how many instances of SQL are running ?
Hope this helps
Regards
Clive Challinor [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.|||I am confused: why do I need the PAE switch on if Windows
2003 Enterprise Edition by default recognize 32GB of RAM?
Shouldn't SQL Server Enterprise Edition automatically
recognize all available memory?
Thanks
Caio
>--Original Message--
>Standard edition can use 2GB. Enterprise Edition can use
up to 64GB, depending on the limitations of
>the OS. For SQL Server to use more than 2GB (or 3GB,
depending on whether boot.ini has the /3GB
>switch), then you need to PAE and AWE memory addressing.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Caio" <anonymous@.discussions.microsoft.com> wrote in
message
>news:030601c398ea$18301780$a601280a@.phx.gbl...
>> What is the max memory (RAM) SQL Server 2000 SP3 can use
>> when installed on a Windows 2K3 Enterprise Edition with
16
>> Gb of memory?
>> On the properties of the server it only displays 3,5
Gb!!
>> Thanks
>> Caio
>
>.
>|||Hi Clive, thanks for the reply.
To answer your question: this server is not clustered so
we only have one instance of SQL Server.
Why do I need the PAE switch if Win 2003 Enterprise
Edition by default recognizes up to 32 GB of memory?
Shouldn't SQL SErver automatically see that the operating
system can provide more memory than the 2 or 3 GB?
Thanks again
Caio
>--Original Message--
>Hi Caio,
>If you want to use large memory configurations with SQL
(>3gb) you will need
>to use /PAE in the boot.ini file, and enable AWE within
SQL, then set a Max
>Server Memory to the memory that you want to allocate to
SQL, but there are
>some things to note
>1) You could also use /3GB to limit the kernel space to
1GB and give you an
>extra 1GB, but this only works up to 16GB, your server is
right on that
>limit and running with these settings can cause problems
as you aproach
>this limit. So I would let the kernel have its 2GB
>2) AWE is not dynamic so SQL will take that memory and it
won't give it
>back, if AWE is not used SQL will release memory as the
OS comes under
>pressure. So if you have other applications running on
the server you may
>want to set the max server memory a little lower.
>3) If this server is clustered how many instances of SQL
are running ?
>Hope this helps
>Regards
>Clive Challinor [MSFT]
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>.
>|||See my other reply.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
<anonymous@.discussions.microsoft.com> wrote in message
news:0b3b01c3997c$7f1d58d0$a601280a@.phx.gbl...
> Hi Clive, thanks for the reply.
> To answer your question: this server is not clustered so
> we only have one instance of SQL Server.
> Why do I need the PAE switch if Win 2003 Enterprise
> Edition by default recognizes up to 32 GB of memory?
> Shouldn't SQL SErver automatically see that the operating
> system can provide more memory than the 2 or 3 GB?
> Thanks again
> Caio
> >--Original Message--
> >Hi Caio,
> >If you want to use large memory configurations with SQL
> (>3gb) you will need
> >to use /PAE in the boot.ini file, and enable AWE within
> SQL, then set a Max
> >Server Memory to the memory that you want to allocate to
> SQL, but there are
> >some things to note
> >
> >1) You could also use /3GB to limit the kernel space to
> 1GB and give you an
> >extra 1GB, but this only works up to 16GB, your server is
> right on that
> >limit and running with these settings can cause problems
> as you aproach
> >this limit. So I would let the kernel have its 2GB
> >
> >2) AWE is not dynamic so SQL will take that memory and it
> won't give it
> >back, if AWE is not used SQL will release memory as the
> OS comes under
> >pressure. So if you have other applications running on
> the server you may
> >want to set the max server memory a little lower.
> >
> >3) If this server is clustered how many instances of SQL
> are running ?
> >
> >Hope this helps
> >
> >Regards
> >Clive Challinor [MSFT]
> >This posting is provided "AS IS" with no warranties, and
> confers no rights.
> >
> >.
> >|||> I am confused: why do I need the PAE switch on if Windows
> 2003 Enterprise Edition by default recognize 32GB of RAM?
> Shouldn't SQL Server Enterprise Edition automatically
> recognize all available memory?
If you have 64 bit SQL Server, yes. Remember that "ordinary" SQL Server is a 32 bit app, and the
address space for a 32 bit app is 4GB. Of these 4GB either 2 or 3 GB are reserved for the system
(depends on the 3GB switch in boot.ini). So, to get to more then 2 or 3 GB, you need the windowing
technique that PAE gives you.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Caio" <anonymous@.discussions.microsoft.com> wrote in message
news:0be801c39978$694dd6a0$a401280a@.phx.gbl...
> I am confused: why do I need the PAE switch on if Windows
> 2003 Enterprise Edition by default recognize 32GB of RAM?
> Shouldn't SQL Server Enterprise Edition automatically
> recognize all available memory?
> Thanks
> Caio
> >--Original Message--
> >Standard edition can use 2GB. Enterprise Edition can use
> up to 64GB, depending on the limitations of
> >the OS. For SQL Server to use more than 2GB (or 3GB,
> depending on whether boot.ini has the /3GB
> >switch), then you need to PAE and AWE memory addressing.
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at: http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"Caio" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:030601c398ea$18301780$a601280a@.phx.gbl...
> >> What is the max memory (RAM) SQL Server 2000 SP3 can use
> >> when installed on a Windows 2K3 Enterprise Edition with
> 16
> >> Gb of memory?
> >>
> >> On the properties of the server it only displays 3,5
> Gb!!
> >>
> >> Thanks
> >>
> >> Caio
> >
> >
> >.
> >
Showing posts with label enterprise. Show all posts
Showing posts with label enterprise. Show all posts
Friday, March 30, 2012
Max Memory Support of SQL 2000 Enterprise on Windows 2003 Enterpri
Pretty simple question, what is the maximum amount of memory SQL 2000
Enterprise Edition can support on Windows 2003 Enterprise Edition (all
refering to the 32-bit versions). Thanks!
32GB on Win 2003 Enterprise
64GB on Win 2003 Datacenter
(I think.)
*mike hodgson*
http://sqlnerd.blogspot.com
Marks70 wrote:
>Pretty simple question, what is the maximum amount of memory SQL 2000
>Enterprise Edition can support on Windows 2003 Enterprise Edition (all
>refering to the 32-bit versions). Thanks!
>
|||The maximum amount of memory that can be supported on Windows Server 2003 is
4 GB.
Refer => http://support.microsoft.com/?id=274750
Thanks,
Sree
"Marks70" wrote:
> Pretty simple question, what is the maximum amount of memory SQL 2000
> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> refering to the 32-bit versions). Thanks!
|||Yes but the question was about Windows 2003 Enterprise which is 32GB in the
same article.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Sreejith G" <SreejithG@.discussions.microsoft.com> wrote in message
news:3DB7B61C-D8DF-4846-8A68-596D683CA237@.microsoft.com...[vbcol=seagreen]
> The maximum amount of memory that can be supported on Windows Server 2003
> is
> 4 GB.
> Refer => http://support.microsoft.com/?id=274750
> Thanks,
> Sree
>
> "Marks70" wrote:
|||Thanks guys!
"Marks70" wrote:
> Pretty simple question, what is the maximum amount of memory SQL 2000
> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> refering to the 32-bit versions). Thanks!
Enterprise Edition can support on Windows 2003 Enterprise Edition (all
refering to the 32-bit versions). Thanks!
32GB on Win 2003 Enterprise
64GB on Win 2003 Datacenter
(I think.)
*mike hodgson*
http://sqlnerd.blogspot.com
Marks70 wrote:
>Pretty simple question, what is the maximum amount of memory SQL 2000
>Enterprise Edition can support on Windows 2003 Enterprise Edition (all
>refering to the 32-bit versions). Thanks!
>
|||The maximum amount of memory that can be supported on Windows Server 2003 is
4 GB.
Refer => http://support.microsoft.com/?id=274750
Thanks,
Sree
"Marks70" wrote:
> Pretty simple question, what is the maximum amount of memory SQL 2000
> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> refering to the 32-bit versions). Thanks!
|||Yes but the question was about Windows 2003 Enterprise which is 32GB in the
same article.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Sreejith G" <SreejithG@.discussions.microsoft.com> wrote in message
news:3DB7B61C-D8DF-4846-8A68-596D683CA237@.microsoft.com...[vbcol=seagreen]
> The maximum amount of memory that can be supported on Windows Server 2003
> is
> 4 GB.
> Refer => http://support.microsoft.com/?id=274750
> Thanks,
> Sree
>
> "Marks70" wrote:
|||Thanks guys!
"Marks70" wrote:
> Pretty simple question, what is the maximum amount of memory SQL 2000
> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> refering to the 32-bit versions). Thanks!
Max Memory Support of SQL 2000 Enterprise on Windows 2003 Enterpri
Pretty simple question, what is the maximum amount of memory SQL 2000
Enterprise Edition can support on Windows 2003 Enterprise Edition (all
refering to the 32-bit versions). Thanks!This is a multi-part message in MIME format.
--090006090404030906000503
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
32GB on Win 2003 Enterprise
64GB on Win 2003 Datacenter
(I think.)
--
*mike hodgson*
http://sqlnerd.blogspot.com
Marks70 wrote:
>Pretty simple question, what is the maximum amount of memory SQL 2000
>Enterprise Edition can support on Windows 2003 Enterprise Edition (all
>refering to the 32-bit versions). Thanks!
>
--090006090404030906000503
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>32GB on Win 2003 Enterprise<br>
64GB on Win 2003 Datacenter<br>
<br>
(I think.)<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"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Marks70 wrote:
<blockquote cite="mid91F52420-72D3-4203-BE73-5C9A3AD9783A@.microsoft.com"
type="cite">
<pre wrap="">Pretty simple question, what is the maximum amount of memory SQL 2000
Enterprise Edition can support on Windows 2003 Enterprise Edition (all
refering to the 32-bit versions). Thanks!
</pre>
</blockquote>
</body>
</html>
--090006090404030906000503--|||The maximum amount of memory that can be supported on Windows Server 2003 is
4 GB.
Refer => http://support.microsoft.com/?id=274750
Thanks,
Sree
"Marks70" wrote:
> Pretty simple question, what is the maximum amount of memory SQL 2000
> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> refering to the 32-bit versions). Thanks!|||Yes but the question was about Windows 2003 Enterprise which is 32GB in the
same article.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Sreejith G" <SreejithG@.discussions.microsoft.com> wrote in message
news:3DB7B61C-D8DF-4846-8A68-596D683CA237@.microsoft.com...
> The maximum amount of memory that can be supported on Windows Server 2003
> is
> 4 GB.
> Refer => http://support.microsoft.com/?id=274750
> Thanks,
> Sree
>
> "Marks70" wrote:
>> Pretty simple question, what is the maximum amount of memory SQL 2000
>> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
>> refering to the 32-bit versions). Thanks!|||Correction :) =>
The maximum amount of memory that can be supported on Windows Server 2003
is 4 GB. However, Windows Server 2003 Enterprise Edition supports 32 GB of
physical RAM.
Thanks,
Sree
"Sreejith G" wrote:
> The maximum amount of memory that can be supported on Windows Server 2003 is
> 4 GB.
> Refer => http://support.microsoft.com/?id=274750
> Thanks,
> Sree
>
> "Marks70" wrote:
> > Pretty simple question, what is the maximum amount of memory SQL 2000
> > Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> > refering to the 32-bit versions). Thanks!|||Thanks guys!
"Marks70" wrote:
> Pretty simple question, what is the maximum amount of memory SQL 2000
> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> refering to the 32-bit versions). Thanks!sql
Enterprise Edition can support on Windows 2003 Enterprise Edition (all
refering to the 32-bit versions). Thanks!This is a multi-part message in MIME format.
--090006090404030906000503
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
32GB on Win 2003 Enterprise
64GB on Win 2003 Datacenter
(I think.)
--
*mike hodgson*
http://sqlnerd.blogspot.com
Marks70 wrote:
>Pretty simple question, what is the maximum amount of memory SQL 2000
>Enterprise Edition can support on Windows 2003 Enterprise Edition (all
>refering to the 32-bit versions). Thanks!
>
--090006090404030906000503
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>32GB on Win 2003 Enterprise<br>
64GB on Win 2003 Datacenter<br>
<br>
(I think.)<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"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Marks70 wrote:
<blockquote cite="mid91F52420-72D3-4203-BE73-5C9A3AD9783A@.microsoft.com"
type="cite">
<pre wrap="">Pretty simple question, what is the maximum amount of memory SQL 2000
Enterprise Edition can support on Windows 2003 Enterprise Edition (all
refering to the 32-bit versions). Thanks!
</pre>
</blockquote>
</body>
</html>
--090006090404030906000503--|||The maximum amount of memory that can be supported on Windows Server 2003 is
4 GB.
Refer => http://support.microsoft.com/?id=274750
Thanks,
Sree
"Marks70" wrote:
> Pretty simple question, what is the maximum amount of memory SQL 2000
> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> refering to the 32-bit versions). Thanks!|||Yes but the question was about Windows 2003 Enterprise which is 32GB in the
same article.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Sreejith G" <SreejithG@.discussions.microsoft.com> wrote in message
news:3DB7B61C-D8DF-4846-8A68-596D683CA237@.microsoft.com...
> The maximum amount of memory that can be supported on Windows Server 2003
> is
> 4 GB.
> Refer => http://support.microsoft.com/?id=274750
> Thanks,
> Sree
>
> "Marks70" wrote:
>> Pretty simple question, what is the maximum amount of memory SQL 2000
>> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
>> refering to the 32-bit versions). Thanks!|||Correction :) =>
The maximum amount of memory that can be supported on Windows Server 2003
is 4 GB. However, Windows Server 2003 Enterprise Edition supports 32 GB of
physical RAM.
Thanks,
Sree
"Sreejith G" wrote:
> The maximum amount of memory that can be supported on Windows Server 2003 is
> 4 GB.
> Refer => http://support.microsoft.com/?id=274750
> Thanks,
> Sree
>
> "Marks70" wrote:
> > Pretty simple question, what is the maximum amount of memory SQL 2000
> > Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> > refering to the 32-bit versions). Thanks!|||Thanks guys!
"Marks70" wrote:
> Pretty simple question, what is the maximum amount of memory SQL 2000
> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> refering to the 32-bit versions). Thanks!sql
Max Memory Support of SQL 2000 Enterprise on Windows 2003 Enterpri
Pretty simple question, what is the maximum amount of memory SQL 2000
Enterprise Edition can support on Windows 2003 Enterprise Edition (all
refering to the 32-bit versions). Thanks!32GB on Win 2003 Enterprise
64GB on Win 2003 Datacenter
(I think.)
*mike hodgson*
http://sqlnerd.blogspot.com
Marks70 wrote:
>Pretty simple question, what is the maximum amount of memory SQL 2000
>Enterprise Edition can support on Windows 2003 Enterprise Edition (all
>refering to the 32-bit versions). Thanks!
>|||The maximum amount of memory that can be supported on Windows Server 2003 is
4 GB.
Refer => http://support.microsoft.com/?id=274750
Thanks,
Sree
"Marks70" wrote:
> Pretty simple question, what is the maximum amount of memory SQL 2000
> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> refering to the 32-bit versions). Thanks!|||Yes but the question was about Windows 2003 Enterprise which is 32GB in the
same article.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Sreejith G" <SreejithG@.discussions.microsoft.com> wrote in message
news:3DB7B61C-D8DF-4846-8A68-596D683CA237@.microsoft.com...[vbcol=seagreen]
> The maximum amount of memory that can be supported on Windows Server 2003
> is
> 4 GB.
> Refer => http://support.microsoft.com/?id=274750
> Thanks,
> Sree
>
> "Marks70" wrote:
>|||Thanks guys!
"Marks70" wrote:
> Pretty simple question, what is the maximum amount of memory SQL 2000
> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> refering to the 32-bit versions). Thanks!
Enterprise Edition can support on Windows 2003 Enterprise Edition (all
refering to the 32-bit versions). Thanks!32GB on Win 2003 Enterprise
64GB on Win 2003 Datacenter
(I think.)
*mike hodgson*
http://sqlnerd.blogspot.com
Marks70 wrote:
>Pretty simple question, what is the maximum amount of memory SQL 2000
>Enterprise Edition can support on Windows 2003 Enterprise Edition (all
>refering to the 32-bit versions). Thanks!
>|||The maximum amount of memory that can be supported on Windows Server 2003 is
4 GB.
Refer => http://support.microsoft.com/?id=274750
Thanks,
Sree
"Marks70" wrote:
> Pretty simple question, what is the maximum amount of memory SQL 2000
> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> refering to the 32-bit versions). Thanks!|||Yes but the question was about Windows 2003 Enterprise which is 32GB in the
same article.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Sreejith G" <SreejithG@.discussions.microsoft.com> wrote in message
news:3DB7B61C-D8DF-4846-8A68-596D683CA237@.microsoft.com...[vbcol=seagreen]
> The maximum amount of memory that can be supported on Windows Server 2003
> is
> 4 GB.
> Refer => http://support.microsoft.com/?id=274750
> Thanks,
> Sree
>
> "Marks70" wrote:
>|||Thanks guys!
"Marks70" wrote:
> Pretty simple question, what is the maximum amount of memory SQL 2000
> Enterprise Edition can support on Windows 2003 Enterprise Edition (all
> refering to the 32-bit versions). Thanks!
Max Memory SQL2K EE on W2K3 EE
This is what I have
Windows Server 2003 Enterprise Edition (x86)
SQL Server 2000 Enterprise Edition (x86)
What I'm trying to clarify is if I have a W2K3 EE system with 32GB of RAM
can a single instanace of SQL2K EE access the entire 32GB
or
Will the single instance only access 8GB and therefore only if I had 4
instances would SQL Server use 32GB
Thanks,
Paul
SP3 and higher will address 32 GB of RAM on W2k3EE. I wouldn't set total
SQL memory for all instances higher than 28GB on such a system. Setting
memory higher can starve necessary OS functions like AWE mapping which will
kill performance and stability
GNH
"Paul Ward" <Paul Ward@.discussions.microsoft.com> wrote in message
news:79DC5A4B-BE32-4770-861F-ACFD2D08DB00@.microsoft.com...
> This is what I have
> Windows Server 2003 Enterprise Edition (x86)
> SQL Server 2000 Enterprise Edition (x86)
>
> What I'm trying to clarify is if I have a W2K3 EE system with 32GB of RAM
> can a single instanace of SQL2K EE access the entire 32GB
> or
> Will the single instance only access 8GB and therefore only if I had 4
> instances would SQL Server use 32GB
> Thanks,
> Paul
|||Thanks Geoff.
I've looked through the release notes for SP3 and can't find any reference
to this.
Have you seen this documented somewhere or is your answer based on a system
you have worked with?
"Geoff N. Hiten" wrote:
> SP3 and higher will address 32 GB of RAM on W2k3EE. I wouldn't set total
> SQL memory for all instances higher than 28GB on such a system. Setting
> memory higher can starve necessary OS functions like AWE mapping which will
> kill performance and stability
> GNH
>
> "Paul Ward" <Paul Ward@.discussions.microsoft.com> wrote in message
> news:79DC5A4B-BE32-4770-861F-ACFD2D08DB00@.microsoft.com...
>
|||Is a Microsoft KB article good enough?
How to configure SQL Server to use more than 2 GB of physical memory
http://support.microsoft.com/kb/274750
Click on the scrolldown link to Windows 2000 Advanced Server or Windows 2000
Datacenter or Windows Server 2003
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
news:43B4240B-1E41-4BA3-B068-CF048598E1AD@.microsoft.com...[vbcol=seagreen]
> Thanks Geoff.
> I've looked through the release notes for SP3 and can't find any reference
> to this.
> Have you seen this documented somewhere or is your answer based on a
> system
> you have worked with?
> "Geoff N. Hiten" wrote:
|||I've seen this before and although it states that W2K3 EE supports 32GB using
PAE it doesn't actually make it clear that SQL2K EE can use (the majority) of
this.
Have you been involved with a system running W2K3 EE and SQL2K EE with a
large amount of RAM?
"Geoff N. Hiten" wrote:
> Is a Microsoft KB article good enough?
> How to configure SQL Server to use more than 2 GB of physical memory
> http://support.microsoft.com/kb/274750
> Click on the scrolldown link to Windows 2000 Advanced Server or Windows 2000
> Datacenter or Windows Server 2003
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
> news:43B4240B-1E41-4BA3-B068-CF048598E1AD@.microsoft.com...
>
|||Yes. I have built a system with 32GB of physical RAM , W2K3EE and SQL2K EE,
It happened to be a four-node cluster with 8 procs per node, just to make it
more complex.
So much of my advice in this area is from hard-earned
direct knowledge.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
news:4B55AA08-7B48-4221-BBA3-8B0D4AFA7906@.microsoft.com...[vbcol=seagreen]
> I've seen this before and although it states that W2K3 EE supports 32GB
> using
> PAE it doesn't actually make it clear that SQL2K EE can use (the majority)
> of
> this.
> Have you been involved with a system running W2K3 EE and SQL2K EE with a
> large amount of RAM?
>
> "Geoff N. Hiten" wrote:
|||Thanks for help and sharing your knowledge on this
"Geoff N. Hiten" wrote:
> Yes. I have built a system with 32GB of physical RAM , W2K3EE and SQL2K EE,
> It happened to be a four-node cluster with 8 procs per node, just to make it
> more complex. So much of my advice in this area is from hard-earned
> direct knowledge.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
> news:4B55AA08-7B48-4221-BBA3-8B0D4AFA7906@.microsoft.com...
>
sql
Windows Server 2003 Enterprise Edition (x86)
SQL Server 2000 Enterprise Edition (x86)
What I'm trying to clarify is if I have a W2K3 EE system with 32GB of RAM
can a single instanace of SQL2K EE access the entire 32GB
or
Will the single instance only access 8GB and therefore only if I had 4
instances would SQL Server use 32GB
Thanks,
Paul
SP3 and higher will address 32 GB of RAM on W2k3EE. I wouldn't set total
SQL memory for all instances higher than 28GB on such a system. Setting
memory higher can starve necessary OS functions like AWE mapping which will
kill performance and stability
GNH
"Paul Ward" <Paul Ward@.discussions.microsoft.com> wrote in message
news:79DC5A4B-BE32-4770-861F-ACFD2D08DB00@.microsoft.com...
> This is what I have
> Windows Server 2003 Enterprise Edition (x86)
> SQL Server 2000 Enterprise Edition (x86)
>
> What I'm trying to clarify is if I have a W2K3 EE system with 32GB of RAM
> can a single instanace of SQL2K EE access the entire 32GB
> or
> Will the single instance only access 8GB and therefore only if I had 4
> instances would SQL Server use 32GB
> Thanks,
> Paul
|||Thanks Geoff.
I've looked through the release notes for SP3 and can't find any reference
to this.
Have you seen this documented somewhere or is your answer based on a system
you have worked with?
"Geoff N. Hiten" wrote:
> SP3 and higher will address 32 GB of RAM on W2k3EE. I wouldn't set total
> SQL memory for all instances higher than 28GB on such a system. Setting
> memory higher can starve necessary OS functions like AWE mapping which will
> kill performance and stability
> GNH
>
> "Paul Ward" <Paul Ward@.discussions.microsoft.com> wrote in message
> news:79DC5A4B-BE32-4770-861F-ACFD2D08DB00@.microsoft.com...
>
|||Is a Microsoft KB article good enough?
How to configure SQL Server to use more than 2 GB of physical memory
http://support.microsoft.com/kb/274750
Click on the scrolldown link to Windows 2000 Advanced Server or Windows 2000
Datacenter or Windows Server 2003
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
news:43B4240B-1E41-4BA3-B068-CF048598E1AD@.microsoft.com...[vbcol=seagreen]
> Thanks Geoff.
> I've looked through the release notes for SP3 and can't find any reference
> to this.
> Have you seen this documented somewhere or is your answer based on a
> system
> you have worked with?
> "Geoff N. Hiten" wrote:
|||I've seen this before and although it states that W2K3 EE supports 32GB using
PAE it doesn't actually make it clear that SQL2K EE can use (the majority) of
this.
Have you been involved with a system running W2K3 EE and SQL2K EE with a
large amount of RAM?
"Geoff N. Hiten" wrote:
> Is a Microsoft KB article good enough?
> How to configure SQL Server to use more than 2 GB of physical memory
> http://support.microsoft.com/kb/274750
> Click on the scrolldown link to Windows 2000 Advanced Server or Windows 2000
> Datacenter or Windows Server 2003
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
> news:43B4240B-1E41-4BA3-B068-CF048598E1AD@.microsoft.com...
>
|||Yes. I have built a system with 32GB of physical RAM , W2K3EE and SQL2K EE,
It happened to be a four-node cluster with 8 procs per node, just to make it
more complex.
So much of my advice in this area is from hard-earneddirect knowledge.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
news:4B55AA08-7B48-4221-BBA3-8B0D4AFA7906@.microsoft.com...[vbcol=seagreen]
> I've seen this before and although it states that W2K3 EE supports 32GB
> using
> PAE it doesn't actually make it clear that SQL2K EE can use (the majority)
> of
> this.
> Have you been involved with a system running W2K3 EE and SQL2K EE with a
> large amount of RAM?
>
> "Geoff N. Hiten" wrote:
|||Thanks for help and sharing your knowledge on this
"Geoff N. Hiten" wrote:
> Yes. I have built a system with 32GB of physical RAM , W2K3EE and SQL2K EE,
> It happened to be a four-node cluster with 8 procs per node, just to make it
> more complex.
So much of my advice in this area is from hard-earned> direct knowledge.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
> news:4B55AA08-7B48-4221-BBA3-8B0D4AFA7906@.microsoft.com...
>
sql
Max Memory SQL2K EE on W2K3 EE
This is what I have
Windows Server 2003 Enterprise Edition (x86)
SQL Server 2000 Enterprise Edition (x86)
What I'm trying to clarify is if I have a W2K3 EE system with 32GB of RAM
can a single instanace of SQL2K EE access the entire 32GB
or
Will the single instance only access 8GB and therefore only if I had 4
instances would SQL Server use 32GB
Thanks,
PaulSP3 and higher will address 32 GB of RAM on W2k3EE. I wouldn't set total
SQL memory for all instances higher than 28GB on such a system. Setting
memory higher can starve necessary OS functions like AWE mapping which will
kill performance and stability
GNH
"Paul Ward" <Paul Ward@.discussions.microsoft.com> wrote in message
news:79DC5A4B-BE32-4770-861F-ACFD2D08DB00@.microsoft.com...
> This is what I have
> Windows Server 2003 Enterprise Edition (x86)
> SQL Server 2000 Enterprise Edition (x86)
>
> What I'm trying to clarify is if I have a W2K3 EE system with 32GB of RAM
> can a single instanace of SQL2K EE access the entire 32GB
> or
> Will the single instance only access 8GB and therefore only if I had 4
> instances would SQL Server use 32GB
> Thanks,
> Paul|||Thanks Geoff.
I've looked through the release notes for SP3 and can't find any reference
to this.
Have you seen this documented somewhere or is your answer based on a system
you have worked with?
"Geoff N. Hiten" wrote:
> SP3 and higher will address 32 GB of RAM on W2k3EE. I wouldn't set total
> SQL memory for all instances higher than 28GB on such a system. Setting
> memory higher can starve necessary OS functions like AWE mapping which wil
l
> kill performance and stability
> GNH
>
> "Paul Ward" <Paul Ward@.discussions.microsoft.com> wrote in message
> news:79DC5A4B-BE32-4770-861F-ACFD2D08DB00@.microsoft.com...
>|||Is a Microsoft KB article good enough?
How to configure SQL Server to use more than 2 GB of physical memory
http://support.microsoft.com/kb/274750
Click on the scrolldown link to Windows 2000 Advanced Server or Windows 2000
Datacenter or Windows Server 2003
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
news:43B4240B-1E41-4BA3-B068-CF048598E1AD@.microsoft.com...[vbcol=seagreen]
> Thanks Geoff.
> I've looked through the release notes for SP3 and can't find any reference
> to this.
> Have you seen this documented somewhere or is your answer based on a
> system
> you have worked with?
> "Geoff N. Hiten" wrote:
>|||I've seen this before and although it states that W2K3 EE supports 32GB usin
g
PAE it doesn't actually make it clear that SQL2K EE can use (the majority) o
f
this.
Have you been involved with a system running W2K3 EE and SQL2K EE with a
large amount of RAM?
"Geoff N. Hiten" wrote:
> Is a Microsoft KB article good enough?
> How to configure SQL Server to use more than 2 GB of physical memory
> http://support.microsoft.com/kb/274750
> Click on the scrolldown link to Windows 2000 Advanced Server or Windows 20
00
> Datacenter or Windows Server 2003
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
> news:43B4240B-1E41-4BA3-B068-CF048598E1AD@.microsoft.com...
>|||Yes. I have built a system with 32GB of physical RAM , W2K3EE and SQL2K EE,
It happened to be a four-node cluster with 8 procs per node, just to make it
more complex. So much of my advice in this area is from hard-earned
direct knowledge.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
news:4B55AA08-7B48-4221-BBA3-8B0D4AFA7906@.microsoft.com...[vbcol=seagreen]
> I've seen this before and although it states that W2K3 EE supports 32GB
> using
> PAE it doesn't actually make it clear that SQL2K EE can use (the majority)
> of
> this.
> Have you been involved with a system running W2K3 EE and SQL2K EE with a
> large amount of RAM?
>
> "Geoff N. Hiten" wrote:
>|||Thanks for help and sharing your knowledge on this
"Geoff N. Hiten" wrote:
> Yes. I have built a system with 32GB of physical RAM , W2K3EE and SQL2K E
E,
> It happened to be a four-node cluster with 8 procs per node, just to make
it
> more complex. So much of my advice in this area is from hard-earned
> direct knowledge.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
> news:4B55AA08-7B48-4221-BBA3-8B0D4AFA7906@.microsoft.com...
>
Windows Server 2003 Enterprise Edition (x86)
SQL Server 2000 Enterprise Edition (x86)
What I'm trying to clarify is if I have a W2K3 EE system with 32GB of RAM
can a single instanace of SQL2K EE access the entire 32GB
or
Will the single instance only access 8GB and therefore only if I had 4
instances would SQL Server use 32GB
Thanks,
PaulSP3 and higher will address 32 GB of RAM on W2k3EE. I wouldn't set total
SQL memory for all instances higher than 28GB on such a system. Setting
memory higher can starve necessary OS functions like AWE mapping which will
kill performance and stability
GNH
"Paul Ward" <Paul Ward@.discussions.microsoft.com> wrote in message
news:79DC5A4B-BE32-4770-861F-ACFD2D08DB00@.microsoft.com...
> This is what I have
> Windows Server 2003 Enterprise Edition (x86)
> SQL Server 2000 Enterprise Edition (x86)
>
> What I'm trying to clarify is if I have a W2K3 EE system with 32GB of RAM
> can a single instanace of SQL2K EE access the entire 32GB
> or
> Will the single instance only access 8GB and therefore only if I had 4
> instances would SQL Server use 32GB
> Thanks,
> Paul|||Thanks Geoff.
I've looked through the release notes for SP3 and can't find any reference
to this.
Have you seen this documented somewhere or is your answer based on a system
you have worked with?
"Geoff N. Hiten" wrote:
> SP3 and higher will address 32 GB of RAM on W2k3EE. I wouldn't set total
> SQL memory for all instances higher than 28GB on such a system. Setting
> memory higher can starve necessary OS functions like AWE mapping which wil
l
> kill performance and stability
> GNH
>
> "Paul Ward" <Paul Ward@.discussions.microsoft.com> wrote in message
> news:79DC5A4B-BE32-4770-861F-ACFD2D08DB00@.microsoft.com...
>|||Is a Microsoft KB article good enough?
How to configure SQL Server to use more than 2 GB of physical memory
http://support.microsoft.com/kb/274750
Click on the scrolldown link to Windows 2000 Advanced Server or Windows 2000
Datacenter or Windows Server 2003
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
news:43B4240B-1E41-4BA3-B068-CF048598E1AD@.microsoft.com...[vbcol=seagreen]
> Thanks Geoff.
> I've looked through the release notes for SP3 and can't find any reference
> to this.
> Have you seen this documented somewhere or is your answer based on a
> system
> you have worked with?
> "Geoff N. Hiten" wrote:
>|||I've seen this before and although it states that W2K3 EE supports 32GB usin
g
PAE it doesn't actually make it clear that SQL2K EE can use (the majority) o
f
this.
Have you been involved with a system running W2K3 EE and SQL2K EE with a
large amount of RAM?
"Geoff N. Hiten" wrote:
> Is a Microsoft KB article good enough?
> How to configure SQL Server to use more than 2 GB of physical memory
> http://support.microsoft.com/kb/274750
> Click on the scrolldown link to Windows 2000 Advanced Server or Windows 20
00
> Datacenter or Windows Server 2003
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
> news:43B4240B-1E41-4BA3-B068-CF048598E1AD@.microsoft.com...
>|||Yes. I have built a system with 32GB of physical RAM , W2K3EE and SQL2K EE,
It happened to be a four-node cluster with 8 procs per node, just to make it
more complex.
So much of my advice in this area is from hard-earneddirect knowledge.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
news:4B55AA08-7B48-4221-BBA3-8B0D4AFA7906@.microsoft.com...[vbcol=seagreen]
> I've seen this before and although it states that W2K3 EE supports 32GB
> using
> PAE it doesn't actually make it clear that SQL2K EE can use (the majority)
> of
> this.
> Have you been involved with a system running W2K3 EE and SQL2K EE with a
> large amount of RAM?
>
> "Geoff N. Hiten" wrote:
>|||Thanks for help and sharing your knowledge on this
"Geoff N. Hiten" wrote:
> Yes. I have built a system with 32GB of physical RAM , W2K3EE and SQL2K E
E,
> It happened to be a four-node cluster with 8 procs per node, just to make
it
> more complex.
So much of my advice in this area is from hard-earned> direct knowledge.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Paul Ward" <PaulWard@.discussions.microsoft.com> wrote in message
> news:4B55AA08-7B48-4221-BBA3-8B0D4AFA7906@.microsoft.com...
>
Max memory on 32/64 bit
I'm tired of Googling for a definitive answer
What is the max memory SQL Server can access in this setup:
SQL 2000, Enterprise edition, 32 bit
Windows 2003, EE, 64 bit
I'm thinking 32GB from what I've read, but I want to make sure before I tell
my customer what to buy...
Thanks!
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
These should provide the definitive answer you seek.
Configuration -Maximum Capacity Specifications
2000
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
2005 http://msdn2.microsoft.com/en-us/library/ms143287.aspx
2005 http://msdn2.microsoft.com/en-us/library/ms143432.aspx
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
> I'm tired of Googling for a definitive answer
> What is the max memory SQL Server can access in this setup:
> SQL 2000, Enterprise edition, 32 bit
> Windows 2003, EE, 64 bit
> I'm thinking 32GB from what I've read, but I want to make sure before I
> tell my customer what to buy...
> Thanks!
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
>
|||With no boot ini settings 2 Gigs.
With /3Gig boot ini 3 Gigs
With /AWE and SQL Server 2000 32 bit the data cache can see a max of 32 Gigs
with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit. 64
bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
> I'm tired of Googling for a definitive answer
> What is the max memory SQL Server can access in this setup:
> SQL 2000, Enterprise edition, 32 bit
> Windows 2003, EE, 64 bit
> I'm thinking 32GB from what I've read, but I want to make sure before I
> tell my customer what to buy...
> Thanks!
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
>
|||A leetle confused here:
with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit.
64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit
Seems like the first option there is missing something...
Second option is not relevant to my 32 bit SQL scenario, but good info
nonetheless...
Thanks
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:el$vr3kEHHA.4832@.TK2MSFTNGP06.phx.gbl...
> With no boot ini settings 2 Gigs.
> With /3Gig boot ini 3 Gigs
> With /AWE and SQL Server 2000 32 bit the data cache can see a max of 32
> Gigs with AWE enabled on SQL Server and PAE enabled on Windows 2003 64
> bit. 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
>
|||Thanks Arnie, but the BOL link does not specifically reference Windows 2003
EE, 64 bit (or any other Win2K3 versions...)
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eaVxm0kEHHA.3520@.TK2MSFTNGP04.phx.gbl...
> These should provide the definitive answer you seek.
> Configuration -Maximum Capacity Specifications
> 2000
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
> 2005 http://msdn2.microsoft.com/en-us/library/ms143287.aspx
> 2005 http://msdn2.microsoft.com/en-us/library/ms143432.aspx
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
>
|||That doesn't read well - try this
With SQL Server 2000 EE 32 bit with AWE enable running on Windows 2003 64
bit EE with PAE enabled, the data cache can see a max of 32 Gigs.
With SQL Server 2000 EE 64 bit with AWE enable running on Windows 2003 64
bit EE with PAE enabled, the data cache can see a max of 64 Gigs.
Note that the procedure cache and other caches will still see IIRC 2 Gigs
and most of the OS memory will be used with the 64 address windowing.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:us7AISlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
>A leetle confused here:
> with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit.
> 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit
> Seems like the first option there is missing something...
> Second option is not relevant to my 32 bit SQL scenario, but good info
> nonetheless...
> Thanks
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:el$vr3kEHHA.4832@.TK2MSFTNGP06.phx.gbl...
>
|||Oops, sorry Kevin, this is a better source for you.
http://www.support.microsoft.com/?id=283037
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:e2a1oSlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
> Thanks Arnie, but the BOL link does not specifically reference Windows
> 2003 EE, 64 bit (or any other Win2K3 versions...)
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:eaVxm0kEHHA.3520@.TK2MSFTNGP04.phx.gbl...
>
|||Thanks for the clarification
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OX3SnVlEHHA.3768@.TK2MSFTNGP06.phx.gbl...
> That doesn't read well - try this
> With SQL Server 2000 EE 32 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 32 Gigs.
> With SQL Server 2000 EE 64 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 64 Gigs.
> Note that the procedure cache and other caches will still see IIRC 2 Gigs
> and most of the OS memory will be used with the 64 address windowing.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:us7AISlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
>
|||But 64-bit Windows does not support PAE.
http://www.microsoft.com/whdc/system/platform/server/PAE/PAEmem.mspx
Linchi
"Hilary Cotter" wrote:
> That doesn't read well - try this
> With SQL Server 2000 EE 32 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 32 Gigs.
> With SQL Server 2000 EE 64 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 64 Gigs.
> Note that the procedure cache and other caches will still see IIRC 2 Gigs
> and most of the OS memory will be used with the 64 address windowing.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:us7AISlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
>
>
What is the max memory SQL Server can access in this setup:
SQL 2000, Enterprise edition, 32 bit
Windows 2003, EE, 64 bit
I'm thinking 32GB from what I've read, but I want to make sure before I tell
my customer what to buy...
Thanks!
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
These should provide the definitive answer you seek.
Configuration -Maximum Capacity Specifications
2000
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
2005 http://msdn2.microsoft.com/en-us/library/ms143287.aspx
2005 http://msdn2.microsoft.com/en-us/library/ms143432.aspx
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
> I'm tired of Googling for a definitive answer
> What is the max memory SQL Server can access in this setup:
> SQL 2000, Enterprise edition, 32 bit
> Windows 2003, EE, 64 bit
> I'm thinking 32GB from what I've read, but I want to make sure before I
> tell my customer what to buy...
> Thanks!
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
>
|||With no boot ini settings 2 Gigs.
With /3Gig boot ini 3 Gigs
With /AWE and SQL Server 2000 32 bit the data cache can see a max of 32 Gigs
with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit. 64
bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
> I'm tired of Googling for a definitive answer
> What is the max memory SQL Server can access in this setup:
> SQL 2000, Enterprise edition, 32 bit
> Windows 2003, EE, 64 bit
> I'm thinking 32GB from what I've read, but I want to make sure before I
> tell my customer what to buy...
> Thanks!
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
>
|||A leetle confused here:
with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit.
64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit
Seems like the first option there is missing something...
Second option is not relevant to my 32 bit SQL scenario, but good info
nonetheless...
Thanks
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:el$vr3kEHHA.4832@.TK2MSFTNGP06.phx.gbl...
> With no boot ini settings 2 Gigs.
> With /3Gig boot ini 3 Gigs
> With /AWE and SQL Server 2000 32 bit the data cache can see a max of 32
> Gigs with AWE enabled on SQL Server and PAE enabled on Windows 2003 64
> bit. 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
>
|||Thanks Arnie, but the BOL link does not specifically reference Windows 2003
EE, 64 bit (or any other Win2K3 versions...)
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eaVxm0kEHHA.3520@.TK2MSFTNGP04.phx.gbl...
> These should provide the definitive answer you seek.
> Configuration -Maximum Capacity Specifications
> 2000
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
> 2005 http://msdn2.microsoft.com/en-us/library/ms143287.aspx
> 2005 http://msdn2.microsoft.com/en-us/library/ms143432.aspx
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
>
|||That doesn't read well - try this
With SQL Server 2000 EE 32 bit with AWE enable running on Windows 2003 64
bit EE with PAE enabled, the data cache can see a max of 32 Gigs.
With SQL Server 2000 EE 64 bit with AWE enable running on Windows 2003 64
bit EE with PAE enabled, the data cache can see a max of 64 Gigs.
Note that the procedure cache and other caches will still see IIRC 2 Gigs
and most of the OS memory will be used with the 64 address windowing.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:us7AISlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
>A leetle confused here:
> with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit.
> 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit
> Seems like the first option there is missing something...
> Second option is not relevant to my 32 bit SQL scenario, but good info
> nonetheless...
> Thanks
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:el$vr3kEHHA.4832@.TK2MSFTNGP06.phx.gbl...
>
|||Oops, sorry Kevin, this is a better source for you.
http://www.support.microsoft.com/?id=283037
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:e2a1oSlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
> Thanks Arnie, but the BOL link does not specifically reference Windows
> 2003 EE, 64 bit (or any other Win2K3 versions...)
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:eaVxm0kEHHA.3520@.TK2MSFTNGP04.phx.gbl...
>
|||Thanks for the clarification
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OX3SnVlEHHA.3768@.TK2MSFTNGP06.phx.gbl...
> That doesn't read well - try this
> With SQL Server 2000 EE 32 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 32 Gigs.
> With SQL Server 2000 EE 64 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 64 Gigs.
> Note that the procedure cache and other caches will still see IIRC 2 Gigs
> and most of the OS memory will be used with the 64 address windowing.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:us7AISlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
>
|||But 64-bit Windows does not support PAE.
http://www.microsoft.com/whdc/system/platform/server/PAE/PAEmem.mspx
Linchi
"Hilary Cotter" wrote:
> That doesn't read well - try this
> With SQL Server 2000 EE 32 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 32 Gigs.
> With SQL Server 2000 EE 64 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 64 Gigs.
> Note that the procedure cache and other caches will still see IIRC 2 Gigs
> and most of the OS memory will be used with the 64 address windowing.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:us7AISlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
>
>
Max memory on 32/64 bit
I'm tired of Googling for a definitive answer :)
What is the max memory SQL Server can access in this setup:
SQL 2000, Enterprise edition, 32 bit
Windows 2003, EE, 64 bit
I'm thinking 32GB from what I've read, but I want to make sure before I tell
my customer what to buy...
Thanks!
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.comThese should provide the definitive answer you seek.
Configuration -Maximum Capacity Specifications
2000
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
2005 http://msdn2.microsoft.com/en-us/library/ms143287.aspx
2005 http://msdn2.microsoft.com/en-us/library/ms143432.aspx
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
> I'm tired of Googling for a definitive answer :)
> What is the max memory SQL Server can access in this setup:
> SQL 2000, Enterprise edition, 32 bit
> Windows 2003, EE, 64 bit
> I'm thinking 32GB from what I've read, but I want to make sure before I
> tell my customer what to buy...
> Thanks!
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
>|||With no boot ini settings 2 Gigs.
With /3Gig boot ini 3 Gigs
With /AWE and SQL Server 2000 32 bit the data cache can see a max of 32 Gigs
with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit. 64
bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
> I'm tired of Googling for a definitive answer :)
> What is the max memory SQL Server can access in this setup:
> SQL 2000, Enterprise edition, 32 bit
> Windows 2003, EE, 64 bit
> I'm thinking 32GB from what I've read, but I want to make sure before I
> tell my customer what to buy...
> Thanks!
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
>|||A leetle confused here:
with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit.
64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit
Seems like the first option there is missing something...
Second option is not relevant to my 32 bit SQL scenario, but good info
nonetheless...
Thanks
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:el$vr3kEHHA.4832@.TK2MSFTNGP06.phx.gbl...
> With no boot ini settings 2 Gigs.
> With /3Gig boot ini 3 Gigs
> With /AWE and SQL Server 2000 32 bit the data cache can see a max of 32
> Gigs with AWE enabled on SQL Server and PAE enabled on Windows 2003 64
> bit. 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
>> I'm tired of Googling for a definitive answer :)
>> What is the max memory SQL Server can access in this setup:
>> SQL 2000, Enterprise edition, 32 bit
>> Windows 2003, EE, 64 bit
>> I'm thinking 32GB from what I've read, but I want to make sure before I
>> tell my customer what to buy...
>> Thanks!
>> --
>> Kevin Hill
>> 3NF Consulting
>> http://www.3nf-inc.com/NewsGroups.htm
>> Real-world stuff I run across with SQL Server:
>> http://kevin3nf.blogspot.com
>>
>|||Thanks Arnie, but the BOL link does not specifically reference Windows 2003
EE, 64 bit (or any other Win2K3 versions...)
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eaVxm0kEHHA.3520@.TK2MSFTNGP04.phx.gbl...
> These should provide the definitive answer you seek.
> Configuration -Maximum Capacity Specifications
> 2000
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
> 2005 http://msdn2.microsoft.com/en-us/library/ms143287.aspx
> 2005 http://msdn2.microsoft.com/en-us/library/ms143432.aspx
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
>> I'm tired of Googling for a definitive answer :)
>> What is the max memory SQL Server can access in this setup:
>> SQL 2000, Enterprise edition, 32 bit
>> Windows 2003, EE, 64 bit
>> I'm thinking 32GB from what I've read, but I want to make sure before I
>> tell my customer what to buy...
>> Thanks!
>> --
>> Kevin Hill
>> 3NF Consulting
>> http://www.3nf-inc.com/NewsGroups.htm
>> Real-world stuff I run across with SQL Server:
>> http://kevin3nf.blogspot.com
>>
>|||That doesn't read well - try this
With SQL Server 2000 EE 32 bit with AWE enable running on Windows 2003 64
bit EE with PAE enabled, the data cache can see a max of 32 Gigs.
With SQL Server 2000 EE 64 bit with AWE enable running on Windows 2003 64
bit EE with PAE enabled, the data cache can see a max of 64 Gigs.
Note that the procedure cache and other caches will still see IIRC 2 Gigs
and most of the OS memory will be used with the 64 address windowing.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:us7AISlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
>A leetle confused here:
> with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit.
> 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit
> Seems like the first option there is missing something...
> Second option is not relevant to my 32 bit SQL scenario, but good info
> nonetheless...
> Thanks
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:el$vr3kEHHA.4832@.TK2MSFTNGP06.phx.gbl...
>> With no boot ini settings 2 Gigs.
>> With /3Gig boot ini 3 Gigs
>> With /AWE and SQL Server 2000 32 bit the data cache can see a max of 32
>> Gigs with AWE enabled on SQL Server and PAE enabled on Windows 2003 64
>> bit. 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit.
>> --
>> Hilary Cotter
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>>
>> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
>> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
>> I'm tired of Googling for a definitive answer :)
>> What is the max memory SQL Server can access in this setup:
>> SQL 2000, Enterprise edition, 32 bit
>> Windows 2003, EE, 64 bit
>> I'm thinking 32GB from what I've read, but I want to make sure before I
>> tell my customer what to buy...
>> Thanks!
>> --
>> Kevin Hill
>> 3NF Consulting
>> http://www.3nf-inc.com/NewsGroups.htm
>> Real-world stuff I run across with SQL Server:
>> http://kevin3nf.blogspot.com
>>
>>
>|||Oops, sorry Kevin, this is a better source for you.
http://www.support.microsoft.com/?id=283037
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:e2a1oSlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
> Thanks Arnie, but the BOL link does not specifically reference Windows
> 2003 EE, 64 bit (or any other Win2K3 versions...)
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:eaVxm0kEHHA.3520@.TK2MSFTNGP04.phx.gbl...
>> These should provide the definitive answer you seek.
>> Configuration -Maximum Capacity Specifications
>> 2000
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
>> 2005 http://msdn2.microsoft.com/en-us/library/ms143287.aspx
>> 2005 http://msdn2.microsoft.com/en-us/library/ms143432.aspx
>>
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>> You can't help someone get up a hill without getting a little closer to
>> the top yourself.
>> - H. Norman Schwarzkopf
>>
>> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
>> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
>> I'm tired of Googling for a definitive answer :)
>> What is the max memory SQL Server can access in this setup:
>> SQL 2000, Enterprise edition, 32 bit
>> Windows 2003, EE, 64 bit
>> I'm thinking 32GB from what I've read, but I want to make sure before I
>> tell my customer what to buy...
>> Thanks!
>> --
>> Kevin Hill
>> 3NF Consulting
>> http://www.3nf-inc.com/NewsGroups.htm
>> Real-world stuff I run across with SQL Server:
>> http://kevin3nf.blogspot.com
>>
>>
>|||Thanks for the clarification :)
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OX3SnVlEHHA.3768@.TK2MSFTNGP06.phx.gbl...
> That doesn't read well - try this
> With SQL Server 2000 EE 32 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 32 Gigs.
> With SQL Server 2000 EE 64 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 64 Gigs.
> Note that the procedure cache and other caches will still see IIRC 2 Gigs
> and most of the OS memory will be used with the 64 address windowing.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:us7AISlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
>>A leetle confused here:
>> with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit.
>> 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit
>> Seems like the first option there is missing something...
>> Second option is not relevant to my 32 bit SQL scenario, but good info
>> nonetheless...
>> Thanks
>> --
>> Kevin Hill
>> 3NF Consulting
>> http://www.3nf-inc.com/NewsGroups.htm
>> Real-world stuff I run across with SQL Server:
>> http://kevin3nf.blogspot.com
>>
>> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
>> news:el$vr3kEHHA.4832@.TK2MSFTNGP06.phx.gbl...
>> With no boot ini settings 2 Gigs.
>> With /3Gig boot ini 3 Gigs
>> With /AWE and SQL Server 2000 32 bit the data cache can see a max of 32
>> Gigs with AWE enabled on SQL Server and PAE enabled on Windows 2003 64
>> bit. 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit.
>> --
>> Hilary Cotter
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>>
>> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
>> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
>> I'm tired of Googling for a definitive answer :)
>> What is the max memory SQL Server can access in this setup:
>> SQL 2000, Enterprise edition, 32 bit
>> Windows 2003, EE, 64 bit
>> I'm thinking 32GB from what I've read, but I want to make sure before I
>> tell my customer what to buy...
>> Thanks!
>> --
>> Kevin Hill
>> 3NF Consulting
>> http://www.3nf-inc.com/NewsGroups.htm
>> Real-world stuff I run across with SQL Server:
>> http://kevin3nf.blogspot.com
>>
>>
>>
>|||But 64-bit Windows does not support PAE.
http://www.microsoft.com/whdc/system/platform/server/PAE/PAEmem.mspx
Linchi
"Hilary Cotter" wrote:
> That doesn't read well - try this
> With SQL Server 2000 EE 32 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 32 Gigs.
> With SQL Server 2000 EE 64 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 64 Gigs.
> Note that the procedure cache and other caches will still see IIRC 2 Gigs
> and most of the OS memory will be used with the 64 address windowing.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:us7AISlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
> >A leetle confused here:
> >
> > with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit.
> >
> > 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit
> >
> > Seems like the first option there is missing something...
> >
> > Second option is not relevant to my 32 bit SQL scenario, but good info
> > nonetheless...
> >
> > Thanks
> > --
> > Kevin Hill
> > 3NF Consulting
> > http://www.3nf-inc.com/NewsGroups.htm
> >
> > Real-world stuff I run across with SQL Server:
> > http://kevin3nf.blogspot.com
> >
> >
> > "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> > news:el$vr3kEHHA.4832@.TK2MSFTNGP06.phx.gbl...
> >> With no boot ini settings 2 Gigs.
> >> With /3Gig boot ini 3 Gigs
> >> With /AWE and SQL Server 2000 32 bit the data cache can see a max of 32
> >> Gigs with AWE enabled on SQL Server and PAE enabled on Windows 2003 64
> >> bit. 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit.
> >>
> >> --
> >> Hilary Cotter
> >>
> >> Looking for a SQL Server replication book?
> >> http://www.nwsu.com/0974973602.html
> >>
> >> Looking for a FAQ on Indexing Services/SQL FTS
> >> http://www.indexserverfaq.com
> >>
> >>
> >>
> >> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> >> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
> >> I'm tired of Googling for a definitive answer :)
> >>
> >> What is the max memory SQL Server can access in this setup:
> >>
> >> SQL 2000, Enterprise edition, 32 bit
> >> Windows 2003, EE, 64 bit
> >>
> >> I'm thinking 32GB from what I've read, but I want to make sure before I
> >> tell my customer what to buy...
> >>
> >> Thanks!
> >>
> >> --
> >> Kevin Hill
> >> 3NF Consulting
> >> http://www.3nf-inc.com/NewsGroups.htm
> >>
> >> Real-world stuff I run across with SQL Server:
> >> http://kevin3nf.blogspot.com
> >>
> >>
> >>
> >>
> >>
> >
> >
>
>
What is the max memory SQL Server can access in this setup:
SQL 2000, Enterprise edition, 32 bit
Windows 2003, EE, 64 bit
I'm thinking 32GB from what I've read, but I want to make sure before I tell
my customer what to buy...
Thanks!
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.comThese should provide the definitive answer you seek.
Configuration -Maximum Capacity Specifications
2000
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
2005 http://msdn2.microsoft.com/en-us/library/ms143287.aspx
2005 http://msdn2.microsoft.com/en-us/library/ms143432.aspx
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
> I'm tired of Googling for a definitive answer :)
> What is the max memory SQL Server can access in this setup:
> SQL 2000, Enterprise edition, 32 bit
> Windows 2003, EE, 64 bit
> I'm thinking 32GB from what I've read, but I want to make sure before I
> tell my customer what to buy...
> Thanks!
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
>|||With no boot ini settings 2 Gigs.
With /3Gig boot ini 3 Gigs
With /AWE and SQL Server 2000 32 bit the data cache can see a max of 32 Gigs
with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit. 64
bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
> I'm tired of Googling for a definitive answer :)
> What is the max memory SQL Server can access in this setup:
> SQL 2000, Enterprise edition, 32 bit
> Windows 2003, EE, 64 bit
> I'm thinking 32GB from what I've read, but I want to make sure before I
> tell my customer what to buy...
> Thanks!
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
>|||A leetle confused here:
with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit.
64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit
Seems like the first option there is missing something...
Second option is not relevant to my 32 bit SQL scenario, but good info
nonetheless...
Thanks
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:el$vr3kEHHA.4832@.TK2MSFTNGP06.phx.gbl...
> With no boot ini settings 2 Gigs.
> With /3Gig boot ini 3 Gigs
> With /AWE and SQL Server 2000 32 bit the data cache can see a max of 32
> Gigs with AWE enabled on SQL Server and PAE enabled on Windows 2003 64
> bit. 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
>> I'm tired of Googling for a definitive answer :)
>> What is the max memory SQL Server can access in this setup:
>> SQL 2000, Enterprise edition, 32 bit
>> Windows 2003, EE, 64 bit
>> I'm thinking 32GB from what I've read, but I want to make sure before I
>> tell my customer what to buy...
>> Thanks!
>> --
>> Kevin Hill
>> 3NF Consulting
>> http://www.3nf-inc.com/NewsGroups.htm
>> Real-world stuff I run across with SQL Server:
>> http://kevin3nf.blogspot.com
>>
>|||Thanks Arnie, but the BOL link does not specifically reference Windows 2003
EE, 64 bit (or any other Win2K3 versions...)
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eaVxm0kEHHA.3520@.TK2MSFTNGP04.phx.gbl...
> These should provide the definitive answer you seek.
> Configuration -Maximum Capacity Specifications
> 2000
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
> 2005 http://msdn2.microsoft.com/en-us/library/ms143287.aspx
> 2005 http://msdn2.microsoft.com/en-us/library/ms143432.aspx
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
>> I'm tired of Googling for a definitive answer :)
>> What is the max memory SQL Server can access in this setup:
>> SQL 2000, Enterprise edition, 32 bit
>> Windows 2003, EE, 64 bit
>> I'm thinking 32GB from what I've read, but I want to make sure before I
>> tell my customer what to buy...
>> Thanks!
>> --
>> Kevin Hill
>> 3NF Consulting
>> http://www.3nf-inc.com/NewsGroups.htm
>> Real-world stuff I run across with SQL Server:
>> http://kevin3nf.blogspot.com
>>
>|||That doesn't read well - try this
With SQL Server 2000 EE 32 bit with AWE enable running on Windows 2003 64
bit EE with PAE enabled, the data cache can see a max of 32 Gigs.
With SQL Server 2000 EE 64 bit with AWE enable running on Windows 2003 64
bit EE with PAE enabled, the data cache can see a max of 64 Gigs.
Note that the procedure cache and other caches will still see IIRC 2 Gigs
and most of the OS memory will be used with the 64 address windowing.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:us7AISlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
>A leetle confused here:
> with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit.
> 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit
> Seems like the first option there is missing something...
> Second option is not relevant to my 32 bit SQL scenario, but good info
> nonetheless...
> Thanks
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:el$vr3kEHHA.4832@.TK2MSFTNGP06.phx.gbl...
>> With no boot ini settings 2 Gigs.
>> With /3Gig boot ini 3 Gigs
>> With /AWE and SQL Server 2000 32 bit the data cache can see a max of 32
>> Gigs with AWE enabled on SQL Server and PAE enabled on Windows 2003 64
>> bit. 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit.
>> --
>> Hilary Cotter
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>>
>> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
>> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
>> I'm tired of Googling for a definitive answer :)
>> What is the max memory SQL Server can access in this setup:
>> SQL 2000, Enterprise edition, 32 bit
>> Windows 2003, EE, 64 bit
>> I'm thinking 32GB from what I've read, but I want to make sure before I
>> tell my customer what to buy...
>> Thanks!
>> --
>> Kevin Hill
>> 3NF Consulting
>> http://www.3nf-inc.com/NewsGroups.htm
>> Real-world stuff I run across with SQL Server:
>> http://kevin3nf.blogspot.com
>>
>>
>|||Oops, sorry Kevin, this is a better source for you.
http://www.support.microsoft.com/?id=283037
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:e2a1oSlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
> Thanks Arnie, but the BOL link does not specifically reference Windows
> 2003 EE, 64 bit (or any other Win2K3 versions...)
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:eaVxm0kEHHA.3520@.TK2MSFTNGP04.phx.gbl...
>> These should provide the definitive answer you seek.
>> Configuration -Maximum Capacity Specifications
>> 2000
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
>> 2005 http://msdn2.microsoft.com/en-us/library/ms143287.aspx
>> 2005 http://msdn2.microsoft.com/en-us/library/ms143432.aspx
>>
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>> You can't help someone get up a hill without getting a little closer to
>> the top yourself.
>> - H. Norman Schwarzkopf
>>
>> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
>> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
>> I'm tired of Googling for a definitive answer :)
>> What is the max memory SQL Server can access in this setup:
>> SQL 2000, Enterprise edition, 32 bit
>> Windows 2003, EE, 64 bit
>> I'm thinking 32GB from what I've read, but I want to make sure before I
>> tell my customer what to buy...
>> Thanks!
>> --
>> Kevin Hill
>> 3NF Consulting
>> http://www.3nf-inc.com/NewsGroups.htm
>> Real-world stuff I run across with SQL Server:
>> http://kevin3nf.blogspot.com
>>
>>
>|||Thanks for the clarification :)
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OX3SnVlEHHA.3768@.TK2MSFTNGP06.phx.gbl...
> That doesn't read well - try this
> With SQL Server 2000 EE 32 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 32 Gigs.
> With SQL Server 2000 EE 64 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 64 Gigs.
> Note that the procedure cache and other caches will still see IIRC 2 Gigs
> and most of the OS memory will be used with the 64 address windowing.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:us7AISlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
>>A leetle confused here:
>> with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit.
>> 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit
>> Seems like the first option there is missing something...
>> Second option is not relevant to my 32 bit SQL scenario, but good info
>> nonetheless...
>> Thanks
>> --
>> Kevin Hill
>> 3NF Consulting
>> http://www.3nf-inc.com/NewsGroups.htm
>> Real-world stuff I run across with SQL Server:
>> http://kevin3nf.blogspot.com
>>
>> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
>> news:el$vr3kEHHA.4832@.TK2MSFTNGP06.phx.gbl...
>> With no boot ini settings 2 Gigs.
>> With /3Gig boot ini 3 Gigs
>> With /AWE and SQL Server 2000 32 bit the data cache can see a max of 32
>> Gigs with AWE enabled on SQL Server and PAE enabled on Windows 2003 64
>> bit. 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit.
>> --
>> Hilary Cotter
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>>
>> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
>> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
>> I'm tired of Googling for a definitive answer :)
>> What is the max memory SQL Server can access in this setup:
>> SQL 2000, Enterprise edition, 32 bit
>> Windows 2003, EE, 64 bit
>> I'm thinking 32GB from what I've read, but I want to make sure before I
>> tell my customer what to buy...
>> Thanks!
>> --
>> Kevin Hill
>> 3NF Consulting
>> http://www.3nf-inc.com/NewsGroups.htm
>> Real-world stuff I run across with SQL Server:
>> http://kevin3nf.blogspot.com
>>
>>
>>
>|||But 64-bit Windows does not support PAE.
http://www.microsoft.com/whdc/system/platform/server/PAE/PAEmem.mspx
Linchi
"Hilary Cotter" wrote:
> That doesn't read well - try this
> With SQL Server 2000 EE 32 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 32 Gigs.
> With SQL Server 2000 EE 64 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 64 Gigs.
> Note that the procedure cache and other caches will still see IIRC 2 Gigs
> and most of the OS memory will be used with the 64 address windowing.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:us7AISlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
> >A leetle confused here:
> >
> > with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit.
> >
> > 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit
> >
> > Seems like the first option there is missing something...
> >
> > Second option is not relevant to my 32 bit SQL scenario, but good info
> > nonetheless...
> >
> > Thanks
> > --
> > Kevin Hill
> > 3NF Consulting
> > http://www.3nf-inc.com/NewsGroups.htm
> >
> > Real-world stuff I run across with SQL Server:
> > http://kevin3nf.blogspot.com
> >
> >
> > "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> > news:el$vr3kEHHA.4832@.TK2MSFTNGP06.phx.gbl...
> >> With no boot ini settings 2 Gigs.
> >> With /3Gig boot ini 3 Gigs
> >> With /AWE and SQL Server 2000 32 bit the data cache can see a max of 32
> >> Gigs with AWE enabled on SQL Server and PAE enabled on Windows 2003 64
> >> bit. 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit.
> >>
> >> --
> >> Hilary Cotter
> >>
> >> Looking for a SQL Server replication book?
> >> http://www.nwsu.com/0974973602.html
> >>
> >> Looking for a FAQ on Indexing Services/SQL FTS
> >> http://www.indexserverfaq.com
> >>
> >>
> >>
> >> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> >> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
> >> I'm tired of Googling for a definitive answer :)
> >>
> >> What is the max memory SQL Server can access in this setup:
> >>
> >> SQL 2000, Enterprise edition, 32 bit
> >> Windows 2003, EE, 64 bit
> >>
> >> I'm thinking 32GB from what I've read, but I want to make sure before I
> >> tell my customer what to buy...
> >>
> >> Thanks!
> >>
> >> --
> >> Kevin Hill
> >> 3NF Consulting
> >> http://www.3nf-inc.com/NewsGroups.htm
> >>
> >> Real-world stuff I run across with SQL Server:
> >> http://kevin3nf.blogspot.com
> >>
> >>
> >>
> >>
> >>
> >
> >
>
>
Max memory on 32/64 bit
I'm tired of Googling for a definitive answer
What is the max memory SQL Server can access in this setup:
SQL 2000, Enterprise edition, 32 bit
Windows 2003, EE, 64 bit
I'm thinking 32GB from what I've read, but I want to make sure before I tell
my customer what to buy...
Thanks!
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.comThese should provide the definitive answer you seek.
Configuration -Maximum Capacity Specifications
2000
http://msdn.microsoft.com/library/d...br />
8dbn.asp
2005 http://msdn2.microsoft.com/en-us/library/ms143287.aspx
2005 http://msdn2.microsoft.com/en-us/library/ms143432.aspx
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
> I'm tired of Googling for a definitive answer
> What is the max memory SQL Server can access in this setup:
> SQL 2000, Enterprise edition, 32 bit
> Windows 2003, EE, 64 bit
> I'm thinking 32GB from what I've read, but I want to make sure before I
> tell my customer what to buy...
> Thanks!
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
>|||With no boot ini settings 2 Gigs.
With /3Gig boot ini 3 Gigs
With /AWE and SQL Server 2000 32 bit the data cache can see a max of 32 Gigs
with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit. 64
bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
> I'm tired of Googling for a definitive answer
> What is the max memory SQL Server can access in this setup:
> SQL 2000, Enterprise edition, 32 bit
> Windows 2003, EE, 64 bit
> I'm thinking 32GB from what I've read, but I want to make sure before I
> tell my customer what to buy...
> Thanks!
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
>|||A leetle confused here:
with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit.
64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit
Seems like the first option there is missing something...
Second option is not relevant to my 32 bit SQL scenario, but good info
nonetheless...
Thanks
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:el$vr3kEHHA.4832@.TK2MSFTNGP06.phx.gbl...
> With no boot ini settings 2 Gigs.
> With /3Gig boot ini 3 Gigs
> With /AWE and SQL Server 2000 32 bit the data cache can see a max of 32
> Gigs with AWE enabled on SQL Server and PAE enabled on Windows 2003 64
> bit. 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
>|||Thanks Arnie, but the BOL link does not specifically reference Windows 2003
EE, 64 bit (or any other Win2K3 versions...)
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eaVxm0kEHHA.3520@.TK2MSFTNGP04.phx.gbl...
> These should provide the definitive answer you seek.
> Configuration -Maximum Capacity Specifications
> 2000
> http://msdn.microsoft.com/library/d... />
s_8dbn.asp
> 2005 http://msdn2.microsoft.com/en-us/library/ms143287.aspx
> 2005 http://msdn2.microsoft.com/en-us/library/ms143432.aspx
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
>|||That doesn't read well - try this
With SQL Server 2000 EE 32 bit with AWE enable running on Windows 2003 64
bit EE with PAE enabled, the data cache can see a max of 32 Gigs.
With SQL Server 2000 EE 64 bit with AWE enable running on Windows 2003 64
bit EE with PAE enabled, the data cache can see a max of 64 Gigs.
Note that the procedure cache and other caches will still see IIRC 2 Gigs
and most of the OS memory will be used with the 64 address windowing.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:us7AISlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
>A leetle confused here:
> with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit.
> 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit
> Seems like the first option there is missing something...
> Second option is not relevant to my 32 bit SQL scenario, but good info
> nonetheless...
> Thanks
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:el$vr3kEHHA.4832@.TK2MSFTNGP06.phx.gbl...
>|||Oops, sorry Kevin, this is a better source for you.
http://www.support.microsoft.com/?id=283037
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:e2a1oSlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
> Thanks Arnie, but the BOL link does not specifically reference Windows
> 2003 EE, 64 bit (or any other Win2K3 versions...)
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:eaVxm0kEHHA.3520@.TK2MSFTNGP04.phx.gbl...
>|||Thanks for the clarification
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OX3SnVlEHHA.3768@.TK2MSFTNGP06.phx.gbl...
> That doesn't read well - try this
> With SQL Server 2000 EE 32 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 32 Gigs.
> With SQL Server 2000 EE 64 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 64 Gigs.
> Note that the procedure cache and other caches will still see IIRC 2 Gigs
> and most of the OS memory will be used with the 64 address windowing.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:us7AISlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
>|||But 64-bit Windows does not support PAE.
http://www.microsoft.com/whdc/syste...PAE/PAEmem.mspx
Linchi
"Hilary Cotter" wrote:
> That doesn't read well - try this
> With SQL Server 2000 EE 32 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 32 Gigs.
> With SQL Server 2000 EE 64 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 64 Gigs.
> Note that the procedure cache and other caches will still see IIRC 2 Gigs
> and most of the OS memory will be used with the 64 address windowing.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:us7AISlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
>
>
What is the max memory SQL Server can access in this setup:
SQL 2000, Enterprise edition, 32 bit
Windows 2003, EE, 64 bit
I'm thinking 32GB from what I've read, but I want to make sure before I tell
my customer what to buy...
Thanks!
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.comThese should provide the definitive answer you seek.
Configuration -Maximum Capacity Specifications
2000
http://msdn.microsoft.com/library/d...br />
8dbn.asp
2005 http://msdn2.microsoft.com/en-us/library/ms143287.aspx
2005 http://msdn2.microsoft.com/en-us/library/ms143432.aspx
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
> I'm tired of Googling for a definitive answer
> What is the max memory SQL Server can access in this setup:
> SQL 2000, Enterprise edition, 32 bit
> Windows 2003, EE, 64 bit
> I'm thinking 32GB from what I've read, but I want to make sure before I
> tell my customer what to buy...
> Thanks!
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
>|||With no boot ini settings 2 Gigs.
With /3Gig boot ini 3 Gigs
With /AWE and SQL Server 2000 32 bit the data cache can see a max of 32 Gigs
with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit. 64
bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
> I'm tired of Googling for a definitive answer
> What is the max memory SQL Server can access in this setup:
> SQL 2000, Enterprise edition, 32 bit
> Windows 2003, EE, 64 bit
> I'm thinking 32GB from what I've read, but I want to make sure before I
> tell my customer what to buy...
> Thanks!
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
>|||A leetle confused here:
with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit.
64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit
Seems like the first option there is missing something...
Second option is not relevant to my 32 bit SQL scenario, but good info
nonetheless...
Thanks
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:el$vr3kEHHA.4832@.TK2MSFTNGP06.phx.gbl...
> With no boot ini settings 2 Gigs.
> With /3Gig boot ini 3 Gigs
> With /AWE and SQL Server 2000 32 bit the data cache can see a max of 32
> Gigs with AWE enabled on SQL Server and PAE enabled on Windows 2003 64
> bit. 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
>|||Thanks Arnie, but the BOL link does not specifically reference Windows 2003
EE, 64 bit (or any other Win2K3 versions...)
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:eaVxm0kEHHA.3520@.TK2MSFTNGP04.phx.gbl...
> These should provide the definitive answer you seek.
> Configuration -Maximum Capacity Specifications
> 2000
> http://msdn.microsoft.com/library/d... />
s_8dbn.asp
> 2005 http://msdn2.microsoft.com/en-us/library/ms143287.aspx
> 2005 http://msdn2.microsoft.com/en-us/library/ms143432.aspx
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:OC2SSikEHHA.3524@.TK2MSFTNGP06.phx.gbl...
>|||That doesn't read well - try this
With SQL Server 2000 EE 32 bit with AWE enable running on Windows 2003 64
bit EE with PAE enabled, the data cache can see a max of 32 Gigs.
With SQL Server 2000 EE 64 bit with AWE enable running on Windows 2003 64
bit EE with PAE enabled, the data cache can see a max of 64 Gigs.
Note that the procedure cache and other caches will still see IIRC 2 Gigs
and most of the OS memory will be used with the 64 address windowing.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:us7AISlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
>A leetle confused here:
> with AWE enabled on SQL Server and PAE enabled on Windows 2003 64 bit.
> 64 bit SQL 2000 EE can see 64 Gigs on Windows 2003 64 bit
> Seems like the first option there is missing something...
> Second option is not relevant to my 32 bit SQL scenario, but good info
> nonetheless...
> Thanks
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:el$vr3kEHHA.4832@.TK2MSFTNGP06.phx.gbl...
>|||Oops, sorry Kevin, this is a better source for you.
http://www.support.microsoft.com/?id=283037
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:e2a1oSlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
> Thanks Arnie, but the BOL link does not specifically reference Windows
> 2003 EE, 64 bit (or any other Win2K3 versions...)
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:eaVxm0kEHHA.3520@.TK2MSFTNGP04.phx.gbl...
>|||Thanks for the clarification
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OX3SnVlEHHA.3768@.TK2MSFTNGP06.phx.gbl...
> That doesn't read well - try this
> With SQL Server 2000 EE 32 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 32 Gigs.
> With SQL Server 2000 EE 64 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 64 Gigs.
> Note that the procedure cache and other caches will still see IIRC 2 Gigs
> and most of the OS memory will be used with the 64 address windowing.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:us7AISlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
>|||But 64-bit Windows does not support PAE.
http://www.microsoft.com/whdc/syste...PAE/PAEmem.mspx
Linchi
"Hilary Cotter" wrote:
> That doesn't read well - try this
> With SQL Server 2000 EE 32 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 32 Gigs.
> With SQL Server 2000 EE 64 bit with AWE enable running on Windows 2003 64
> bit EE with PAE enabled, the data cache can see a max of 64 Gigs.
> Note that the procedure cache and other caches will still see IIRC 2 Gigs
> and most of the OS memory will be used with the 64 address windowing.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:us7AISlEHHA.4380@.TK2MSFTNGP04.phx.gbl...
>
>
max memory for 2003 & 2k
Hi all,
I have a Sql Server Enterprise edition running under Windows Server 2003,
Standard Edition, and my hardware supports up to 16 gigs of RAM.
Currently I am running fine with 4 gigs and switch /3GB. I was wondering
however if it would be possible to upgrade up to 16 gigs RAM with same
configuration, I mean, same sql & windows version, and only setting /PAE, AW
E
and max memory for the server to 15.
Thanks in advance,
TristanI think Windows 2003 Server Standard edition only supports up to 4 GB of RAM
.
http://www.microsoft.com/windowsser...es.msp
x
--
MG
"Tristan" wrote:
> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE,
AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>|||I think you will need to upgrade Windows 2003 to Enterprise
http://www.microsoft.com/windowsser...es.msp
x
Maximum Capacity Specifications (SQL Server 2000)
http://msdn.microsoft.com/library/d...br />
8dbn.asp
"Tristan" wrote:
> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE,
AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>
I have a Sql Server Enterprise edition running under Windows Server 2003,
Standard Edition, and my hardware supports up to 16 gigs of RAM.
Currently I am running fine with 4 gigs and switch /3GB. I was wondering
however if it would be possible to upgrade up to 16 gigs RAM with same
configuration, I mean, same sql & windows version, and only setting /PAE, AW
E
and max memory for the server to 15.
Thanks in advance,
TristanI think Windows 2003 Server Standard edition only supports up to 4 GB of RAM
.
http://www.microsoft.com/windowsser...es.msp
x
--
MG
"Tristan" wrote:
> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE,
AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>|||I think you will need to upgrade Windows 2003 to Enterprise
http://www.microsoft.com/windowsser...es.msp
x
Maximum Capacity Specifications (SQL Server 2000)
http://msdn.microsoft.com/library/d...br />
8dbn.asp
"Tristan" wrote:
> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE,
AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>
max memory for 2003 & 2k
Hi all,
I have a Sql Server Enterprise edition running under Windows Server 2003,
Standard Edition, and my hardware supports up to 16 gigs of RAM.
Currently I am running fine with 4 gigs and switch /3GB. I was wondering
however if it would be possible to upgrade up to 16 gigs RAM with same
configuration, I mean, same sql & windows version, and only setting /PAE, AWE
and max memory for the server to 15.
Thanks in advance,
TristanI think Windows 2003 Server Standard edition only supports up to 4 GB of RAM.
http://www.microsoft.com/windowsserver2003/evaluation/features/comparefeatures.mspx
--
MG
"Tristan" wrote:
> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE, AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>|||I think you will need to upgrade Windows 2003 to Enterprise
http://www.microsoft.com/windowsserver2003/evaluation/features/comparefeatures.mspx
Maximum Capacity Specifications (SQL Server 2000)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
"Tristan" wrote:
> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE, AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>
I have a Sql Server Enterprise edition running under Windows Server 2003,
Standard Edition, and my hardware supports up to 16 gigs of RAM.
Currently I am running fine with 4 gigs and switch /3GB. I was wondering
however if it would be possible to upgrade up to 16 gigs RAM with same
configuration, I mean, same sql & windows version, and only setting /PAE, AWE
and max memory for the server to 15.
Thanks in advance,
TristanI think Windows 2003 Server Standard edition only supports up to 4 GB of RAM.
http://www.microsoft.com/windowsserver2003/evaluation/features/comparefeatures.mspx
--
MG
"Tristan" wrote:
> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE, AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>|||I think you will need to upgrade Windows 2003 to Enterprise
http://www.microsoft.com/windowsserver2003/evaluation/features/comparefeatures.mspx
Maximum Capacity Specifications (SQL Server 2000)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
"Tristan" wrote:
> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE, AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>
Monday, February 20, 2012
master, model & msdb in database list
On a new, clustered, install of SQL Server 2000, I can't see the master,
model, msdb & tempdb databases in the Database list of Enterprise Manager.
I suspect I may have changed a setting, but I'm not sure what, or where.That is a setting in EM for the registered server. From memory: right-click the registered server,
select "Edit server registration" and you will find an option whether to hide system objects.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jay" <nospan@.nospam.org> wrote in message news:%236DFzT9HIHA.1188@.TK2MSFTNGP04.phx.gbl...
> On a new, clustered, install of SQL Server 2000, I can't see the master, model, msdb & tempdb
> databases in the Database list of Enterprise Manager.
> I suspect I may have changed a setting, but I'm not sure what, or where.
>
>|||Try this,
On Enterprise Manager, right-clik your server and select Edit SQL Server
Registration Properties and check the box 'Show system databases and system
objects'. Click Ok. Your system databases must be there.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Jay" wrote:
> On a new, clustered, install of SQL Server 2000, I can't see the master,
> model, msdb & tempdb databases in the Database list of Enterprise Manager.
> I suspect I may have changed a setting, but I'm not sure what, or where.
>
>|||Excellent, thanks guys
"Jay" <nospan@.nospam.org> wrote in message
news:%236DFzT9HIHA.1188@.TK2MSFTNGP04.phx.gbl...
> On a new, clustered, install of SQL Server 2000, I can't see the master,
> model, msdb & tempdb databases in the Database list of Enterprise Manager.
> I suspect I may have changed a setting, but I'm not sure what, or where.
>
>
model, msdb & tempdb databases in the Database list of Enterprise Manager.
I suspect I may have changed a setting, but I'm not sure what, or where.That is a setting in EM for the registered server. From memory: right-click the registered server,
select "Edit server registration" and you will find an option whether to hide system objects.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jay" <nospan@.nospam.org> wrote in message news:%236DFzT9HIHA.1188@.TK2MSFTNGP04.phx.gbl...
> On a new, clustered, install of SQL Server 2000, I can't see the master, model, msdb & tempdb
> databases in the Database list of Enterprise Manager.
> I suspect I may have changed a setting, but I'm not sure what, or where.
>
>|||Try this,
On Enterprise Manager, right-clik your server and select Edit SQL Server
Registration Properties and check the box 'Show system databases and system
objects'. Click Ok. Your system databases must be there.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Jay" wrote:
> On a new, clustered, install of SQL Server 2000, I can't see the master,
> model, msdb & tempdb databases in the Database list of Enterprise Manager.
> I suspect I may have changed a setting, but I'm not sure what, or where.
>
>|||Excellent, thanks guys
"Jay" <nospan@.nospam.org> wrote in message
news:%236DFzT9HIHA.1188@.TK2MSFTNGP04.phx.gbl...
> On a new, clustered, install of SQL Server 2000, I can't see the master,
> model, msdb & tempdb databases in the Database list of Enterprise Manager.
> I suspect I may have changed a setting, but I'm not sure what, or where.
>
>
Subscribe to:
Posts (Atom)