4 Replies Latest reply on Jun 15, 2016 8:33 AM by Bill Robinson

    Display "Deploy Status" is very slow

    Natali Nogueira

      Some results jobs show slow to display "Deploy Status" and to load the information about the deploy execution.

      Sometimes occurs that lock of Bladelogic Console. In this case it's necessary restart the Console.

        • 1. Re: Display "Deploy Status" is very slow
          Bill Robinson

          what version of bsa is this ?  how large are the job_run_event and deploy_job_run_event tables?  what database backend ?  are table stats current ?

          • 2. Re: Display "Deploy Status" is very slow
            Natali Nogueira

            - BSA is 8.5.00.469.

             

            I need to check the information of tables.

            • 3. Re: Display "Deploy Status" is very slow
              Natali Nogueira

              =================================================================================

              INFORMACOES DA TABELA bladelogic.job_run_event

              =================================================================================

               

              OWNER TABLE_NAME LAST_ANALYZED NUM_ROWS TABLE_SIZE_MB TABLESPACE_NAME EXTENTS_USED       BLOCKS PAR

              ---------- ----------------------------------- -------------------- ------------ ------------- --------------- ------------ ------------ ---

              BLADELOGIC JOB_RUN_EVENT 10-06-2016 22:10:46 22,788,247         4,380 BLADELOGIC_DATA 260      559,560 NO

               

              =================================================================================

               

              =================================================================================

              INFORMACOES DA TABELA bladelogic.deploy_job_run_event

              =================================================================================

               

              OWNER TABLE_NAME LAST_ANALYZED NUM_ROWS TABLE_SIZE_MB TABLESPACE_NAME EXTENTS_USED       BLOCKS PAR

              ---------- ----------------------------------- -------------------- ------------ ------------- --------------- ------------ ------------ ---

              BLADELOGIC DEPLOY_JOB_RUN_EVENT 10-06-2016 22:04:00 15,750,391           875 BLADELOGIC_DATA 188      111,493 NO

              =================================================================================

              • 4. Re: Display "Deploy Status" is very slow
                Bill Robinson

                those sizes don't seem terrible but they could be smaller.  anyway - can you have your dba setup a sql trace session during a relatively quiet period and you reproduce the issue in the gui, while having the gui logging set to debug ? and then open a support case w/ that info.

                1 of 1 people found this helpful