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 ADSelfService Plus?
Related Articles
Inputs required for analyzing Performance Issues
We need a couple of details to analyze Performance issue. So, please send the below details : Below mentioned details should be gathered before restarting the application. 1. Let us know whether you are taking Scheduled full backup or backup without ...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 ...solution for postgres 11 upgrade issues
When Supportcenter Plus 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 ...