Re: MS OLAP 3GB Limit

In my mind, strategically, there are two paths to take:
1) If remaining on SQL Server 2000 for an extended period of time (more than
a year more), then you have two options: going to x64 (with SP4 you can get
4GB -- up from 3GB) or ia64 (for unlimited)
2) If going into Yukon quickly, for unlimited memory support, x64 and ia64
have virtually the same capabilities -- probably more software will be
available with x64 (i.e. data adaptors, ODBC drivers, that kind of thing)

I think in the commodity server hardware the picture is pretty clear. x64
will be virtually EVERWHERE within the next year or so. It would surprise me
greatly if you will be able to puchase a plain old 32-bit only server much
more than the next year. And on the software side, virturally anything that
won't have a native 64-bit application will support x64 under WOW. The
competitive picture between Intel and AMD means that, in my opinion, that
x64 is clearly headed into the mainstream.

The ia64 picture is a bit more unclear. Software isn't nearly as available.
WOW support isn't happening at all. It is a *very* nice hardware platform
(but then again so was the Alpha), but I don't have a crystal ball for its
long-term viability.

--
Dave Wickert [MSFT]
dwickert@xxxxxxxxxxxxxxxxxxxx
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


<karenmiddleol@xxxxxxxxx> wrote in message
news:1120192116.522989.304050@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Dave
>
> Many thanks for the update. I had been suffering from problems with
> large dimensions in SQL 2K. This is a good reason to justify to
> our management to go for iA64 also it brings Analysis Services to
> the same level playing field as the other UNIX based solutions in large
> scale solution scalability. We can easily justify going to iA64 the
> large
> dimensions was our biggest nightmare.
>
> Thanks
> Karen
>


.

Relevant Pages

  • Cant install SQL Server 2005 Express Edition on WinXP Pro x64 (0x80041008)
    ... Edition setup off CD, everything installs just fine, but SQL ... Server 2005 Express Edition x64". ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Error During Setup
    ... >> I've been doing battle w/Server2003 x64 and Sharepoint Services. ... >> new server install, ... Now, no matter what I do, I cannot connect to the SQL server ... >> security admin on the SQL server, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: SQL Error During Setup
    ... The x64 OS is not listed as being supported. ... > server install, ... > security admin on the SQL server, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Windows Server 2003 Ent. x64 Edition - Full-text Tuning
    ... is - I can not get the x64 server to perform bette rthan the 32-bit version. ... > or is it 512M across all DB FT catalogs? ... > there are multiple instances of SQL Server 2000 installed. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: 32bit applications in TS on 2003x64
    ... Would there be any benefits rebuilding/replacing server with x64? ... IA64: implemented in the Itanium CPUs, ... implemented in nearly all current Intel and AMD CPUs ... Your HP server with its Xeon CPU has built-in support for Intel 64. ...
    (microsoft.public.windows.terminal_services)