SSIS Logging - Runtime Standard Deviation Report

Runtime standard deviation report provides the following information. 

1. Packages running slower or faster than configured standard deviation limit.
2. Performance history graph for last N executions.
3. Average Execution Time
4. Standard Deviation of Execution Time
5. Extracted and loaded row count

Additional Parameters

• How many executions per package:
• Performance Drop Limit (Default= +1): If you don't want to detect performance drop then set this to 0 (zero). Setting higher limit will detect packages with smaller performance drops.
• Performance Increase Limit (Default= -1): If you don't want to detect performance increase then set this to 0 (zero). Setting higher -ve limit will detect packages with smaller performance increase. Abnormal performance increase can be due to many reasons (e.g. Less records loaded than expected, files not found etc.)

Figure: Parameters

Figure: Runtime Standard Deviation Report

---

Copyright © 2012 Pragmatic Works Inc. | Suggest New Feature | Support