Report samples

By using views (or tables) you can create a lot of interesting reports that allows to monitor the performance of the DataFlow over the time, or of a specific import. Here are some examples (not yet provided with DTLoggedExec), that can give you an idea of what can be created:

Package DataFlow Performance Over Time

Image

See how your dataflow process performs during execution. Very useful for long-running dataflows, to verify if performances stay constant during the whole process or there is something happening that slows down your ETL. As the sample shows is also useful to compare last execution against that same execution one month before, to see how the performance has changes within one month, so that you can verify if something is going bad, or if your changes to improve performance are doing as expected.

DataFlow Performance Source Rows

Image

See how the extraction of rows from source database is performing over time, in particular in the last month. This is ideal to forecast ETL performances.

DataFlow Performance Rows Sent To Fact Table

Image

See how the loading of rows into your DWH fact table is performing over time, in particular in the last month. This is ideal to forecast ETL performances.

DataFlow Performance Overall Processed Rows

Image

Monitor the performance of the entire Dataflow over the last month. This is perfect to verify the impact of changes/optimizations to the DataFlow, or to see if there are some external factors that are impacting on performances.

Quality Of Service

Image

This report show a sample dashboard that can be created to check - on monthly basis - if the ETL Dataflow process, which normally is the most expensive one, is staying within the allowed timeframes, and thus meeting the defined SLA.