Evaluating performance of OLAP incoming batches

What is the best way & measure to see the performance of the batches that populate the OLAP database from other OLTP databases? - if they are being efficient or not.

Thanks
LVL 6
anushahannaAsked:
Who is Participating?
 
dportasConnect With a Mentor Commented:
Typically the loading process for a data warehouse is logged so that its progress and performance can be monitored. If you don't have any such logging then use whatever performance monitoring and tuning tools your DBMS provides.
0
 
anushahannaAuthor Commented:
in SQL Server, would that be profiler?
0
 
HwkrangerConnect With a Mentor Commented:
Yes, with Profiler you can see just about everything on SSAS.  

0
 
anushahannaAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.