dbTalk Databases Forums  

Win 2003 x64 & Analysis Services 2000 32-bit Memory Usage...

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Win 2003 x64 & Analysis Services 2000 32-bit Memory Usage... in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
BATMAN
 
Posts: n/a

Default Win 2003 x64 & Analysis Services 2000 32-bit Memory Usage... - 06-20-2005 , 07:07 PM






We've been running into problems with Analysis Services 32-bit hitting the
2gb ceiling... So my question is... Can Analysis Services address more that
2gb of memory on a "Win 2003 x64" server? If so, how much???

Also, we ran into the PAE and /3GB switch conflict... This is why we can
can only use 2gb's of memory....

Thanks...

Reply With Quote
  #2  
Old   
Edward Melomed [MS]
 
Posts: n/a

Default Re: Win 2003 x64 & Analysis Services 2000 32-bit Memory Usage... - 06-21-2005 , 11:32 AM






Definitely. On 64bit machine Analysis Services can use memory above 3Gb.
There is not limit to all practical purposes.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"BATMAN" <BATMAN (AT) discussions (DOT) microsoft.com> wrote

Quote:
We've been running into problems with Analysis Services 32-bit hitting the
2gb ceiling... So my question is... Can Analysis Services address more
that
2gb of memory on a "Win 2003 x64" server? If so, how much???

Also, we ran into the PAE and /3GB switch conflict... This is why we can
can only use 2gb's of memory....

Thanks...



Reply With Quote
  #3  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Win 2003 x64 & Analysis Services 2000 32-bit Memory Usage... - 06-21-2005 , 06:55 PM



Edward is right for an ia64 machine. For an x64 machine, with SQL Server
2000 SP4, you are limited to 4GB (running in WOW-mode). With SQL Server 2005
and x64 you will have virtually unlimited memory -- just like you have today
with the ia64 architecture.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Edward Melomed [MS]" <edwardm.noreplay (AT) online (DOT) microsoft.com> wrote in
message news:OiAak7ndFHA.580 (AT) TK2MSFTNGP15 (DOT) phx.gbl...
Quote:
Definitely. On 64bit machine Analysis Services can use memory above 3Gb.
There is not limit to all practical purposes.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no
rights.


"BATMAN" <BATMAN (AT) discussions (DOT) microsoft.com> wrote in message
news:E9E773A9-B74D-4A73-BEA3-97F1F9E603E1 (AT) microsoft (DOT) com...
We've been running into problems with Analysis Services 32-bit hitting
the
2gb ceiling... So my question is... Can Analysis Services address more
that
2gb of memory on a "Win 2003 x64" server? If so, how much???

Also, we ran into the PAE and /3GB switch conflict... This is why we can
can only use 2gb's of memory....

Thanks...





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.