Is it true that SQL Server Standard edition can only use 2 GB of RAM?
If so, and the box has more, does that mean the excess WILL be
available for the O/S and any other apps? 10 3041
You are correct
(assuming we are talking about SQL server 2000 standard edition)
GL
"Ellen K." <72************************@compuserve.com> wrote in message
news:ia********************************@4ax.com... Is it true that SQL Server Standard edition can only use 2 GB of RAM?
If so, and the box has more, does that mean the excess WILL be available for the O/S and any other apps?
Thanks.
On Wed, 21 Apr 2004 11:01:28 -0700, "GL"
<GL@noSpam.ReplyToNewsgroup.com> wrote: You are correct
(assuming we are talking about SQL server 2000 standard edition)
GL
"Ellen K." <72************************@compuserve.com> wrote in message news:ia********************************@4ax.com.. . Is it true that SQL Server Standard edition can only use 2 GB of RAM?
If so, and the box has more, does that mean the excess WILL be available for the O/S and any other apps?
I didn't know the O/S itself limits us to 4 GB, that is very important
information, thank you. But at least if the 2 GB that SQL Server
can't use WILL be used by the O/S, we are probably good.
On Wed, 21 Apr 2004 15:41:22 -0400, "Daniel A. Thomas"
<dathomas@--spam--istar.ca> wrote: "Ellen K." <72************************@compuserve.com> wrote in message news:ia********************************@4ax.com.. . | Is it true that SQL Server Standard edition can only use 2 GB of RAM? | | If so, and the box has more, does that mean the excess WILL be | available for the O/S and any other apps?
Keep your OS specifications in mind when choosing your version of SQL Server. For example, Windows Server 2000 / 2003 Standard Edition has the following memory specifications:
Support for up to 4GB of memory. Of that 4GB, the operating system always reserves anything above 2GB for its own use. This allows applications on the server to share a maximum of 2GB.
Dan Thomas
If you move to Windows 2003 Server, those memory limits are raised...
See this MS page for more info on Windows Server 2003 specs: http://www.microsoft.com/windowsserv...eeditions.mspx
GL
"Ellen K." <72************************@compuserve.com> wrote in message
news:7g********************************@4ax.com... I didn't know the O/S itself limits us to 4 GB, that is very important information, thank you. But at least if the 2 GB that SQL Server can't use WILL be used by the O/S, we are probably good.
On Wed, 21 Apr 2004 15:41:22 -0400, "Daniel A. Thomas" <dathomas@--spam--istar.ca> wrote:
"Ellen K." <72************************@compuserve.com> wrote in message news:ia********************************@4ax.com.. . | Is it true that SQL Server Standard edition can only use 2 GB of RAM? | | If so, and the box has more, does that mean the excess WILL be | available for the O/S and any other apps?
Keep your OS specifications in mind when choosing your version of SQL Server. For example, Windows Server 2000 / 2003 Standard Edition has the following memory specifications:
Support for up to 4GB of memory. Of that 4GB, the operating system always reserves anything above 2GB for its own use. This allows applications on the server to share a maximum of 2GB.
Dan Thomas
"Ellen K." <72************************@compuserve.com> wrote in message
news:ia********************************@4ax.com...
| Is it true that SQL Server Standard edition can only use 2 GB of RAM?
|
| If so, and the box has more, does that mean the excess WILL be
| available for the O/S and any other apps?
Keep your OS specifications in mind when choosing your version of SQL
Server. For example, Windows Server 2000 / 2003 Standard Edition has the
following memory specifications:
Support for up to 4GB of memory. Of that 4GB, the operating system always
reserves anything above 2GB for its own use. This allows applications
on the server to share a maximum of 2GB.
Dan Thomas
That page still shows 4 GB for the Standard Edition, but it's a good
reference, thanks. :)
I think we will be fine with 4 GB.
On Thu, 22 Apr 2004 10:19:17 -0700, "GL"
<GL@noSpam.ReplyToNewsgroup.com> wrote: If you move to Windows 2003 Server, those memory limits are raised...
See this MS page for more info on Windows Server 2003 specs: http://www.microsoft.com/windowsserv...eeditions.mspx
GL
"Ellen K." <72************************@compuserve.com> wrote in message news:7g********************************@4ax.com.. . I didn't know the O/S itself limits us to 4 GB, that is very important information, thank you. But at least if the 2 GB that SQL Server can't use WILL be used by the O/S, we are probably good.
On Wed, 21 Apr 2004 15:41:22 -0400, "Daniel A. Thomas" <dathomas@--spam--istar.ca> wrote:
> >"Ellen K." <72************************@compuserve.com> wrote in message >news:ia********************************@4ax.com.. . >| Is it true that SQL Server Standard edition can only use 2 GB of RAM? >| >| If so, and the box has more, does that mean the excess WILL be >| available for the O/S and any other apps? > > >Keep your OS specifications in mind when choosing your version of SQL >Server. For example, Windows Server 2000 / 2003 Standard Edition has the >following memory specifications: > >Support for up to 4GB of memory. Of that 4GB, the operating system always >reserves anything above 2GB for its own use. This allows applications >on the server to share a maximum of 2GB. > >Dan Thomas
Thanks.
On Wed, 21 Apr 2004 11:01:28 -0700, "GL"
<GL@noSpam.ReplyToNewsgroup.com> wrote: You are correct
(assuming we are talking about SQL server 2000 standard edition)
GL
"Ellen K." <72************************@compuserve.com> wrote in message news:ia********************************@4ax.com.. . Is it true that SQL Server Standard edition can only use 2 GB of RAM?
If so, and the box has more, does that mean the excess WILL be available for the O/S and any other apps?
I didn't know the O/S itself limits us to 4 GB, that is very important
information, thank you. But at least if the 2 GB that SQL Server
can't use WILL be used by the O/S, we are probably good.
On Wed, 21 Apr 2004 15:41:22 -0400, "Daniel A. Thomas"
<dathomas@--spam--istar.ca> wrote: "Ellen K." <72************************@compuserve.com> wrote in message news:ia********************************@4ax.com.. . | Is it true that SQL Server Standard edition can only use 2 GB of RAM? | | If so, and the box has more, does that mean the excess WILL be | available for the O/S and any other apps?
Keep your OS specifications in mind when choosing your version of SQL Server. For example, Windows Server 2000 / 2003 Standard Edition has the following memory specifications:
Support for up to 4GB of memory. Of that 4GB, the operating system always reserves anything above 2GB for its own use. This allows applications on the server to share a maximum of 2GB.
Dan Thomas
If you move to Windows 2003 Server, those memory limits are raised...
See this MS page for more info on Windows Server 2003 specs: http://www.microsoft.com/windowsserv...eeditions.mspx
GL
"Ellen K." <72************************@compuserve.com> wrote in message
news:7g********************************@4ax.com... I didn't know the O/S itself limits us to 4 GB, that is very important information, thank you. But at least if the 2 GB that SQL Server can't use WILL be used by the O/S, we are probably good.
On Wed, 21 Apr 2004 15:41:22 -0400, "Daniel A. Thomas" <dathomas@--spam--istar.ca> wrote:
"Ellen K." <72************************@compuserve.com> wrote in message news:ia********************************@4ax.com.. . | Is it true that SQL Server Standard edition can only use 2 GB of RAM? | | If so, and the box has more, does that mean the excess WILL be | available for the O/S and any other apps?
Keep your OS specifications in mind when choosing your version of SQL Server. For example, Windows Server 2000 / 2003 Standard Edition has the following memory specifications:
Support for up to 4GB of memory. Of that 4GB, the operating system always reserves anything above 2GB for its own use. This allows applications on the server to share a maximum of 2GB.
Dan Thomas
That page still shows 4 GB for the Standard Edition, but it's a good
reference, thanks. :)
I think we will be fine with 4 GB.
On Thu, 22 Apr 2004 10:19:17 -0700, "GL"
<GL@noSpam.ReplyToNewsgroup.com> wrote: If you move to Windows 2003 Server, those memory limits are raised...
See this MS page for more info on Windows Server 2003 specs: http://www.microsoft.com/windowsserv...eeditions.mspx
GL
"Ellen K." <72************************@compuserve.com> wrote in message news:7g********************************@4ax.com.. . I didn't know the O/S itself limits us to 4 GB, that is very important information, thank you. But at least if the 2 GB that SQL Server can't use WILL be used by the O/S, we are probably good.
On Wed, 21 Apr 2004 15:41:22 -0400, "Daniel A. Thomas" <dathomas@--spam--istar.ca> wrote:
> >"Ellen K." <72************************@compuserve.com> wrote in message >news:ia********************************@4ax.com.. . >| Is it true that SQL Server Standard edition can only use 2 GB of RAM? >| >| If so, and the box has more, does that mean the excess WILL be >| available for the O/S and any other apps? > > >Keep your OS specifications in mind when choosing your version of SQL >Server. For example, Windows Server 2000 / 2003 Standard Edition has the >following memory specifications: > >Support for up to 4GB of memory. Of that 4GB, the operating system always >reserves anything above 2GB for its own use. This allows applications >on the server to share a maximum of 2GB. > >Dan Thomas This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: William C. White |
last post by:
Does anyone know of a way to use PHP /w Authorize.net AIM without using
cURL? Our website is hosted on a shared drive and the webhost company
doesn't installed additional software (such as cURL)...
|
by: Albert Ahtenberg |
last post by:
Hello,
I don't know if it is only me but I was sure that header("Location:url")
redirects the browser instantly to URL, or at least stops the execution of
the code. But appearantely it continues...
|
by: James |
last post by:
Hi,
I have a form with 2 fields.
'A'
'B'
The user completes one of the fields and the form is submitted.
On the results page I want to run a query, but this will change
subject to which...
|
by: Ollivier Robert |
last post by:
Hello,
I'm trying to link PHP with Oracle 9.2.0/OCI8 with gcc 3.2.3 on a Solaris9
system. The link succeeds but everytime I try to run php, I get a SEGV from
inside the libcnltsh.so library.
...
|
by: Richard Galli |
last post by:
I want viewers to compare state laws on a single subject.
Imagine a three-column table with a drop-down box on the top. A viewer
selects a state from the list, and that state's text fills the...
|
by: Albert Ahtenberg |
last post by:
Hello,
I have two questions.
1. When the user presses the back button and returns to a form he filled
the form is reseted. How do I leave there the values he inserted?
2. When the...
|
by: inderjit S Gabrie |
last post by:
Hi all
Here is the scenerio ...is it possibly to do this...
i am getting valid course dates output on to a web which i have designed
....all is okay so far , look at the following web url
...
|
by: Jack |
last post by:
Hi All,
What is the PHP equivilent of Oracle bind variables in a SQL statement, e.g.
select x from y where z=:parameter
Which in asp/jsp would be followed by some statements to bind a value...
|
by: Sandwick |
last post by:
I am trying to change the size of a drawing so they are all 3x3.
the script below is what i was trying to use to cut it in half ... I
get errors.
I can display the normal picture but not the...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |