Re: /3GB switch in 64-bit environment

Travis,

SQL Server 2005, Standard Edition allows 4 GB memory -if that's of any help.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Travis" <Travis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5BA4C598-BBE4-4C41-92FA-9DCC117E4C80@xxxxxxxxxxxxxxxx
Oops, I was interpreting his tables wrong. Thanks for pointing that out.

"Arnie Rowland" wrote:


From:
http://www.sql-server-performance.com/jc_system_storage_configuration.asp

The table below shows SQL Server 2000 processor and memory support by
edition. The SQL Server 2000 64-bit version is for Itanium only.


SQL Server 2000 Processor and Memory support by Edition Standard
Ed. 32-bit / 64-bit
Enterprise Ed. 32-bit / 64-bit

Max Processor (Sockets)
4
No Limit

Max Memory
2GB
64GB / 512GB



--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Travis" <Travis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0C788E6E-8282-4A9A-8627-5E81DAF97DE6@xxxxxxxxxxxxxxxx
Not according to 64-bit windows. You should be able to use the /3GB
switch
in a 64-bit environment. SQL 2000 standard can use it and SQL 2005
standard
can use up to the Operating System's Max memory. Here is the link I
got
my
info from:
http://www.sql-server-performance.com/jc_system_storage_configuration.asp

"Tom" wrote:

SQL2000 Standard si limited to 2GB. You need to upgrade to SQL 2000
Enterprise or SQL2005 Standard to use above 2GB of RAM .


Tom.


"Travis" <Travis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5C22333E-60F0-481D-9632-69B4CA16B059@xxxxxxxxxxxxxxxx
I already moved the max memory setting to 3072.

"Arnie Rowland" wrote:

You have to also change the max memory setting in SQL Server
properties.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Travis" <Travis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B6EB6A58-99DD-47F9-95A3-61777697C52F@xxxxxxxxxxxxxxxx
I recently put in the /3GB switch on our Windows 2003 Server R2
boot.ini
file. We are running SQL 2000 Standard. After the reboot our
physical
memory is not going over 2GB. Is there something else I missed?
Thanks.












.

Relevant Pages

  • Re: Locking pages in memory
    ... I have confirmed that SQL Server Standard 64-bit does not use locked pages in memory, even if available in the OS. ... There are some complex reasons behind this, but basically, if you are running on 64-bit Windows, you probably don't need to lock pages in memory. ...
    (microsoft.public.sqlserver.setup)
  • Re: Windows 2003 SP1 standard + SQL 2005 standard
    ... Enterprise Edition includes clustering, large memory ... Most good judgment comes from experience. ... WRT the cpus unfortunately woodcrest doesn't support HT yet .. ... you will want SQL Server to startup with the /3GB ...
    (microsoft.public.sqlserver.setup)
  • Re: Benchmark for different edition SQL 2000
    ... Please read the links I posted about memory allocation algorithms in SQL Server. ... My concern is how to prevent the SQL server that increase the memory usage continuously? ... Enterprise edition has some distinct features that SE doesn't. ... the memory arrangement is the same between standard and enterprise? ...
    (microsoft.public.sqlserver.server)
  • Re: Locking pages in memory
    ... So I think the 64-bit Standard does not support locked pages in memory. ... Rick Byham, SQL Server Books Online ...
    (microsoft.public.sqlserver.setup)
  • Re: Windows 2003 SP1 standard + SQL 2005 standard
    ... WRT the memory that great finally a definitive answer .. ... you will want SQL Server to startup with the /3GB switch. ... dual core CPUs), the standard license allows scaling up to 4 'actual' ...
    (microsoft.public.sqlserver.setup)