Showing posts with label ini. Show all posts
Showing posts with label ini. Show all posts

Monday, March 12, 2012

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!
>