Thursday, February 9, 2012

Accessing more than 2gb

Hello
Can some one please tell me how can i fource sql server to use more than 2gb
of memory
System spec
OS : Windows x64 2003
Memory : 4GB
SQL Server : 32 bit ( Sqlserver.exe*32 from task manger
process tab)
awe enabled : 1 Configure value, 0 run value
Boot.ini : GB switch enabled
The sqlServer:Memory Manger Target/total server memory shows on 1699454
Thanks
ThomashI
http://support.microsoft.com/kb/274750
"vinu thomas" <vinuthomas@.discussions.microsoft.com> wrote in message
news:87DB73CD-02C5-40F6-A582-C4525160554A@.microsoft.com...
> Hello
> Can some one please tell me how can i fource sql server to use more than
> 2gb
> of memory
> System spec
> OS : Windows x64 2003
> Memory : 4GB
> SQL Server : 32 bit ( Sqlserver.exe*32 from task
> manger
> process tab)
> awe enabled : 1 Configure value, 0 run value
> Boot.ini : GB switch enabled
> The sqlServer:Memory Manger Target/total server memory shows on 1699454
> Thanks
> Thomas
>|||Thanks Uri
My setting match to microsoft recomendation. But why sqlServer:Memory Manger
Target/total server memory showing only 1699454
If i am right, with /3 gb boot.ini switch this value should be more than
1699454
regards
Vinu
"Uri Dimant" wrote:
> hI
> http://support.microsoft.com/kb/274750
>
> "vinu thomas" <vinuthomas@.discussions.microsoft.com> wrote in message
> news:87DB73CD-02C5-40F6-A582-C4525160554A@.microsoft.com...
> > Hello
> > Can some one please tell me how can i fource sql server to use more than
> > 2gb
> > of memory
> >
> > System spec
> >
> > OS : Windows x64 2003
> > Memory : 4GB
> > SQL Server : 32 bit ( Sqlserver.exe*32 from task
> > manger
> > process tab)
> > awe enabled : 1 Configure value, 0 run value
> >
> > Boot.ini : GB switch enabled
> >
> > The sqlServer:Memory Manger Target/total server memory shows on 1699454
> >
> > Thanks
> > Thomas
> >
>
>|||Did you check for the lock pages in memory permissions?
MC
"vinu thomas" <vinuthomas@.discussions.microsoft.com> wrote in message
news:F67201C8-8A85-42AD-B499-A844BAE3AC8A@.microsoft.com...
> Thanks Uri
> My setting match to microsoft recomendation. But why sqlServer:Memory
> Manger
> Target/total server memory showing only 1699454
> If i am right, with /3 gb boot.ini switch this value should be more than
> 1699454
> regards
> Vinu
>
> "Uri Dimant" wrote:
>> hI
>> http://support.microsoft.com/kb/274750
>>
>> "vinu thomas" <vinuthomas@.discussions.microsoft.com> wrote in message
>> news:87DB73CD-02C5-40F6-A582-C4525160554A@.microsoft.com...
>> > Hello
>> > Can some one please tell me how can i fource sql server to use more
>> > than
>> > 2gb
>> > of memory
>> >
>> > System spec
>> >
>> > OS : Windows x64 2003
>> > Memory : 4GB
>> > SQL Server : 32 bit ( Sqlserver.exe*32 from task
>> > manger
>> > process tab)
>> > awe enabled : 1 Configure value, 0 run value
>> >
>> > Boot.ini : GB switch enabled
>> >
>> > The sqlServer:Memory Manger Target/total server memory shows on
>> > 1699454
>> >
>> > Thanks
>> > Thomas
>> >
>>|||Hi
> If i am right, with /3 gb boot.ini switch this value should be more than
Have you restarted the server?
"vinu thomas" <vinuthomas@.discussions.microsoft.com> wrote in message
news:F67201C8-8A85-42AD-B499-A844BAE3AC8A@.microsoft.com...
> Thanks Uri
> My setting match to microsoft recomendation. But why sqlServer:Memory
> Manger
> Target/total server memory showing only 1699454
> If i am right, with /3 gb boot.ini switch this value should be more than
> 1699454
> regards
> Vinu
>
> "Uri Dimant" wrote:
>> hI
>> http://support.microsoft.com/kb/274750
>>
>> "vinu thomas" <vinuthomas@.discussions.microsoft.com> wrote in message
>> news:87DB73CD-02C5-40F6-A582-C4525160554A@.microsoft.com...
>> > Hello
>> > Can some one please tell me how can i fource sql server to use more
>> > than
>> > 2gb
>> > of memory
>> >
>> > System spec
>> >
>> > OS : Windows x64 2003
>> > Memory : 4GB
>> > SQL Server : 32 bit ( Sqlserver.exe*32 from task
>> > manger
>> > process tab)
>> > awe enabled : 1 Configure value, 0 run value
>> >
>> > Boot.ini : GB switch enabled
>> >
>> > The sqlServer:Memory Manger Target/total server memory shows on
>> > 1699454
>> >
>> > Thanks
>> > Thomas
>> >
>>|||Uri
Yes.
thanks
"Uri Dimant" wrote:
> Hi
> > If i am right, with /3 gb boot.ini switch this value should be more than
> Have you restarted the server?
>
>
> "vinu thomas" <vinuthomas@.discussions.microsoft.com> wrote in message
> news:F67201C8-8A85-42AD-B499-A844BAE3AC8A@.microsoft.com...
> > Thanks Uri
> >
> > My setting match to microsoft recomendation. But why sqlServer:Memory
> > Manger
> > Target/total server memory showing only 1699454
> >
> > If i am right, with /3 gb boot.ini switch this value should be more than
> > 1699454
> >
> > regards
> > Vinu
> >
> >
> > "Uri Dimant" wrote:
> >
> >> hI
> >> http://support.microsoft.com/kb/274750
> >>
> >>
> >> "vinu thomas" <vinuthomas@.discussions.microsoft.com> wrote in message
> >> news:87DB73CD-02C5-40F6-A582-C4525160554A@.microsoft.com...
> >> > Hello
> >> > Can some one please tell me how can i fource sql server to use more
> >> > than
> >> > 2gb
> >> > of memory
> >> >
> >> > System spec
> >> >
> >> > OS : Windows x64 2003
> >> > Memory : 4GB
> >> > SQL Server : 32 bit ( Sqlserver.exe*32 from task
> >> > manger
> >> > process tab)
> >> > awe enabled : 1 Configure value, 0 run value
> >> >
> >> > Boot.ini : GB switch enabled
> >> >
> >> > The sqlServer:Memory Manger Target/total server memory shows on
> >> > 1699454
> >> >
> >> > Thanks
> >> > Thomas
> >> >
> >>
> >>
> >>
>
>|||MC
Thanks, I must say i am using SQL Server 2000,
is this group policy applicable to sql server 2000
regards
"MC" wrote:
> Did you check for the lock pages in memory permissions?
>
> MC
>
> "vinu thomas" <vinuthomas@.discussions.microsoft.com> wrote in message
> news:F67201C8-8A85-42AD-B499-A844BAE3AC8A@.microsoft.com...
> > Thanks Uri
> >
> > My setting match to microsoft recomendation. But why sqlServer:Memory
> > Manger
> > Target/total server memory showing only 1699454
> >
> > If i am right, with /3 gb boot.ini switch this value should be more than
> > 1699454
> >
> > regards
> > Vinu
> >
> >
> > "Uri Dimant" wrote:
> >
> >> hI
> >> http://support.microsoft.com/kb/274750
> >>
> >>
> >> "vinu thomas" <vinuthomas@.discussions.microsoft.com> wrote in message
> >> news:87DB73CD-02C5-40F6-A582-C4525160554A@.microsoft.com...
> >> > Hello
> >> > Can some one please tell me how can i fource sql server to use more
> >> > than
> >> > 2gb
> >> > of memory
> >> >
> >> > System spec
> >> >
> >> > OS : Windows x64 2003
> >> > Memory : 4GB
> >> > SQL Server : 32 bit ( Sqlserver.exe*32 from task
> >> > manger
> >> > process tab)
> >> > awe enabled : 1 Configure value, 0 run value
> >> >
> >> > Boot.ini : GB switch enabled
> >> >
> >> > The sqlServer:Memory Manger Target/total server memory shows on
> >> > 1699454
> >> >
> >> > Thanks
> >> > Thomas
> >> >
> >>
> >>
> >>
>|||"Total Server Memory" counter will show you "Total amount of dynamic memory
the server is currently consuming".
You don't need to enable AWE as you aren't using more than 4GB of memory.
However Linchi has a study on this and you may want to take a look at it.
http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx
You did not mention so I'll make a guess and my guess is your SQL Server
memory management is dynamic, right? If so, SQL Server will allocate and
deallocate the memory as it's needed.
To see if your SQL Server instance needs more than 1.6GB of memory, you can
check out Target Server Memory and Total Server Memory counters. If the
values of Total Server Memory counter is more than the Target Server Memory
counter's values, then it means your SQL Server instance needs more memory
to work efficiently. And in your case it means it can't use more than 1.6GB
of memory and then I can assume that there is a problem with the /3GB switch
configuration or another problem with the memory. Target Server Memory
counter will show you how much memory SQL Server requires to run well in
health.
And you can use Available Memory counter which is under the Memory node to
see how much memory available to be used.
--
Ekrem Ã?nsoy
"vinu thomas" <vinuthomas@.discussions.microsoft.com> wrote in message
news:87DB73CD-02C5-40F6-A582-C4525160554A@.microsoft.com...
> Hello
> Can some one please tell me how can i fource sql server to use more than
> 2gb
> of memory
> System spec
> OS : Windows x64 2003
> Memory : 4GB
> SQL Server : 32 bit ( Sqlserver.exe*32 from task
> manger
> process tab)
> awe enabled : 1 Configure value, 0 run value
> Boot.ini : GB switch enabled
> The sqlServer:Memory Manger Target/total server memory shows on 1699454
> Thanks
> Thomas
>|||Ekrem
Thanks for you help, yes its set dynamic memory configuration. The target
Server Memory and Total server memory are always shows the same value. I
suspect something wrong with /3gb switch.
Here is boot.ini setting
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(2)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windows Server 2003 Standard
x64 Edition" /3GB /noexecute=optout /fastdetect
Did you see any error?.
Thanks
"Ekrem Ã?nsoy" wrote:
> "Total Server Memory" counter will show you "Total amount of dynamic memory
> the server is currently consuming".
> You don't need to enable AWE as you aren't using more than 4GB of memory.
> However Linchi has a study on this and you may want to take a look at it.
> http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx
> You did not mention so I'll make a guess and my guess is your SQL Server
> memory management is dynamic, right? If so, SQL Server will allocate and
> deallocate the memory as it's needed.
> To see if your SQL Server instance needs more than 1.6GB of memory, you can
> check out Target Server Memory and Total Server Memory counters. If the
> values of Total Server Memory counter is more than the Target Server Memory
> counter's values, then it means your SQL Server instance needs more memory
> to work efficiently. And in your case it means it can't use more than 1.6GB
> of memory and then I can assume that there is a problem with the /3GB switch
> configuration or another problem with the memory. Target Server Memory
> counter will show you how much memory SQL Server requires to run well in
> health.
> And you can use Available Memory counter which is under the Memory node to
> see how much memory available to be used.
> --
> Ekrem Ã?nsoy
>
> "vinu thomas" <vinuthomas@.discussions.microsoft.com> wrote in message
> news:87DB73CD-02C5-40F6-A582-C4525160554A@.microsoft.com...
> > Hello
> > Can some one please tell me how can i fource sql server to use more than
> > 2gb
> > of memory
> >
> > System spec
> >
> > OS : Windows x64 2003
> > Memory : 4GB
> > SQL Server : 32 bit ( Sqlserver.exe*32 from task
> > manger
> > process tab)
> > awe enabled : 1 Configure value, 0 run value
> >
> > Boot.ini : GB switch enabled
> >
> > The sqlServer:Memory Manger Target/total server memory shows on 1699454
> >
> > Thanks
> > Thomas
> >
>|||I don't see any obvious problem with the boot.ini lines.
So, is the memory problem with only SQL Server or Windows Server itself? Are
you sure your Windows Server can see and use this 4GB of RAM? How much RAM
does your Windows Server see in Task Manager (Physical Memory "Total")?
Let's figure out if the problem is about SQL Server or Windows Server. Maybe
one of your RAM slot has a problem or something...
Also, an important point, what's the edition of your SQL Server 2000
instance? If it's the Standard Edition, then it can not use more than 2GB of
memory.
--
Ekrem Ã?nsoy
"vinu thomas" <vinuthomas@.discussions.microsoft.com> wrote in message
news:E10B324D-3D32-43CF-A03F-E7A846E52E13@.microsoft.com...
> Ekrem
> Thanks for you help, yes its set dynamic memory configuration. The target
> Server Memory and Total server memory are always shows the same value. I
> suspect something wrong with /3gb switch.
> Here is boot.ini setting
> [boot loader]
> timeout=30
> default=multi(0)disk(0)rdisk(0)partition(2)\WINDOWS
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windows Server 2003 Standard
> x64 Edition" /3GB /noexecute=optout /fastdetect
> Did you see any error?.
> Thanks
> "Ekrem Ã?nsoy" wrote:
>> "Total Server Memory" counter will show you "Total amount of dynamic
>> memory
>> the server is currently consuming".
>> You don't need to enable AWE as you aren't using more than 4GB of memory.
>> However Linchi has a study on this and you may want to take a look at it.
>> http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx
>> You did not mention so I'll make a guess and my guess is your SQL Server
>> memory management is dynamic, right? If so, SQL Server will allocate and
>> deallocate the memory as it's needed.
>> To see if your SQL Server instance needs more than 1.6GB of memory, you
>> can
>> check out Target Server Memory and Total Server Memory counters. If the
>> values of Total Server Memory counter is more than the Target Server
>> Memory
>> counter's values, then it means your SQL Server instance needs more
>> memory
>> to work efficiently. And in your case it means it can't use more than
>> 1.6GB
>> of memory and then I can assume that there is a problem with the /3GB
>> switch
>> configuration or another problem with the memory. Target Server Memory
>> counter will show you how much memory SQL Server requires to run well in
>> health.
>> And you can use Available Memory counter which is under the Memory node
>> to
>> see how much memory available to be used.
>> --
>> Ekrem Ã?nsoy
>>
>> "vinu thomas" <vinuthomas@.discussions.microsoft.com> wrote in message
>> news:87DB73CD-02C5-40F6-A582-C4525160554A@.microsoft.com...
>> > Hello
>> > Can some one please tell me how can i fource sql server to use more
>> > than
>> > 2gb
>> > of memory
>> >
>> > System spec
>> >
>> > OS : Windows x64 2003
>> > Memory : 4GB
>> > SQL Server : 32 bit ( Sqlserver.exe*32 from task
>> > manger
>> > process tab)
>> > awe enabled : 1 Configure value, 0 run value
>> >
>> > Boot.ini : GB switch enabled
>> >
>> > The sqlServer:Memory Manger Target/total server memory shows on
>> > 1699454
>> >
>> > Thanks
>> > Thomas
>> >|||On Apr 15, 8:29=A0am, Ekrem =D6nsoy <ek...@.compecta.com> wrote:
> I don't see any obvious problem with the boot.ini lines.
> So, is the memory problem with only SQL Server or Windows Server itself? A=re
> you sure your Windows Server can see and use this 4GB of RAM? How much RAM=
> does your Windows Server see in Task Manager (Physical Memory "Total")?
> Let's figure out if the problem is about SQL Server or Windows Server. May=be
> one of your RAM slot has a problem or something...
> Also, an important point, what's the edition of your SQL Server 2000
> instance? If it's the Standard Edition, then it can not use more than 2GB =of
> memory.
> --
> Ekrem =D6nsoy
> "vinu thomas" <vinutho...@.discussions.microsoft.com> wrote in message
> news:E10B324D-3D32-43CF-A03F-E7A846E52E13@.microsoft.com...
>
> > Ekrem
> > Thanks for you help, yes its set dynamic memory configuration. The targe=t
> > Server Memory and Total server memory are always shows the same value. ==A0I
> > suspect something wrong with /3gb switch.
> > Here is boot.ini setting
> > [boot loader]
> > timeout=3D30
> > default=3Dmulti(0)disk(0)rdisk(0)partition(2)\WINDOWS
> > [operating systems]
> > multi(0)disk(0)rdisk(0)partition(2)\WINDOWS=3D"Windows Server 2003 Stand=ard
> > x64 Edition" /3GB /noexecute=3Doptout /fastdetect
> > Did you see any error?.
> > Thanks
> > "Ekrem =D6nsoy" wrote:
> >> "Total Server Memory" counter will show you "Total amount of dynamic
> >> memory
> >> the server is currently consuming".
> >> You don't need to enable AWE as you aren't using more than 4GB of memor=y.
> >> However Linchi has a study on this and you may want to take a look at i=t.
> >>http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-a...=
> >> You did not mention so I'll make a guess and my guess is your SQL Serve=r
> >> memory management is dynamic, right? If so, SQL Server will allocate an=d
> >> deallocate the memory as it's needed.
> >> To see if your SQL Server instance needs more than 1.6GB of memory, you=
> >> can
> >> check out Target Server Memory and Total Server Memory counters. If the=
> >> values of Total Server Memory counter is more than the Target Server
> >> Memory
> >> counter's values, then it means your SQL Server instance needs more
> >> memory
> >> to work efficiently. And in your case it means it can't use more than
> >> 1.6GB
> >> of memory and then I can assume that there is a problem with the /3GB
> >> switch
> >> configuration or another problem with the memory. Target Server Memory
> >> counter will show you how much memory SQL Server requires to run well i=n
> >> health.
> >> And you can use Available Memory counter which is under the Memory node=
> >> to
> >> see how much memory available to be used.
> >> --
> >> Ekrem =D6nsoy
> >> "vinu thomas" <vinutho...@.discussions.microsoft.com> wrote in message
> >>news:87DB73CD-02C5-40F6-A582-C4525160554A@.microsoft.com...
> >> > Hello
> >> > Can some one please tell me how can i fource sql server to use more
> >> > than
> >> > 2gb
> >> > of memory
> >> > System spec
> >> > OS =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0: =A0 ==A0 Windows x64 2003
> >> > Memory =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 : =A0 =A0 4GB
> >> > SQL Server =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0: =A0 =A0 32 bit ( Sqls=erver.exe*32 from task
> >> > manger
> >> > process tab)
> >> > awe enabled =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0: =A0 =A0 =A01 Configure v=alue, 0 run value
> >> > Boot.ini =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0: =A0 GB swit=ch enabled
> >> > The sqlServer:Memory Manger Target/total server memory =A0shows on
> >> > 1699454
> >> > Thanks
> >> > Thomas- Hide quoted text -
> - Show quoted text -
I don't think the /3GB switch is going to offer you anything at all
since you are running Windows 2003 x64 (where this switch is not
needed). I am betting that you are not running SQL Server 2000
Enterprise - and that is the reason why you cannot use more memory.
Jeff

No comments:

Post a Comment