Questions about Optimization in Adobe Campaign - Open Deliveries taking too long

Hi,

The only specific cache for the console is at the console level itself (which you can hard and soft clear). That said, clearing the console cache typically causes load times to increase initially.

I recommend reaching out to Campaign Support, as performance troubleshooting/optimization often requires a holistic view of the system to understand what changes to make.

How I would typically work to troubleshoot these issues is by asking the following questions:
1) When did this issue first start? Was performance always a problem, or did this recently crop up after an upgrade or some other application work?

2) Does this happen with all users or just a few? If only a few users are impacted, what makes them different? Are they logging in from a different network? Are their users configured with different permissions? Is the issue machine-specific?

3) If you have a load-balanced configuration, do you experience the same performance issues when you log into each server directly?

4) Is it just opening deliveries, or is it general system slowness?

5) Are there times in the day when performance is better or worse? If so, then have you checked for long-running queries or blocking at the database level?

6) Have you checked server-side performance metrics (CPU, memory, IOPs)?

7) Have you analyzed the network traffic (request/response) between the console and the application? This can be done using tools such as Wireshark and Fiddler (https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/trace-viewer-and-campaign-client/m-p/356992#M6971)

😎😎😎  Are the appropriate indexes in place at the DB level?

9) Is the web application crashing?

There are other potential steps to examine, but as I said, I would try to answer the above and then engage Support (especially if your environment is Adobe-hosted).

Regards,

Craig