|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > 70 Million Accounts
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
70 Million Accounts
|
|
| Astubbs 2002-10-31, 11:23 am |
| Repost:
I have a manager who would like to see our 70 million
customer accounts in an OLAP environment. Is Analysis
Services up to the task? If not, are there other tools
out there for this? Thanks.
| |
| Narayana Vyas Kondreddi 2002-10-31, 12:23 pm |
| >> Is Analysis Services up to the task?
I believe so. For example, here's a case study:
http://www.microsoft.com/servers/ev...aqpolyvista.asp
You can find more case studies here:
http://www.microsoft.com/sql/evalua...isting.asp#2000
--
HTH,
Vyas, MVP (SQL Server)
SQL Server FAQ, articles, code samples, interview questions and more @
http://vyaskn.tripod.com/
"Astubbs" <aaronstubbs@firstusa.com> wrote in message
news:2fef01c280fd$a29d1540$2ae
2c90a@phx.gbl...
> Repost:
>
> I have a manager who would like to see our 70 million
> customer accounts in an OLAP environment. Is Analysis
> Services up to the task? If not, are there other tools
> out there for this? Thanks.
| |
| Mike John 2002-10-31, 1:24 pm |
| I have a fact table af around 68m rows, growing fairly fast and expect a
years worth to hit about 120m. Using incremental updates to add new rows to
the cube every night, Cube has 8 dimensions. Some fairly standard hierachies
in some of the dimensions. Base fact table runs at around 3.5 Gb at the
moment, Ends up as about 400 Mb in the cube. So far no problems apart from
getting caught where msmdarch creates it's workfiles when generating the
cube archives.
So I would guess it can do it - but an awful lot will depend on the detailed
design, no of queries etc etc.
Mike John
"Astubbs" <aaronstubbs@firstusa.com> wrote in message
news:2fef01c280fd$a29d1540$2ae
2c90a@phx.gbl...
> Repost:
>
> I have a manager who would like to see our 70 million
> customer accounts in an OLAP environment. Is Analysis
> Services up to the task? If not, are there other tools
> out there for this? Thanks.
|
|
|
|
|