AnsweredAssumed Answered

Software Delivery Engine optimization

Question asked by rlikar on Jan 21, 2019
Latest reply on Jan 28, 2019 by Brian_Fontana

Like • Show 0 Likes0
Comment • 2

Hey guys,

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.

Any suggestions?

Version r14 SP2

Thanks,

No one else has this question

Outcomes

Steve_Parker

Jan 25, 2019 10:26 AM

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 <communityadmin@communities-mail.ca.com>

Sent: 21 January 2019 10:47

To: STEVE PARKER <parst04@ca.com>

Subject: Re: - Software Delivery Engine

optimization

*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

<https://communities.ca.com/message/242162100-software-delivery-engine-optimization?et=watches.email.thread>

1 person found this helpful

Actions

Brian_Fontana

Jan 28, 2019 4:17 AM

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 for

select 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_delete
fetch job_delete into @var_objectid
while (@@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_objectid
fetch job_delete into @var_objectid
end

close job_delete
deallocate job_delete
go

print 'Mark usd_applic records, referencing a non-existent usd_activity, for cleanup.'
update usd_applic
set activity=0x00000000000000000000000000000000
where activity <> 0x00000000000000000000000000000000
and activity not in (select objectid from usd_activity)
go

print 'Cleanup usd_applic records orphaned from any activation procedure.'
delete from usd_applic where actproc not in (select objectid from usd_actproc) and actproc <> 0x00000000000000000000000000000000
go

print '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)
go

print 'Cleanup orphaned usd_activity records.'
delete from usd_activity where objectid not in (select activity from usd_link_jc_act)
go

print 'Cleanup orphaned usd_actproc records.'
delete from usd_actproc where rsw not in (select objectid from usd_rsw)
go

print '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.

-Brian

Actions

2 Replies

Steve_Parker Jan 25, 2019 10:26 AM
Mark Correct
Correct Answer
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 <communityadmin@communities-mail.ca.com>
Sent: 21 January 2019 10:47
To: STEVE PARKER <parst04@ca.com>
Subject: Re: - Software Delivery Engine
optimization

*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
<https://communities.ca.com/message/242162100-software-delivery-engine-optimization?et=watches.email.thread>
1 person found this helpful
Like • Show 0 Likes0
Actions
Brian_Fontana Jan 28, 2019 4:17 AM
Mark Correct
Correct Answer
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 for

select 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_delete
fetch job_delete into @var_objectid
while (@@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_objectid
fetch job_delete into @var_objectid
end

close job_delete
deallocate job_delete
go

print 'Mark usd_applic records, referencing a non-existent usd_activity, for cleanup.'
update usd_applic
set activity=0x00000000000000000000000000000000
where activity <> 0x00000000000000000000000000000000
and activity not in (select objectid from usd_activity)
go

print 'Cleanup usd_applic records orphaned from any activation procedure.'
delete from usd_applic where actproc not in (select objectid from usd_actproc) and actproc <> 0x00000000000000000000000000000000
go

print '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)
go

print 'Cleanup orphaned usd_activity records.'
delete from usd_activity where objectid not in (select activity from usd_link_jc_act)
go

print 'Cleanup orphaned usd_actproc records.'
delete from usd_actproc where rsw not in (select objectid from usd_rsw)
go

print '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.

-Brian
Like • Show 0 Likes0
Actions

Software Delivery Engine optimization

Outcomes

Related Content

Recommended Content