SQL Server Performance Forum – Threads Archive
OLTP Rollup or OLAP CubeHi 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. Regards,
In your case I would choose to go OLAP instead of handling data in various tables and for informationhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_dwdesign.asp review this link. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Here is a link on Analysis Services infohttp://www.microsoft.com/sql/evaluation/bi/bianalysis.asp [8D]