AnsweredAssumed Answered

Alfresco database Use huge CPU 90%

Question asked by rafter on Jun 11, 2014
Latest reply on Jun 16, 2014 by rafter
Hi,

i'll quickly describe you, my architecture:
i've 2 servers :
1-alfresco server ( tomcat )
2-sqlserver 2008 r2 database server where ive created my alfresco database and others like bonita …

when i monitor the database server, ifound the sql query that use 90% of the CPU.
so the consequence that other applications like bonita  are so slow.

here's the request that use CPU :

*****************************
select
            txn.id              as id,
            txn.commit_time_ms  as commit_time_ms,
            (select
                 count(node.id)
             from
                 alf_node node
             where
                 txn.id = node.transaction_id and
                 node.type_qname_id !=  @P0
            ) as updates,
            (select
                 count(node.id)
             from
                 alf_node node
             where
                 txn.id = node.transaction_id and
                 node.type_qname_id =  @P1
            ) as deletes
        from
            alf_transaction txn
         WHERE txn.commit_time_ms >=  @P2
          
          
          
               and txn.commit_time_ms <  @P3 
        order by txn.commit_time_ms ASC, txn.id ASC
*******************************

Outcomes