I am using the following:

Windows 2003 Enterprise
SQL 2000 Std SP3
6GB Ram
4 CPU's with HT turned on (3.2)

I will be running multiple instances of DB.

What should the entry in boot.ini be to best utilise the resources.



Thanks.

Leon
http://support.microsoft.com/kb/274750



"Leon" <Lion@hotmail.com> wrote in message
news:%23$czIrCTHHA.920@TK2MSFTNGP05.phx.gbl...
>I am using the following:
>
> Windows 2003 Enterprise
> SQL 2000 Std SP3
> 6GB Ram
> 4 CPU's with HT turned on (3.2)
>
> I will be running multiple instances of DB.
>
> What should the entry in boot.ini be to best utilise the resources.
>
>
>
> Thanks.
>

Thanks

"Uri Dimant" <urid@iscar.co.il> wrote in message
news:OL1Fg0CTHHA.2212@TK2MSFTNGP02.phx.gbl...
> Leon
> http://support.microsoft.com/kb/274750
>
>
>
> "Leon" <Lion@hotmail.com> wrote in message
> news:%23$czIrCTHHA.920@TK2MSFTNGP05.phx.gbl...
>>I am using the following:
>>
>> Windows 2003 Enterprise
>> SQL 2000 Std SP3
>> 6GB Ram
>> 4 CPU's with HT turned on (3.2)
>>
>> I will be running multiple instances of DB.
>>
>> What should the entry in boot.ini be to best utilise the resources.
>>
>>
>>
>> Thanks.
>>
>
>

To add on URI; if it is 64 bit system and SQL Server standard edition 64 bit
; then there is no need to change the memory addreesss space. This is
because 64 bit
can address more memory with out changing the BOOT.INI.

Thanks
Hari


"Uri Dimant" <urid@iscar.co.il> wrote in message
news:OL1Fg0CTHHA.2212@TK2MSFTNGP02.phx.gbl...
> Leon
> http://support.microsoft.com/kb/274750
>
>
>
> "Leon" <Lion@hotmail.com> wrote in message
> news:%23$czIrCTHHA.920@TK2MSFTNGP05.phx.gbl...
>>I am using the following:
>>
>> Windows 2003 Enterprise
>> SQL 2000 Std SP3
>> 6GB Ram
>> 4 CPU's with HT turned on (3.2)
>>
>> I will be running multiple instances of DB.
>>
>> What should the entry in boot.ini be to best utilise the resources.
>>
>>
>>
>> Thanks.
>>
>
>

Guys,

Is this the same for SQL 2005 Enterprise on 2003 Standard R2 server? Do I
need to make any changes to boot.ini? The document in KB is for 2000 SQL and
I can not find anything for 2005 SQL. Please .

"Hari Prasad" wrote:

> To add on URI; if it is 64 bit system and SQL Server standard edition 64 bit
> ; then there is no need to change the memory addreesss space. This is
> because 64 bit
> can address more memory with out changing the BOOT.INI.
>
> Thanks
> Hari
>
>
> "Uri Dimant" <urid@iscar.co.il> wrote in message
> news:OL1Fg0CTHHA.2212@TK2MSFTNGP02.phx.gbl...
> > Leon
> > http://support.microsoft.com/kb/274750
> >
> >
> >
> > "Leon" <Lion@hotmail.com> wrote in message
> > news:%23$czIrCTHHA.920@TK2MSFTNGP05.phx.gbl...
> >>I am using the following:
> >>
> >> Windows 2003 Enterprise
> >> SQL 2000 Std SP3
> >> 6GB Ram
> >> 4 CPU's with HT turned on (3.2)
> >>
> >> I will be running multiple instances of DB.
> >>
> >> What should the entry in boot.ini be to best utilise the resources.
> >>
> >>
> >>
> >> Thanks.
> >>
> >
> >
>
>
>

If it is 32 bit and you want the app (in this case SQL Server) to use 3GB
instead of 2GB of directly addressable memory you need to set the /3GB
switch. But I don't believe Windows2003 Std edition uses more than 2 GB to
begin with. I could be wrong on that part though. But the bottom line is the
OS needs to support the memory before SQL Server can. And starting with
SQL2005 Std Edition and up can use all the memory that the OS can access
given the correct configuration.

--
Andrew J. Kelly SQL MVP

"George" <George@discussions.microsoft.com> wrote in message
news:F8306B35-4D7A-498E-AE05-7C58442A233B@microsoft.com...
> Guys,
>
> Is this the same for SQL 2005 Enterprise on 2003 Standard R2 server? Do I
> need to make any changes to boot.ini? The document in KB is for 2000 SQL
> and
> I can not find anything for 2005 SQL. Please .
>
> "Hari Prasad" wrote:
>
>> To add on URI; if it is 64 bit system and SQL Server standard edition 64
>> bit
>> ; then there is no need to change the memory addreesss space. This is
>> because 64 bit
>> can address more memory with out changing the BOOT.INI.
>>
>> Thanks
>> Hari
>>
>>
>> "Uri Dimant" <urid@iscar.co.il> wrote in message
>> news:OL1Fg0CTHHA.2212@TK2MSFTNGP02.phx.gbl...
>> > Leon
>> > http://support.microsoft.com/kb/274750
>> >
>> >
>> >
>> > "Leon" <Lion@hotmail.com> wrote in message
>> > news:%23$czIrCTHHA.920@TK2MSFTNGP05.phx.gbl...
>> >>I am using the following:
>> >>
>> >> Windows 2003 Enterprise
>> >> SQL 2000 Std SP3
>> >> 6GB Ram
>> >> 4 CPU's with HT turned on (3.2)
>> >>
>> >> I will be running multiple instances of DB.
>> >>
>> >> What should the entry in boot.ini be to best utilise the resources.
>> >>
>> >>
>> >>
>> >> Thanks.
>> >>
>> >
>> >
>>
>>
>>

Thank you. Anyone knows how to set this correctly on 2003 Standard Server?

"Andrew J. Kelly" wrote:

> If it is 32 bit and you want the app (in this case SQL Server) to use 3GB
> instead of 2GB of directly addressable memory you need to set the /3GB
> switch. But I don't believe Windows2003 Std edition uses more than 2 GB to
> begin with. I could be wrong on that part though. But the bottom line is the
> OS needs to support the memory before SQL Server can. And starting with
> SQL2005 Std Edition and up can use all the memory that the OS can access
> given the correct configuration.
>
> --
> Andrew J. Kelly SQL MVP
>
> "George" <George@discussions.microsoft.com> wrote in message
> news:F8306B35-4D7A-498E-AE05-7C58442A233B@microsoft.com...
> > Guys,
> >
> > Is this the same for SQL 2005 Enterprise on 2003 Standard R2 server? Do I
> > need to make any changes to boot.ini? The document in KB is for 2000 SQL
> > and
> > I can not find anything for 2005 SQL. Please .
> >
> > "Hari Prasad" wrote:
> >
> >> To add on URI; if it is 64 bit system and SQL Server standard edition 64
> >> bit
> >> ; then there is no need to change the memory addreesss space. This is
> >> because 64 bit
> >> can address more memory with out changing the BOOT.INI.
> >>
> >> Thanks
> >> Hari
> >>
> >>
> >> "Uri Dimant" <urid@iscar.co.il> wrote in message
> >> news:OL1Fg0CTHHA.2212@TK2MSFTNGP02.phx.gbl...
> >> > Leon
> >> > http://support.microsoft.com/kb/274750
> >> >
> >> >
> >> >
> >> > "Leon" <Lion@hotmail.com> wrote in message
> >> > news:%23$czIrCTHHA.920@TK2MSFTNGP05.phx.gbl...
> >> >>I am using the following:
> >> >>
> >> >> Windows 2003 Enterprise
> >> >> SQL 2000 Std SP3
> >> >> 6GB Ram
> >> >> 4 CPU's with HT turned on (3.2)
> >> >>
> >> >> I will be running multiple instances of DB.
> >> >>
> >> >> What should the entry in boot.ini be to best utilise the resources.
> >> >>
> >> >>
> >> >>
> >> >> Thanks.
> >> >>
> >> >
> >> >
> >>
> >>
> >>
>
>
>

You might want to have a look at these. The concepts are the same.

http://sqljunkies.com/Tutorial/0D4FF...2FE2D58F6.scuk
Memory
http://www.sql-server-performance.com/awe_memory.asp Using AWE Memory
http://www.support.microsoft.com/?id=321363 SQL Server 7 & 2000 memory
usage
http://www.support.microsoft.com/?id=274750 Memory config
http://www.support.microsoft.com/?id=283037 Large Memory Support Is
Available in Windows 2000 (AWE)
http://www.support.microsoft.com/?id=811891 Can not use more than 2GB of
memory

--
Andrew J. Kelly SQL MVP

"George" <George@discussions.microsoft.com> wrote in message
news:602610CF-D97C-4E87-81F0-1B9E6BC615C3@microsoft.com...
> Thank you. Anyone knows how to set this correctly on 2003 Standard Server?
>
> "Andrew J. Kelly" wrote:
>
>> If it is 32 bit and you want the app (in this case SQL Server) to use 3GB
>> instead of 2GB of directly addressable memory you need to set the /3GB
>> switch. But I don't believe Windows2003 Std edition uses more than 2 GB
>> to
>> begin with. I could be wrong on that part though. But the bottom line is
>> the
>> OS needs to support the memory before SQL Server can. And starting with
>> SQL2005 Std Edition and up can use all the memory that the OS can access
>> given the correct configuration.
>>
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "George" <George@discussions.microsoft.com> wrote in message
>> news:F8306B35-4D7A-498E-AE05-7C58442A233B@microsoft.com...
>> > Guys,
>> >
>> > Is this the same for SQL 2005 Enterprise on 2003 Standard R2 server? Do
>> > I
>> > need to make any changes to boot.ini? The document in KB is for 2000
>> > SQL
>> > and
>> > I can not find anything for 2005 SQL. Please .
>> >
>> > "Hari Prasad" wrote:
>> >
>> >> To add on URI; if it is 64 bit system and SQL Server standard edition
>> >> 64
>> >> bit
>> >> ; then there is no need to change the memory addreesss space. This is
>> >> because 64 bit
>> >> can address more memory with out changing the BOOT.INI.
>> >>
>> >> Thanks
>> >> Hari
>> >>
>> >>
>> >> "Uri Dimant" <urid@iscar.co.il> wrote in message
>> >> news:OL1Fg0CTHHA.2212@TK2MSFTNGP02.phx.gbl...
>> >> > Leon
>> >> > http://support.microsoft.com/kb/274750
>> >> >
>> >> >
>> >> >
>> >> > "Leon" <Lion@hotmail.com> wrote in message
>> >> > news:%23$czIrCTHHA.920@TK2MSFTNGP05.phx.gbl...
>> >> >>I am using the following:
>> >> >>
>> >> >> Windows 2003 Enterprise
>> >> >> SQL 2000 Std SP3
>> >> >> 6GB Ram
>> >> >> 4 CPU's with HT turned on (3.2)
>> >> >>
>> >> >> I will be running multiple instances of DB.
>> >> >>
>> >> >> What should the entry in boot.ini be to best utilise the resources.
>> >> >>
>> >> >>
>> >> >>
>> >> >> Thanks.
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>