Troubleshooting Scheduler Execution Package Slowness in Jet Data Manager
Overview
Jet Data Manager (JDM) is a powerful ETL and data warehousing tool, but users may occasionally experience slowness during scheduled execution of packages. This article outlines common causes and recommended solutions to improve performance.
Verify System Requirements
Ensure your environment meets the recommended system requirements for Jet Analytics.
Inadequate hardware or outdated configurations can significantly impact execution speed.
Refer to following article:
Enable Incremental Loading
Incremental loading reduces the volume of data processed during each execution by only loading new or changed records. This can drastically improve performance, especially for large datasets.
Refer to following article:
Manage SQL Server Memory
SQL Server memory settings play a crucial role in performance. Refer to Jet’s guide on Managing SQL Server Memory to ensure optimal configuration.
Refer to following article:
https://docs.jet.insightsoftware.com/hc/en-us/articles/32731496548877-Manage-SQLServer-Memory
Use Batch Data Cleansing
Jet Data Manager supports batch data cleansing, which splits large INSERT statements into smaller batches. This approach offers several benefits:
Saves SQL Server log space
Improves performance on large tables
Reduces risk of transaction log overflow
Refer to following article:
https://docs.jet.insightsoftware.com/hc/en-us/articles/32731331836173-Batch-Data-Cleansing
Monitor Execution Logging and Statistics
Jet Reports provides detailed logging and statistics. Use the Execute Logging and Statistics feature to:
Track execution duration
Monitor data volume
Identify bottlenecks
This insight helps pinpoint which packages or tables are causing delays.
Refer to the following article:
https://docs.jet.insightsoftware.com/hc/en-us/articles/32731398613645-Execute-Loggingand-Statistic
Identify Large Tables
Verify the tables that retrieve millions of rows. These are often the root cause of slowness.
Consider the following:
Filtering unnecessary data
Archiving old records
Using views to limit row counts
Optimize Multi-Threaded Execution
Jet Data Manager supports multi-threaded execution. To verify:
Open your default package
Review the Max. Threads setting
Increasing this value can significantly boost performance. However, ensure your server has enough CPU cores to support additional threads.
Review Server Changes
Recent changes to the server can affect performance:
Software installations may consume resources
Windows updates can alter system behavior or introduce compatibility issues
If slowness began after a change, consider rolling back or reconfiguring affected components.
Conclusion
Slowness in Jet Data Manager’s scheduler execution can stem from various sources—hardware, configuration, data volume, or recent changes. By systematically reviewing each factor and applying the recommended optimizations, you can restore and enhance performance.