The MS SQL Integration Service Layer

The tests mapped to this layer help administrators achieve the following:

• Monitor how efficiently the data flow engine performs in-memory processing, detect abnormal memory usage by the engine, and determine how the buffers need to be sized to optimize engine performance;
• Track package execution, detect latencies in the process, and isolate the components causing the latency;
• Track package status and promptly capture failures / abnormalities;
• Capture task failures, errors, and warnings on-the-fly;
• Measure the concurrent package load on SSIS, and ensure that the server is rightly configured to handle the load;

Figure 1 : The tests associated with the MS SQL Integration Service layer