SQL Server Performance

OLTP Rollup or OLAP Cube

Discussion in 'Analysis Services/Data Warehousing' started by amitm79, Jun 23, 2004.

  1. amitm79 New Member

    Hi All,
    I have a query. I have a scenario in which my data comes into my lowest granularity tables every 15 minutes. I rollup this data into Hourly, daily & monthly tables at the respective time frames. What i want to ask is that can building hourly, daily, monthly, yearly cubes give me more reporting performance then OLTP tables. Basically, the need arose from the fact that even after rolling up the data to appropriate granularity tables my report generation time goes into 1-3 hours depeding on data. I have about 200 reports running on various granularities which are generated automatically.

  2. satya Moderator

  3. Raulie New Member

Share This Page