CH Draft - Test Execution Performance Monitoring and Troubleshooting
ScenarioEarlier executions of a package used to complete in less time. However, it is taking more time now. There are no specific errors or retries. Review and compare execution logsRight-click on a package -> View Execution History LogReview Gantt charts for fast and slow execution to compare objects, steps and timings. Check to see if overall number of objects or steps have increased. View Tools menu -> project Execution Overview Log. Review various measures and drill-down to various objects. Two examples are shown below: Right-Click on data warehouse or a table - > Execution Overview Log When you turn on logging (execution package settings -> Log Execution time and Log Row Count check boxes), it will shows how fast a table ran and how many rows were transferred,Compare slow and fast executions, looking at timings and number of rows.Check schedules, steps and overlapsa. Trace Source => ODX and ODX => Data Warehouse:How to Query ODX local Backlog SQLite database
