Memory Allocation for 64 bit

I have a client experiencing problems with SQL Server 2005 64 bit
(sp1). The server has 4 gigs of memory available, however I can not
increase the memory allocated via management studio past 2 gigs. When
I look at the .exe in task manager, I see that service is using about
3.5 gigs. Can I just go into sp_configure and set it to what I need?
Not sure if this matters...the processors are made by AMD. Please
advise...I think if you check that value in management studio you will see that is
not 2 gigs but a much higher number.
--
Andrew J. Kelly SQL MVP
<abraceyiii@.yahoo.com> wrote in message
news:1175211178.077029.26440@.p15g2000hsd.googlegroups.com...
>I have a client experiencing problems with SQL Server 2005 64 bit
> (sp1). The server has 4 gigs of memory available, however I can not
> increase the memory allocated via management studio past 2 gigs. When
> I look at the .exe in task manager, I see that service is using about
> 3.5 gigs. Can I just go into sp_configure and set it to what I need?
> Not sure if this matters...the processors are made by AMD. Please
> advise...
>|||Hello,
SQL Server 2005 supports dynamic allocation of AWE mapped memory on Windows
Server 2003. In Windows 2003 with SQL Server 2005 64 bit, no need to
do any changes to utilize more than 4 GB RAM.
See the below URL which details.
http://msdn2.microsoft.com/en-us/library/ms190731.aspx
Thanks
Hari
<abraceyiii@.yahoo.com> wrote in message
news:1175211178.077029.26440@.p15g2000hsd.googlegroups.com...
>I have a client experiencing problems with SQL Server 2005 64 bit
> (sp1). The server has 4 gigs of memory available, however I can not
> increase the memory allocated via management studio past 2 gigs. When
> I look at the .exe in task manager, I see that service is using about
> 3.5 gigs. Can I just go into sp_configure and set it to what I need?
> Not sure if this matters...the processors are made by AMD. Please
> advise...
>|||On 30.03.2007 01:32, abraceyiii@.yahoo.com wrote:
> I have a client experiencing problems with SQL Server 2005 64 bit
> (sp1). The server has 4 gigs of memory available, however I can not
> increase the memory allocated via management studio past 2 gigs. When
> I look at the .exe in task manager, I see that service is using about
> 3.5 gigs. Can I just go into sp_configure and set it to what I need?
> Not sure if this matters...the processors are made by AMD. Please
> advise...
Are you maybe trying to administer a 64 bit version with a 32 bit
client? Maybe that has some built in limitations. Just a wild guess.
robert|||On Apr 2, 2:05 am, Robert Klemme <shortcut...@.googlemail.com> wrote:
> On 30.03.2007 01:32, abracey...@.yahoo.com wrote:
> > I have a client experiencing problems with SQL Server 2005 64 bit
> > (sp1). The server has 4 gigs of memory available, however I can not
> > increase the memory allocated via management studio past 2 gigs. When
> > I look at the .exe in task manager, I see that service is using about
> > 3.5 gigs. Can I just go into sp_configure and set it to what I need?
> > Not sure if this matters...the processors are made by AMD. Please
> > advise...
> Are you maybe trying to administer a 64 bit version with a 32 bit
> client? Maybe that has some built in limitations. Just a wild guess.
> robert
thanks...i will look elsewhere