Consfued on how to handle memoey issue

Okay here is the question for all of brilliant guys. I have a server
loaded with windows 2003 Enterprise Edition with SP2 on it. I've 2
instanaces on sql 2000 sp3a running on them currently memory for the
box is 8 GB. Now the problem is, one of the instance is of ecommerce
database and that database is massive around 800-900 GB. currently,
it's running under memory pressure i mean sql server process is taking
around 1.8 GB but it's not going beyond that I know it's a problem
with 32-bit edition but we can't move our stuff to 64-bit right away.
I would like to know best way to tackle this problem. I mean what i
have to do to give in order to use more memory. Do i need to enable
AWE on both the instance and use /PAE switch or go beyond that and
use /3GB switch in boot.ini. Let me know.
Thanks,Hi
Which edition of SQL 2000 is this?
You can configure the maximum memory to use with sp_configure 'max server
memory' You can set values for each instance so they add up to 5 GB.
Have you enabled AWE on each instance.
John
"kulkarni.ninad@.gmail.com" wrote:
> Okay here is the question for all of brilliant guys. I have a server
> loaded with windows 2003 Enterprise Edition with SP2 on it. I've 2
> instanaces on sql 2000 sp3a running on them currently memory for the
> box is 8 GB. Now the problem is, one of the instance is of ecommerce
> database and that database is massive around 800-900 GB. currently,
> it's running under memory pressure i mean sql server process is taking
> around 1.8 GB but it's not going beyond that I know it's a problem
> with 32-bit edition but we can't move our stuff to 64-bit right away.
> I would like to know best way to tackle this problem. I mean what i
> have to do to give in order to use more memory. Do i need to enable
> AWE on both the instance and use /PAE switch or go beyond that and
> use /3GB switch in boot.ini. Let me know.
> Thanks,
>|||On Sep 27, 12:54 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi
> Which edition of SQL 2000 is this?
> You can configure the maximum memory to use with sp_configure 'max server
> memory' You can set values for each instance so they add up to 5 GB.
> Have you enabled AWE on each instance.
> John
>
> "kulkarni.ni...@.gmail.com" wrote:
> > Okay here is the question for all of brilliant guys. I have a server
> > loaded with windows 2003 Enterprise Edition with SP2 on it. I've 2
> > instanaces on sql 2000 sp3a running on them currently memory for the
> > box is 8 GB. Now the problem is, one of the instance is of ecommerce
> > database and that database is massive around 800-900 GB. currently,
> > it's running under memory pressure i mean sql server process is taking
> > around 1.8 GB but it's not going beyond that I know it's a problem
> > with 32-bit edition but we can't move our stuff to 64-bit right away.
> > I would like to know best way to tackle this problem. I mean what i
> > have to do to give in order to use more memory. Do i need to enable
> > AWE on both the instance and use /PAE switch or go beyond that and
> > use /3GB switch in boot.ini. Let me know.
> > Thanks,- Hide quoted text -
> - Show quoted text -
No we haven't enabled AWE actually and that's where I'm confused at
because in past, I have enabled AWE for single instance but haven't
done it for multiple instances.
Will it work if I enable AWE on both the instance of sql server? and
BTW, sql edition is Enterprise Edition.
Thanks,|||Hi
You should be able to enable AWE for both instances, but even if you enable
it for only one instance you should set the maximum memory for that instance
to avoid it grabbing all the memory.
John
"kulkarni.ninad@.gmail.com" wrote:
> On Sep 27, 12:54 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> > Hi
> >
> > Which edition of SQL 2000 is this?
> >
> > You can configure the maximum memory to use with sp_configure 'max server
> > memory' You can set values for each instance so they add up to 5 GB.
> > Have you enabled AWE on each instance.
> >
> > John
> >
> >
> >
> > "kulkarni.ni...@.gmail.com" wrote:
> > > Okay here is the question for all of brilliant guys. I have a server
> > > loaded with windows 2003 Enterprise Edition with SP2 on it. I've 2
> > > instanaces on sql 2000 sp3a running on them currently memory for the
> > > box is 8 GB. Now the problem is, one of the instance is of ecommerce
> > > database and that database is massive around 800-900 GB. currently,
> > > it's running under memory pressure i mean sql server process is taking
> > > around 1.8 GB but it's not going beyond that I know it's a problem
> > > with 32-bit edition but we can't move our stuff to 64-bit right away.
> > > I would like to know best way to tackle this problem. I mean what i
> > > have to do to give in order to use more memory. Do i need to enable
> > > AWE on both the instance and use /PAE switch or go beyond that and
> > > use /3GB switch in boot.ini. Let me know.
> >
> > > Thanks,- Hide quoted text -
> >
> > - Show quoted text -
> No we haven't enabled AWE actually and that's where I'm confused at
> because in past, I have enabled AWE for single instance but haven't
> done it for multiple instances.
> Will it work if I enable AWE on both the instance of sql server? and
> BTW, sql edition is Enterprise Edition.
> Thanks,
>|||You do not need to add /3GB switch to the boot.ini file; however, you need
to add /PAE to be able to use 6GB of RAM over 8GB. Only enabling AWE won't
let you use 6GB of RAM. (You can use 6GB because Kernel Components and
Operating System use 2GB of RAM) And this process (enabling AWE and PAE)
needs a reboot of your server.
--
Ekrem Önsoy
<kulkarni.ninad@.gmail.com> wrote in message
news:1190914211.251116.224130@.57g2000hsv.googlegroups.com...
> On Sep 27, 12:54 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
>> Hi
>> Which edition of SQL 2000 is this?
>> You can configure the maximum memory to use with sp_configure 'max server
>> memory' You can set values for each instance so they add up to 5 GB.
>> Have you enabled AWE on each instance.
>> John
>>
>> "kulkarni.ni...@.gmail.com" wrote:
>> > Okay here is the question for all of brilliant guys. I have a server
>> > loaded with windows 2003 Enterprise Edition with SP2 on it. I've 2
>> > instanaces on sql 2000 sp3a running on them currently memory for the
>> > box is 8 GB. Now the problem is, one of the instance is of ecommerce
>> > database and that database is massive around 800-900 GB. currently,
>> > it's running under memory pressure i mean sql server process is taking
>> > around 1.8 GB but it's not going beyond that I know it's a problem
>> > with 32-bit edition but we can't move our stuff to 64-bit right away.
>> > I would like to know best way to tackle this problem. I mean what i
>> > have to do to give in order to use more memory. Do i need to enable
>> > AWE on both the instance and use /PAE switch or go beyond that and
>> > use /3GB switch in boot.ini. Let me know.
>> > Thanks,- Hide quoted text -
>> - Show quoted text -
> No we haven't enabled AWE actually and that's where I'm confused at
> because in past, I have enabled AWE for single instance but haven't
> done it for multiple instances.
> Will it work if I enable AWE on both the instance of sql server? and
> BTW, sql edition is Enterprise Edition.
> Thanks,
>|||Hi
See http://www.sql-server-performance.com/tips/awe_memory_p1.aspx
John
"Ekrem Ã?nsoy" wrote:
> You do not need to add /3GB switch to the boot.ini file; however, you need
> to add /PAE to be able to use 6GB of RAM over 8GB. Only enabling AWE won't
> let you use 6GB of RAM. (You can use 6GB because Kernel Components and
> Operating System use 2GB of RAM) And this process (enabling AWE and PAE)
> needs a reboot of your server.
> --
> Ekrem nsoy
>
>
> <kulkarni.ninad@.gmail.com> wrote in message
> news:1190914211.251116.224130@.57g2000hsv.googlegroups.com...
> > On Sep 27, 12:54 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> >> Hi
> >>
> >> Which edition of SQL 2000 is this?
> >>
> >> You can configure the maximum memory to use with sp_configure 'max server
> >> memory' You can set values for each instance so they add up to 5 GB.
> >> Have you enabled AWE on each instance.
> >>
> >> John
> >>
> >>
> >>
> >> "kulkarni.ni...@.gmail.com" wrote:
> >> > Okay here is the question for all of brilliant guys. I have a server
> >> > loaded with windows 2003 Enterprise Edition with SP2 on it. I've 2
> >> > instanaces on sql 2000 sp3a running on them currently memory for the
> >> > box is 8 GB. Now the problem is, one of the instance is of ecommerce
> >> > database and that database is massive around 800-900 GB. currently,
> >> > it's running under memory pressure i mean sql server process is taking
> >> > around 1.8 GB but it's not going beyond that I know it's a problem
> >> > with 32-bit edition but we can't move our stuff to 64-bit right away.
> >> > I would like to know best way to tackle this problem. I mean what i
> >> > have to do to give in order to use more memory. Do i need to enable
> >> > AWE on both the instance and use /PAE switch or go beyond that and
> >> > use /3GB switch in boot.ini. Let me know.
> >>
> >> > Thanks,- Hide quoted text -
> >>
> >> - Show quoted text -
> >
> > No we haven't enabled AWE actually and that's where I'm confused at
> > because in past, I have enabled AWE for single instance but haven't
> > done it for multiple instances.
> > Will it work if I enable AWE on both the instance of sql server? and
> > BTW, sql edition is Enterprise Edition.
> >
> > Thanks,
> >
>|||Well, I'm not really sure of using /3GB all the time at least if it's really
unnecessary. I would not use it unless I really need that 1GB of RAM.
--
Ekrem Ã?nsoy
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:D2EE787C-CC99-4F84-8872-09B30278CD6A@.microsoft.com...
> Hi
> See http://www.sql-server-performance.com/tips/awe_memory_p1.aspx
> John
> "Ekrem Ã?nsoy" wrote:
>> You do not need to add /3GB switch to the boot.ini file; however, you
>> need
>> to add /PAE to be able to use 6GB of RAM over 8GB. Only enabling AWE
>> won't
>> let you use 6GB of RAM. (You can use 6GB because Kernel Components and
>> Operating System use 2GB of RAM) And this process (enabling AWE and PAE)
>> needs a reboot of your server.
>> --
>> Ekrem nsoy
>>
>>
>> <kulkarni.ninad@.gmail.com> wrote in message
>> news:1190914211.251116.224130@.57g2000hsv.googlegroups.com...
>> > On Sep 27, 12:54 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
>> >> Hi
>> >>
>> >> Which edition of SQL 2000 is this?
>> >>
>> >> You can configure the maximum memory to use with sp_configure 'max
>> >> server
>> >> memory' You can set values for each instance so they add up to 5 GB.
>> >> Have you enabled AWE on each instance.
>> >>
>> >> John
>> >>
>> >>
>> >>
>> >> "kulkarni.ni...@.gmail.com" wrote:
>> >> > Okay here is the question for all of brilliant guys. I have a server
>> >> > loaded with windows 2003 Enterprise Edition with SP2 on it. I've 2
>> >> > instanaces on sql 2000 sp3a running on them currently memory for the
>> >> > box is 8 GB. Now the problem is, one of the instance is of ecommerce
>> >> > database and that database is massive around 800-900 GB. currently,
>> >> > it's running under memory pressure i mean sql server process is
>> >> > taking
>> >> > around 1.8 GB but it's not going beyond that I know it's a problem
>> >> > with 32-bit edition but we can't move our stuff to 64-bit right
>> >> > away.
>> >> > I would like to know best way to tackle this problem. I mean what i
>> >> > have to do to give in order to use more memory. Do i need to enable
>> >> > AWE on both the instance and use /PAE switch or go beyond that and
>> >> > use /3GB switch in boot.ini. Let me know.
>> >>
>> >> > Thanks,- Hide quoted text -
>> >>
>> >> - Show quoted text -
>> >
>> > No we haven't enabled AWE actually and that's where I'm confused at
>> > because in past, I have enabled AWE for single instance but haven't
>> > done it for multiple instances.
>> > Will it work if I enable AWE on both the instance of sql server? and
>> > BTW, sql edition is Enterprise Edition.
>> >
>> > Thanks,
>> >|||Hi
There should not be an issue using it as there is only a limited amount of
memory in the server. If the OP is seeing memory presure once AWE has been
enabled, then it is certainly something he should be doing.
John
"Ekrem Ã?nsoy" wrote:
> Well, I'm not really sure of using /3GB all the time at least if it's really
> unnecessary. I would not use it unless I really need that 1GB of RAM.
> --
> Ekrem Ã?nsoy
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:D2EE787C-CC99-4F84-8872-09B30278CD6A@.microsoft.com...
> > Hi
> >
> > See http://www.sql-server-performance.com/tips/awe_memory_p1.aspx
> >
> > John
> >
> > "Ekrem Ã?nsoy" wrote:
> >
> >> You do not need to add /3GB switch to the boot.ini file; however, you
> >> need
> >> to add /PAE to be able to use 6GB of RAM over 8GB. Only enabling AWE
> >> won't
> >> let you use 6GB of RAM. (You can use 6GB because Kernel Components and
> >> Operating System use 2GB of RAM) And this process (enabling AWE and PAE)
> >> needs a reboot of your server.
> >>
> >> --
> >> Ekrem nsoy
> >>
> >>
> >>
> >>
> >> <kulkarni.ninad@.gmail.com> wrote in message
> >> news:1190914211.251116.224130@.57g2000hsv.googlegroups.com...
> >> > On Sep 27, 12:54 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> >> >> Hi
> >> >>
> >> >> Which edition of SQL 2000 is this?
> >> >>
> >> >> You can configure the maximum memory to use with sp_configure 'max
> >> >> server
> >> >> memory' You can set values for each instance so they add up to 5 GB.
> >> >> Have you enabled AWE on each instance.
> >> >>
> >> >> John
> >> >>
> >> >>
> >> >>
> >> >> "kulkarni.ni...@.gmail.com" wrote:
> >> >> > Okay here is the question for all of brilliant guys. I have a server
> >> >> > loaded with windows 2003 Enterprise Edition with SP2 on it. I've 2
> >> >> > instanaces on sql 2000 sp3a running on them currently memory for the
> >> >> > box is 8 GB. Now the problem is, one of the instance is of ecommerce
> >> >> > database and that database is massive around 800-900 GB. currently,
> >> >> > it's running under memory pressure i mean sql server process is
> >> >> > taking
> >> >> > around 1.8 GB but it's not going beyond that I know it's a problem
> >> >> > with 32-bit edition but we can't move our stuff to 64-bit right
> >> >> > away.
> >> >> > I would like to know best way to tackle this problem. I mean what i
> >> >> > have to do to give in order to use more memory. Do i need to enable
> >> >> > AWE on both the instance and use /PAE switch or go beyond that and
> >> >> > use /3GB switch in boot.ini. Let me know.
> >> >>
> >> >> > Thanks,- Hide quoted text -
> >> >>
> >> >> - Show quoted text -
> >> >
> >> > No we haven't enabled AWE actually and that's where I'm confused at
> >> > because in past, I have enabled AWE for single instance but haven't
> >> > done it for multiple instances.
> >> > Will it work if I enable AWE on both the instance of sql server? and
> >> > BTW, sql edition is Enterprise Edition.
> >> >
> >> > Thanks,
> >> >
> >>
>