Follow

Execution Performance Monitoring and Troubleshooting

Scenario

Earlier 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 logs

Right-click on a package -> View Execution History Log

mceclip6.png

Review 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.   

mceclip7.png

View Tools menu -> project Execution Overview Log. Review various measures and drill-down to various objects.  Two examples are shown below:

mceclip3.png

 

mceclip4.png

Right-Click on data warehouse or a table - > Execution Overview Log 

mceclip0.png

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.

mceclip5.png

Check schedules, steps and overlaps

a.  Trace Source => ODX and ODX => Data Warehouse:

How to Query ODX local Backlog SQLite database

b. Package Execution, Data Warehouse and Semantic Layer:

Execution Details SQL Query may return detailed execution information.  It may show which step took more time.

c. Are there other packages scheduled to run with overlapping schedules?

Scheduled Execution issues - Did it not start, did it fail, or is my execution still running?

Is my scheduled execution running

Review the FAQ in Troubleshooting concurrency issues in ODX data sources

Environment, machine and network factors

Review Windows Event Viewer logs for errors or warnings related to ODX Service and TimeXtender Scheduler Service.

When reading data from another machine, look for these factors when applicable:

- network latency

- CPU/ memory on other machine

- memory allocation for SQL server (for large executions)

- reboots, server maintenance, nightly patching (if any)

- retries on the package

- intermittent connectivity issues to Azure server

Check for blocking

Use a Profiler tool to trace SQL queries in currently executing package.

Understand and resolve blocking problems

Understand and resolve Azure SQL blocking problems

Is Repository or old logs size affecting performance?

Size issues with your repository Clean up the logs and get more space

Why is my project repository database so large, and how can I shrink it? 

You may remove "very old" execution logs from Tools->Repository Administration.

Periodic maintenance

1. Performance Recommendations module can analyze your project and provide recommendations.

Right click on the Project Node -> Performance Recommendations -> Find...

2. Right click on the Project Node -> Advanced -> SQL Database Cleanup Tool

3. also review "Proactive maintenance, cleanup & backup" section in this article

Self-Service Troubleshooting in TimeXtender

Reference

Scheduled Execution issues - Did it not start, did it fail, or is my execution still running?

Is my scheduled execution running

Was this article helpful?
0 out of 0 found this helpful

0 Comments

Please sign in to leave a comment.