Performance issues and NMC's post upgrade to 9306. (XSSMigrationSchedule , cleanSoftwareCIs)

Performance issues and NMC's post upgrade to 9306. (XSSMigrationSchedule , cleanSoftwareCIs)

Team, 

We are recently facing performance and crash (NMC) issues after upgrading to recent versions (9306 and above). Seems like there are few new schedules introduced which might be causing the issue. 

Two of them are "CleansoftwareCIs" and "XSSMigrationSchedule". They are actually one time schedules. 

If they are not completed and running for a long time it can cause issues, so if you face any performance issues get the output for the below queries. 


select * from schedule where schedule_name like '%cleanSoftwareCIs%' 

From the output of the above query , please take the  schedule_id and apply in the below query. 

select * from task_input where schedule_id= ID FROM THE PREVIOUS QUERY 

select count(*) from ci inner join softwareinstallation sins on ci.ciid=sins.ciid left join softwareinfo si on ci.ciid = si.ciid where si.ciid is null 

select * from schedule where schedule_name like '%XSSMigrationSchedule%' 

From the output of the above query , please take the  schedule_id and apply in the below query. 

select * from task_input where schedule_id= ID FROM THE PREVIOUS QUERY 


                New to ADManager Plus?

                  New to ADSelfService Plus?

                    • Related Articles

                    • Performance Debug

                      For Performance/slowness issues instead of taking Threaddump manually or instead of invoking PerformanceTool make use of the below URL when the issue occurs, http://servername:portnumber/servlet/PerformanceDebug The above URL works even when the ...
                    • How to enable Performance monitoring tool ?

                      To analyze Performance issues, logs and tuning alone won't be sufficient. Hence, we need to follow a few steps to enable the Performance Monitoring tool, which will monitor the application's performance and automatically collects the data when the ...
                    • 10.5 Linux Upgrade failure and solutions

                      Traces in logs : 1. java.lang.Exception: InitPgsqlScript exited with value :: 1 at com.adventnet.persistence.PostgresPreProcessor.executeInitPgsqlScript(PostgresPreProcessor.java:1733) 2. PGSQL Permission related errors. 3. SDP MSP installed as root ...
                    • How to address Performance issue ?

                      Application will face the performance issue because of couple of reasons. 1. System requirements are not met: Refer this link to ensure the specifications are met as per the standards. 2. Application architecture should be 64-bit for better ...
                    • SDP MSP solution for postgres 11 upgrade issues

                      When ServiceDesk Plus MSP is upgraded to 14300 or later, postgres is also upgraded to 11.17. If you are using bundled postgres, data migration through pgdump and restore mechanism also happens. To ensure efficiency in Postgres 11.17, make sure your ...