SAS Data Integration Studio P40:This manual is a companion to the online Help for SAS Data Integration Studio. The Help describes all windows in SAS Data Integration Studio, and it summarizes the main tasks that you can perform with the software. The Help includes examples for all source designer wizards, all target designer wizards, and all transformation templates in the Process Library tree. | 190 Using SAS Logs to Analyze Process Flows A Chapter 11 Evaluating SAS Logs The SAS logs from your process flows are an excellent resource to help you understand what is happening as the flows execute. For example when you look at the run times in the log compare the real-time values to the CPU time user CPU plus system CPU . For read operations the real time and CPU time should be close. For write operations however the real time could substantially exceed the CPU time especially in environments that are optimized for read operations. If the real time and the CPU time are not close and they should be close in your environment investigate what is causing the difference. If you suspect that you have a hardware issue see A Practical Approach to Solving Performance Problems with the SAS System a document that is available from the Scalability and Performance Papers page on rnd scalability papers . If you determine that your hardware is properly configured then review the SAS code. Transformations generate SAS code. Understanding what this code is doing is very important to insure that you do not duplicate tasks especially SORTs which are resource-intensive. The goal is to configure the hardware so that there are no bottlenecks and to avoid needless I O in the process flows. Capturing Additional SAS Options in the SAS Log To analyze performance we recommend that you turn on the following SAS options so that detailed information about what the SAS tasks are doing is captured in the SAS log FULLSTIMER MSGLEVEL I this option prints additional notes pertaining to index merge processing sort utilities and CEDA usage along with the standard notes warnings and error messages SOURCE SOURCE2 MPRINT NOTES To interpret the output from the FULLSTIMER option see A Practical Approach to Solving Performance Problems with the SAS System a document that is available from the Scalability and Performance Papers page on rnd
