CCO manager query consumes a lot of CPU

[cmelchor]

01.pngDear Checkout experts,

It is being presented that with the client, when starting the apache service of the manager, it executes a query to the ASYNCQUEUEENTRY table in the SQL database, which is causing the server's CPU to go up to 100%. We will share this query later

The query "select count(OBJECTKEY) from [ASYNCQUEUEENTRRY]" was executed, evidencing that it returns more than 5 million records.

We want to know if there is a way to purge the records in this table to improve CPU performance on the client's server.

The client is in the manager version FP12 PL08

Share Query that is running

SELECT t0.OBJECTKEY
,t0.ALIVETIME
,t0.CREATEDAT
,t0.CREATEDBY
,t0.DESCRIPTION
,t0.EXECUTIONDONE
,t0.EXECUTIONRESULT
,t0.EXECUTIONSTART
,t0.EXECUTIONSTATE
,t0.EXECUTORBEANNAME
,t0.FILE_CREATED
,t0.FILE_NAME
,t0.VERSION
,t0.JOBTYPE
,t0.LASTSTATECHANGE
,t0.MARKEDFORCANCELLATION
,t0.MODIFIEDAT
,t0.MODIFIEDBY
,t0.PROCESSID
,t0.QUEUEGROUP
,t0.RESULTS_COUNT
,t0.RESUMABLE
,t0.STATUSMESSAGE
,t0.WORKER_EXECUTION_INFO
,t0.QUEUESCHEDULEDENTRY_OBJECTKEY
FROM ASYNCQUEUEENTRY t0
WHERE (
(t0.EXECUTIONSTATE = @P0)
AND t0.QUEUEGROUP NOT IN (
SELECT DISTINCT t1.QUEUEGROUP
FROM ASYNCQUEUEENTRY t1
WHERE (t1.EXECUTIONSTATE = @P1)
)
)
ORDER BY t0.QUEUEGROUP ASC
,t0.CREATEDAT ASC

I appreciate it if someone knows about what else can i check.

Thank you

kind regards,

Cristian Melchor

[Former Member]

Hi Christian,

do you know the solution for this? I have the same problem.

Thank you very much, best regards

Daniela

[cmelchor]

Hello,

Actually what I had to do on that occasion was to reimplement the manager database from scratch.

I hope it is helpful to you.

best regards

Cristian Melchor.

[dustin_be]

Hi, we suffer the same problem.
Any solution so far?

Best regards

[jhoncap2]

Hi Cristian, hope you're fine!

I'm having the same problem with my client. Were you able to solve this issue? If so, how did you do it?

Thank you so much in advance.