How to use more than 2GB memory in SQL Server 2K under Windows 2K Server?

I have a Windows 2K server with 4GB RAM running SQL Server
2K enterprise version.
Currently I have /3GB switch in boot.ini and have
allocated 3GB to SQL server using max memory. But I find
upto 2GB can be used only. It seems "/3GB" switch not to
work , is it because using Windows 2K server rather than
using Windows 2K advanced server ? Are ther any methods I
can use to use more than 2GB memory in SQL Server 2K
under "Windows 2K server" environment ? Thanks !!In the SQL Server Enterprise Manager, right-click Servername and (left)
click Properties. Open the Memory Tab. You can set here the memory you want
to allocate...
"Jackson" <kycheng@.cht.com.tw> wrote in message
news:2b03a01c392cd$c4127200$a601280a@.phx.gbl...
> I have a Windows 2K server with 4GB RAM running SQL Server
> 2K enterprise version.
> Currently I have /3GB switch in boot.ini and have
> allocated 3GB to SQL server using max memory. But I find
> upto 2GB can be used only. It seems "/3GB" switch not to
> work , is it because using Windows 2K server rather than
> using Windows 2K advanced server ? Are ther any methods I
> can use to use more than 2GB memory in SQL Server 2K
> under "Windows 2K server" environment ? Thanks !!
>|||AFAIK, on W2K Server, you are limited to 2GB memory for an app, by purpose of the server edition.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Jackson" <kycheng@.cht.com.tw> wrote in message news:2b03a01c392cd$c4127200$a601280a@.phx.gbl...
> I have a Windows 2K server with 4GB RAM running SQL Server
> 2K enterprise version.
> Currently I have /3GB switch in boot.ini and have
> allocated 3GB to SQL server using max memory. But I find
> upto 2GB can be used only. It seems "/3GB" switch not to
> work , is it because using Windows 2K server rather than
> using Windows 2K advanced server ? Are ther any methods I
> can use to use more than 2GB memory in SQL Server 2K
> under "Windows 2K server" environment ? Thanks !!
>|||Q274750 HOW TO: Configure Memory for More Than 2 GB in SQL Server
http://support.microsoft.com/support/kb/articles/q274/7/50.asp
You will need Win2k Adv to use the /3GB switch.
g.
--
http://www.sqlskunkworks.com
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||This is an excerpt from the article:
Support for Operating System Versions
Windows 2000 Server
SQL Server 2000
Normally, both the SQL Server 2000 Enterprise Edition and SQL Server 2000
Developer Edition can use up to 2 GB of physical memory. With the use of the
AWE enable option, SQL Server can use up to 4 GB of physical memory.
So if you are using W2K Server / SS2K Enterprise edition, you should be able
to address 3GB with the /3GB switch.
"Guy" <guy@.sqlskunkworks.com> wrote in message
news:upnwSfukDHA.392@.TK2MSFTNGP11.phx.gbl...
> Q274750 HOW TO: Configure Memory for More Than 2 GB in SQL Server
> http://support.microsoft.com/support/kb/articles/q274/7/50.asp
> You will need Win2k Adv to use the /3GB switch.
> g.
> --
> http://www.sqlskunkworks.com
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||The documentation is misleading. You need BOTH Enterprise edition and
advanced server to get at > 2GB
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
"Quentin Ran" <ab@.who.com> wrote in message
news:OiSQvnAlDHA.2244@.TK2MSFTNGP12.phx.gbl...
> This is an excerpt from the article:
> Support for Operating System Versions
> Windows 2000 Server
> SQL Server 2000
> Normally, both the SQL Server 2000 Enterprise Edition and SQL Server 2000
> Developer Edition can use up to 2 GB of physical memory. With the use of
the
> AWE enable option, SQL Server can use up to 4 GB of physical memory.
> So if you are using W2K Server / SS2K Enterprise edition, you should be
able
> to address 3GB with the /3GB switch.
>
> "Guy" <guy@.sqlskunkworks.com> wrote in message
> news:upnwSfukDHA.392@.TK2MSFTNGP11.phx.gbl...
> > Q274750 HOW TO: Configure Memory for More Than 2 GB in SQL Server
> > http://support.microsoft.com/support/kb/articles/q274/7/50.asp
> >
> > You will need Win2k Adv to use the /3GB switch.
> >
> > g.
> > --
> > http://www.sqlskunkworks.com
> >
> > *** Sent via Developersdex http://www.developersdex.com ***
> > Don't just participate in USENET...get rewarded for it!
>