2 Replies Latest reply: Jul 10, 2013 8:16 AM by Carl Wilson RSS

    Intermittent performance issue in Remedy

    S R

      Hi Team,

       

      We have faced intermittent performance issue in Remedy. Users were unable to save  incidents and SLAs were missed.

      Our Mid-Tier is installed on the separate server with Load Balancer setup.

      Server group configuration: We have 2 Mid-tiers and 1 Web load balancer and 3 application server (1 admin server)

      Please find the attached environment details and the arerror.log snippet from during the issue concurrence.



      ============

      (SQL Server 11)

      Wed Jul 10 04:20:44 2013  390620 : The SQL database operation failed. (ARERR 552)

      Wed Jul 10 04:20:44 2013     [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation. (SQL Server 11)

      Wed Jul 10 04:20:44 2013  390620 : SQL database is now available (ARNOTE 592)

      ============

       

      Our environment details are given below:

       

      ARS server version and patch  :  7.6.04 SP4

      ITSM version and patch  :  7.6.04 SP4

      Mid-Tier version and patch  :  7.6.04 SP4

      Mid-Tier Server OS level and patch  :  Windows Server 2008 R2

      Web server version  :  Apache Tomcat/6.0.20

      Servlet Engine version  :  1.6.0_38

      Java version and build level  :  1.6.0_38

      Database structure  :  SQL 2008 Ent (A two node cluster for database)


       

       

      Server

      OS

      RAM

      HDD

      Database

      Application Server (AR System Server)

      2 Server x Windows 2008 R2 (64-bit), 8vCPU

      32 GB

      150 GB

      NA

      Web Server (Mid-Tier)

      2 Server x Windows 2008 R2 (64-bit), 8vCPU

      32 GB

      150 GB

      NA

      Database Server

      2 node Windows 2008 R2 (64-bit) cluster, 2x4 Core

      64 GB

      Tier 1 SAN storage, 1 TB

      SQL 2008 Ent (A two node cluster for database)

       

       

      I have attached the arerror.log. Kindly assist me to resolve this issue as soon as possible and let me know for more queries.

       

      Regards

      Sreekanth