Re: Advice on database volume

Tech-Archive recommends: Fix windows errors by optimizing your registry

You can work with this volume of data in Analysis Services 2005 without
changing your schema (and I strongly suggest you to not change your
schema!).
You can use partitions to handle this volume of data without having a
single big partition that is hard to process if for whatever reasons
you need to full process your cube.

Be careful with aggregation design - you really need preaggregations on
this volume of data.

Marco Russo
http://www.sqlbi.eu
http://www.sqljunkies.com/weblog/sqlbi


Jerome wrote:
Hi all,
I'm new to datawarehousing. I've built a DW with two fact tables, each one
will be added with more than 5 to 10 millions rows each day. Do you think
that this volume is compatible with Analysis Services 2005 or do I have to
change the model I use, by creating a fact table for each customer I have
(for instance).

Second question: if the awnser of the previous question is that I can keep
the model I've built, will I have to investigate cube partition ?

thank's.
Jerome

.

Relevant Pages

  • Re: SSAS 2005 - 3GB memory limit still there?
    ... Analysis Services + SP1 with 4GB RAM on the environment i am working ... processing a partition -- but frankly I have never seen this happen even ... Memory error: The operation cannot be completed because the memory ...
    (microsoft.public.sqlserver.olap)
  • Re: DSO Incremental Update in Visual Studio C#
    ... an additional clarification. ... done in Analysis Services is to attempt to Process. ... Analysis Services sees the partition as ... > My advice is to get the Metadata Scripter that is contained on the SQL ...
    (microsoft.public.sqlserver.olap)
  • Re: SQL server performance degrades
    ... The queries I am referring are captured from the Analysis services ... > It is pretty strange that SQL query for processing take more and more time. ... > If you use the schema one partition - one fact table, ...
    (microsoft.public.sqlserver.olap)
  • Re: SQL server performance degrades
    ... The queries I am referring are captured from the Analysis services ... > If you use the schema one partition - one fact table, ... I would recommend you using of SQL ...
    (microsoft.public.sqlserver.olap)
  • Re: SQL server performance degrades
    ... We are using incremental update. ... We are using MOLAP mode. ... partition and there are around 3 Million rows in each fact table. ... The analysis services logs show that the actual relational SQL query is ...
    (microsoft.public.sqlserver.olap)