question

JJTT-0327 avatar image
0 Votes"
JJTT-0327 asked LukasYu-msft commented

SSAS's Performance and Cube processing

Hello,

1.
The purpose to use analysis service is to achieve high performance using MOLAP compare to OLTP.

Am I right?


2.
From your experience about processing data från database to the SSAS cube, how many minutes does it take based on your experience?


Thank you!

sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft commented
  1. High performance is only one advantage of using SSAS to analysis. It is also more easy for non-developpers to analysis and reporting. Additionally it can use for data mining which OLTP is not good at.
    You could also check this article see if it can clarify the difference : OLAP vs. OLTP: What’s the Difference?

  2. It depends on the row number of the data, the aggregation, and calculation or cube complexity of the project. It also depends on the hardware of you machine, of course. So only talking about time without database is not quite meaningless.
    If you really need an example, for full processing AdventureWorks(which is about 20mb and about 100,000 rows) the process took about 1 minute or less on my person pc.


Regards,
Lukas



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Did this help with your issue ? Could we help further?

0 Votes 0 ·