Article For
5.3

Ongoing Tasks Stats: SQL ETL Stats



SQL ETL Stats

SQL ETL Stats Closed View

SQL ETL Stats Closed View

SQL ETL Stats Closed View

  1. Task Type
    Click the arrow or the task type to toggle Closed/Expanded View.
  2. Task Name
  3. Transform Script
    Click to display the ETL transform script.
  4. Task Bar
    • Hover over the bar to display a tooltip with the task's information.
    • Click the bar for the expanded view.
    • Click and Drag the bar to slide the graph.
    • Zoom in & out using the mouse wheel.

SQL ETL Stats Expanded View

SQL ETL Stats Expanded View

SQL ETL Stats Expanded View

  • SQL ETL

    • Total Duration
      Overall ETL operation time, including the Extraction, Transformation, and Loading phases.
    • Batch Complete Reason
      The reason the operation ended, e.g. -
      "No items to process",
      "Stopping the batch because maximum batch size limit was reached",
      and others.
    • Currently Allocated
      The amount of memory allocated by the server to handle this task.
    • Batch Size
      Size of ETL batches.
  • Extract Phase

    • Duration
      The time it took to extract the documents from the database.
    • Extracted Documents
      The number of documents extracted from the database.
  • Transform Phase

    • Duration
      The time it took to process the documents using the transform script.
    • Transformed Documents
      The number of documents processed by the transform script.
    • Documents Processing Speed
      Average Doc/Sec transformation speed.
    • Last Transformed Etag for Document
      Last transformed document's identifier.
  • Load Phase

    • Duration
      The time it took to transfer the documents to their destination SQL table.
    • Successfully Loaded
      Documents transfer verification.
    • Last Loaded Etag
      Last loaded document's identifier.