we are having huge delays on software delivery engine. I have narrowed down this to the nature of Intellirollup patches. When they are being staged or deployed, there is a huge overhead in the System Delivery Engine.
The thing is, Intellirollup patches include more than 200 or 300 packages each. This is then being staged to more than 100 servers and creates a big job, which slows down Software Delivery Engine big time. Practically the whole infrastructure slows down, DTS transfers are halted and Software delivery gets very,very slow...
Is there any way to assign more memory or CPU to the engine itself? Are there any workarounds?
Using Intellirollups should simplify the process, but instead it resulted as a big drawback for us.
Version r14 SP2
One of the main benefits of the Intellirollup is that once you have done
the staging of the one then each month after only the new patches for that
month are sent and not the whole lot again.
From: rlikar <firstname.lastname@example.org>
Sent: 21 January 2019 10:47
To: STEVE PARKER <email@example.com>
Subject: Re: - Software Delivery Engine
*CAUTION: This email originated from outside of Broadcom. Do not click
links or open attachments unless you recognize the sender and know the
content is safe.*
CA Communities <https://communities.ca.com/?et=watches.email.thread>
Software Delivery Engine optimization
created by rlikar
<https://communities.ca.com/people/rlikar?et=watches.email.thread> in *CA
Client Automation* - View the full discussion
Some additional input for improving the health of the SD database, which will lend to performance improvements of the System Delivery Engine:
1) Cleanup and delete obsolete software packages from the DSM Software Library. There's a database tool within WinOffline that will help identify which software packages are "unused" and not installed on any agents.
2) Run CleanApps, to remove duplicate usd_applic records from the database. You can find the steps to do this here: Software Delivery Job Container Build Failed - CA Knowledge
3) While CAF is stopped, run these queries to cleanup orphaned records in the software delivery database tables. Be sure to terminate/delete all existing job containers first. If any fail to terminate on their own, this script will also fix that:
print 'Cleanup jobs in terminating state.'declare @var_objectid varchar(50)declare job_delete cursor forselect objectid from usd_job_cont where state=8 and objectid in (select jobcont from usd_jcview) and objectid in (select jcchild from usd_link_jc) and objectid in (select jcont from usd_link_jc_act)open job_deletefetch job_delete into @var_objectidwhile (@@fetch_status=0)begin delete usd_jcview where jobcont=@var_objectid delete usd_link_jc where jcchild=@var_objectid delete usd_link_jc_act where jcont=@var_objectid delete usd_cc where objectid=@var_objectid delete usd_job_cont where objectid=@var_objectidfetch job_delete into @var_objectidendclose job_deletedeallocate job_deletegoprint 'Mark usd_applic records, referencing a non-existent usd_activity, for cleanup.'update usd_applicset activity=0x00000000000000000000000000000000where activity <> 0x00000000000000000000000000000000and activity not in (select objectid from usd_activity)goprint 'Cleanup usd_applic records orphaned from any activation procedure.'delete from usd_applic where actproc not in (select objectid from usd_actproc) and actproc <> 0x00000000000000000000000000000000goprint 'Cleanup usd_applic records orphaned from any usd_target (i.e. non-existent target).'delete from usd_applic where target not in (select objectid from usd_v_target)goprint 'Cleanup orphaned usd_activity records.'delete from usd_activity where objectid not in (select activity from usd_link_jc_act)goprint 'Cleanup orphaned usd_actproc records.'delete from usd_actproc where rsw not in (select objectid from usd_rsw)goprint 'Cleanup orphaned usd_link_swg_sw records.'delete from usd_link_swg_sw where sw not in (select objectid from usd_rsw)go
The combination of all three of these actions should improve the overall performance of software delivery and the delivery engine.