Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-17858

Nov 2021 EOM - Inventory Activity Report - qry_ListInventoryDetails

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Closed/Resolved by Caller
    • Affects Version/s: CFA 2021R6
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • SCRUM Team:
      Brotherhood of Mutants

      Description

      Further to the EOM slowdown that was seen during the November EOM, Tim indicated that there was an issue with qry_ListInventoryDetails which runs as a part of the Inventory Activity Report.

      MXINC-2801

      1, the Inventory Activity report was the top CPU consumer in this period. I accounted for 45% CPU and 95% of the reads.
      This report relies on our old friend qry_ListInventoryDetails which is known to be a problem across the business and looks to have been a contributing factor here.

      Please sync up with the trunk team and investigate if there are any improvements that we can make to qry_ListInventoryDetails

        Attachments

        1. dbo.qry_ListInventoryDetails.sql
          35 kB
          Caner Saritac
        2. image-2021-12-07-16-32-35-467.png
          42 kB
          Colin Wyatt-Goodall
        3. image-2021-12-07-16-33-27-665.png
          42 kB
          Colin Wyatt-Goodall
        4. image-2021-12-07-16-36-44-453.png
          79 kB
          Colin Wyatt-Goodall
        5. image-2021-12-07-16-37-07-987.png
          29 kB
          Colin Wyatt-Goodall

          Issue Links

          is related to

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-18003 Research Spike: qry_ListInventoryDetails

          • Closed

            Activity

              People

              • Assignee:
                Robert.Johnson Robert Johnson (Inactive)
                Reporter:
                will.englefield Will Englefield (Inactive)
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.