hi experts,
I am running MSSQL Standard edition on a dedicated Win2003 server with 3 GIG
RAM. SqlServer now uses 1,83 GB. I am not sure if and how the /3G and /AWE
switches can help using more RAM.
Thanks for every info!
BerndCheck on these KB Articles :
Using /3GB or /PAE and AWE with SQL Server:
http://support.microsoft.com/default.aspx?scid=kb;en-us;555068&Product=sql2k
HOW TO: Configure memory for more than 2 GB in SQL Server:
http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&Product=sql2k
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Bernd Maierhofer (dato)" <bernd.maierhofer@.dato.at> wrote in message
news:%23IWOxSlNEHA.1608@.TK2MSFTNGP12.phx.gbl...
> hi experts,
> I am running MSSQL Standard edition on a dedicated Win2003 server with 3
GIG
> RAM. SqlServer now uses 1,83 GB. I am not sure if and how the /3G and
/AWE
> switches can help using more RAM.
> Thanks for every info!
> Bernd
>
Showing posts with label win2003. Show all posts
Showing posts with label win2003. Show all posts
Wednesday, March 7, 2012
Memory question
I've been reading a lot of the posts about memory but I'm still unclear.
We have 3.37GB RAM - Win2003 SP1 - SQL2005 SP1.
Min Server Memory = 0
Max Server Memory=2147483647
Will SQL use more than 2GB memory with this setup. I saw note of a boot.ini
file in other posts but I couldn't find one on our server. Will SQL use 3GB
if it needs it?
Thanks.
RonHi
Min and Max server memory settings are in Megabytes.
You need to set the /3GB switch in boot.ini for SQL Server to use more than
2GB RAM in your configuration.
--
Regards
Michel Epprecht [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:0A1CE509-ACE9-4D01-8F54-757C38074D91@.microsoft.com...
> I've been reading a lot of the posts about memory but I'm still unclear.
> We have 3.37GB RAM - Win2003 SP1 - SQL2005 SP1.
> Min Server Memory = 0
> Max Server Memory=2147483647
> Will SQL use more than 2GB memory with this setup. I saw note of a
> boot.ini
> file in other posts but I couldn't find one on our server. Will SQL use
> 3GB
> if it needs it?
> Thanks.
> Ron
>|||Where is the boot.ini file? I search the hard drive and couldn't find it.
"Michael Epprecht [MSFT]" wrote:
> Hi
> Min and Max server memory settings are in Megabytes.
> You need to set the /3GB switch in boot.ini for SQL Server to use more than
> 2GB RAM in your configuration.
> --
> Regards
> Michel Epprecht [MSFT]
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:0A1CE509-ACE9-4D01-8F54-757C38074D91@.microsoft.com...
> > I've been reading a lot of the posts about memory but I'm still unclear.
> >
> > We have 3.37GB RAM - Win2003 SP1 - SQL2005 SP1.
> > Min Server Memory = 0
> > Max Server Memory=2147483647
> >
> > Will SQL use more than 2GB memory with this setup. I saw note of a
> > boot.ini
> > file in other posts but I couldn't find one on our server. Will SQL use
> > 3GB
> > if it needs it?
> >
> > Thanks.
> >
> > Ron
> >
>
We have 3.37GB RAM - Win2003 SP1 - SQL2005 SP1.
Min Server Memory = 0
Max Server Memory=2147483647
Will SQL use more than 2GB memory with this setup. I saw note of a boot.ini
file in other posts but I couldn't find one on our server. Will SQL use 3GB
if it needs it?
Thanks.
RonHi
Min and Max server memory settings are in Megabytes.
You need to set the /3GB switch in boot.ini for SQL Server to use more than
2GB RAM in your configuration.
--
Regards
Michel Epprecht [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:0A1CE509-ACE9-4D01-8F54-757C38074D91@.microsoft.com...
> I've been reading a lot of the posts about memory but I'm still unclear.
> We have 3.37GB RAM - Win2003 SP1 - SQL2005 SP1.
> Min Server Memory = 0
> Max Server Memory=2147483647
> Will SQL use more than 2GB memory with this setup. I saw note of a
> boot.ini
> file in other posts but I couldn't find one on our server. Will SQL use
> 3GB
> if it needs it?
> Thanks.
> Ron
>|||Where is the boot.ini file? I search the hard drive and couldn't find it.
"Michael Epprecht [MSFT]" wrote:
> Hi
> Min and Max server memory settings are in Megabytes.
> You need to set the /3GB switch in boot.ini for SQL Server to use more than
> 2GB RAM in your configuration.
> --
> Regards
> Michel Epprecht [MSFT]
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:0A1CE509-ACE9-4D01-8F54-757C38074D91@.microsoft.com...
> > I've been reading a lot of the posts about memory but I'm still unclear.
> >
> > We have 3.37GB RAM - Win2003 SP1 - SQL2005 SP1.
> > Min Server Memory = 0
> > Max Server Memory=2147483647
> >
> > Will SQL use more than 2GB memory with this setup. I saw note of a
> > boot.ini
> > file in other posts but I couldn't find one on our server. Will SQL use
> > 3GB
> > if it needs it?
> >
> > Thanks.
> >
> > Ron
> >
>
memory question
hi experts,
I am running MSSQL Standard edition on a dedicated Win2003 server with 3 GIG
RAM. SqlServer now uses 1,83 GB. I am not sure if and how the /3G and /AWE
switches can help using more RAM.
Thanks for every info!
Bernd
Check on these KB Articles :
Using /3GB or /PAE and AWE with SQL Server:
http://support.microsoft.com/default...&Product=sql2k
HOW TO: Configure memory for more than 2 GB in SQL Server:
http://support.microsoft.com/default...&Product=sql2k
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"Bernd Maierhofer (dato)" <bernd.maierhofer@.dato.at> wrote in message
news:%23IWOxSlNEHA.1608@.TK2MSFTNGP12.phx.gbl...
> hi experts,
> I am running MSSQL Standard edition on a dedicated Win2003 server with 3
GIG
> RAM. SqlServer now uses 1,83 GB. I am not sure if and how the /3G and
/AWE
> switches can help using more RAM.
> Thanks for every info!
> Bernd
>
I am running MSSQL Standard edition on a dedicated Win2003 server with 3 GIG
RAM. SqlServer now uses 1,83 GB. I am not sure if and how the /3G and /AWE
switches can help using more RAM.
Thanks for every info!
Bernd
Check on these KB Articles :
Using /3GB or /PAE and AWE with SQL Server:
http://support.microsoft.com/default...&Product=sql2k
HOW TO: Configure memory for more than 2 GB in SQL Server:
http://support.microsoft.com/default...&Product=sql2k
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"Bernd Maierhofer (dato)" <bernd.maierhofer@.dato.at> wrote in message
news:%23IWOxSlNEHA.1608@.TK2MSFTNGP12.phx.gbl...
> hi experts,
> I am running MSSQL Standard edition on a dedicated Win2003 server with 3
GIG
> RAM. SqlServer now uses 1,83 GB. I am not sure if and how the /3G and
/AWE
> switches can help using more RAM.
> Thanks for every info!
> Bernd
>
Memory question
I've been reading a lot of the posts about memory but I'm still unclear.
We have 3.37GB RAM - Win2003 SP1 - SQL2005 SP1.
Min Server Memory = 0
Max Server Memory=2147483647
Will SQL use more than 2GB memory with this setup. I saw note of a boot.ini
file in other posts but I couldn't find one on our server. Will SQL use 3GB
if it needs it?
Thanks.
Ron
Hi
Min and Max server memory settings are in Megabytes.
You need to set the /3GB switch in boot.ini for SQL Server to use more than
2GB RAM in your configuration.
Regards
Michel Epprecht [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:0A1CE509-ACE9-4D01-8F54-757C38074D91@.microsoft.com...
> I've been reading a lot of the posts about memory but I'm still unclear.
> We have 3.37GB RAM - Win2003 SP1 - SQL2005 SP1.
> Min Server Memory = 0
> Max Server Memory=2147483647
> Will SQL use more than 2GB memory with this setup. I saw note of a
> boot.ini
> file in other posts but I couldn't find one on our server. Will SQL use
> 3GB
> if it needs it?
> Thanks.
> Ron
>
|||Where is the boot.ini file? I search the hard drive and couldn't find it.
"Michael Epprecht [MSFT]" wrote:
> Hi
> Min and Max server memory settings are in Megabytes.
> You need to set the /3GB switch in boot.ini for SQL Server to use more than
> 2GB RAM in your configuration.
> --
> Regards
> Michel Epprecht [MSFT]
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:0A1CE509-ACE9-4D01-8F54-757C38074D91@.microsoft.com...
>
We have 3.37GB RAM - Win2003 SP1 - SQL2005 SP1.
Min Server Memory = 0
Max Server Memory=2147483647
Will SQL use more than 2GB memory with this setup. I saw note of a boot.ini
file in other posts but I couldn't find one on our server. Will SQL use 3GB
if it needs it?
Thanks.
Ron
Hi
Min and Max server memory settings are in Megabytes.
You need to set the /3GB switch in boot.ini for SQL Server to use more than
2GB RAM in your configuration.
Regards
Michel Epprecht [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:0A1CE509-ACE9-4D01-8F54-757C38074D91@.microsoft.com...
> I've been reading a lot of the posts about memory but I'm still unclear.
> We have 3.37GB RAM - Win2003 SP1 - SQL2005 SP1.
> Min Server Memory = 0
> Max Server Memory=2147483647
> Will SQL use more than 2GB memory with this setup. I saw note of a
> boot.ini
> file in other posts but I couldn't find one on our server. Will SQL use
> 3GB
> if it needs it?
> Thanks.
> Ron
>
|||Where is the boot.ini file? I search the hard drive and couldn't find it.
"Michael Epprecht [MSFT]" wrote:
> Hi
> Min and Max server memory settings are in Megabytes.
> You need to set the /3GB switch in boot.ini for SQL Server to use more than
> 2GB RAM in your configuration.
> --
> Regards
> Michel Epprecht [MSFT]
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:0A1CE509-ACE9-4D01-8F54-757C38074D91@.microsoft.com...
>
memory question
hi experts,
I am running MSSQL Standard edition on a dedicated Win2003 server with 3 GIG
RAM. SqlServer now uses 1,83 GB. I am not sure if and how the /3G and /AWE
switches can help using more RAM.
Thanks for every info!
BerndCheck on these KB Articles :
Using /3GB or /PAE and AWE with SQL Server:
http://support.microsoft.com/defaul...8&Product=sql2k
HOW TO: Configure memory for more than 2 GB in SQL Server:
http://support.microsoft.com/defaul...0&Product=sql2k
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Bernd Maierhofer (dato)" <bernd.maierhofer@.dato.at> wrote in message
news:%23IWOxSlNEHA.1608@.TK2MSFTNGP12.phx.gbl...
> hi experts,
> I am running MSSQL Standard edition on a dedicated Win2003 server with 3
GIG
> RAM. SqlServer now uses 1,83 GB. I am not sure if and how the /3G and
/AWE
> switches can help using more RAM.
> Thanks for every info!
> Bernd
>
I am running MSSQL Standard edition on a dedicated Win2003 server with 3 GIG
RAM. SqlServer now uses 1,83 GB. I am not sure if and how the /3G and /AWE
switches can help using more RAM.
Thanks for every info!
BerndCheck on these KB Articles :
Using /3GB or /PAE and AWE with SQL Server:
http://support.microsoft.com/defaul...8&Product=sql2k
HOW TO: Configure memory for more than 2 GB in SQL Server:
http://support.microsoft.com/defaul...0&Product=sql2k
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Bernd Maierhofer (dato)" <bernd.maierhofer@.dato.at> wrote in message
news:%23IWOxSlNEHA.1608@.TK2MSFTNGP12.phx.gbl...
> hi experts,
> I am running MSSQL Standard edition on a dedicated Win2003 server with 3
GIG
> RAM. SqlServer now uses 1,83 GB. I am not sure if and how the /3G and
/AWE
> switches can help using more RAM.
> Thanks for every info!
> Bernd
>
Memory question
I've been reading a lot of the posts about memory but I'm still unclear.
We have 3.37GB RAM - Win2003 SP1 - SQL2005 SP1.
Min Server Memory = 0
Max Server Memory=2147483647
Will SQL use more than 2GB memory with this setup. I saw note of a boot.ini
file in other posts but I couldn't find one on our server. Will SQL use 3G
B
if it needs it?
Thanks.
RonHi
Min and Max server memory settings are in Megabytes.
You need to set the /3GB switch in boot.ini for SQL Server to use more than
2GB RAM in your configuration.
Regards
Michel Epprecht [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:0A1CE509-ACE9-4D01-8F54-757C38074D91@.microsoft.com...
> I've been reading a lot of the posts about memory but I'm still unclear.
> We have 3.37GB RAM - Win2003 SP1 - SQL2005 SP1.
> Min Server Memory = 0
> Max Server Memory=2147483647
> Will SQL use more than 2GB memory with this setup. I saw note of a
> boot.ini
> file in other posts but I couldn't find one on our server. Will SQL use
> 3GB
> if it needs it?
> Thanks.
> Ron
>|||Where is the boot.ini file? I search the hard drive and couldn't find it.
"Michael Epprecht [MSFT]" wrote:
> Hi
> Min and Max server memory settings are in Megabytes.
> You need to set the /3GB switch in boot.ini for SQL Server to use more tha
n
> 2GB RAM in your configuration.
> --
> Regards
> Michel Epprecht [MSFT]
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:0A1CE509-ACE9-4D01-8F54-757C38074D91@.microsoft.com...
>
We have 3.37GB RAM - Win2003 SP1 - SQL2005 SP1.
Min Server Memory = 0
Max Server Memory=2147483647
Will SQL use more than 2GB memory with this setup. I saw note of a boot.ini
file in other posts but I couldn't find one on our server. Will SQL use 3G
B
if it needs it?
Thanks.
RonHi
Min and Max server memory settings are in Megabytes.
You need to set the /3GB switch in boot.ini for SQL Server to use more than
2GB RAM in your configuration.
Regards
Michel Epprecht [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:0A1CE509-ACE9-4D01-8F54-757C38074D91@.microsoft.com...
> I've been reading a lot of the posts about memory but I'm still unclear.
> We have 3.37GB RAM - Win2003 SP1 - SQL2005 SP1.
> Min Server Memory = 0
> Max Server Memory=2147483647
> Will SQL use more than 2GB memory with this setup. I saw note of a
> boot.ini
> file in other posts but I couldn't find one on our server. Will SQL use
> 3GB
> if it needs it?
> Thanks.
> Ron
>|||Where is the boot.ini file? I search the hard drive and couldn't find it.
"Michael Epprecht [MSFT]" wrote:
> Hi
> Min and Max server memory settings are in Megabytes.
> You need to set the /3GB switch in boot.ini for SQL Server to use more tha
n
> 2GB RAM in your configuration.
> --
> Regards
> Michel Epprecht [MSFT]
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:0A1CE509-ACE9-4D01-8F54-757C38074D91@.microsoft.com...
>
Subscribe to:
Posts (Atom)