0 Replies Latest reply on May 1, 2018 7:59 PM by Mark Covian

    JBOSS SQL Server High CPU 100% Kill Connection and they resume.

    Mark Covian Newbie

      Hello,

       

      I have a SQL Server being accessed by 2 JBOSS servers.  From time to time multiple identical SQLs are submitted that consume 100% of the CPU.  All connections are killed, CPU drops from 100% to 5%.  Within 30 seconds, the connections are re-established and the SQLs are submitted again and again CPU is run up to 100%.  Kill off the connections and again the SQLs are submitted and again CPU is run up to 100% on the SQL Server.

       

      Finally the SQL Server service is restarted, all SQL Server\JBoss connections are killed.  The JBoss\Application connections are re-established and normal processing continues.

       

      The event only occurs 1 or twice a week.

       

      SQL Server 2014, Latest SP.

       

      Any Ideas are appreciated, I'm not a JBoss developer just supporting the SQL Server.

       

      Thank You - Covi