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