Alarm Server high bandwidth in ethernet network to SQL Server

Hi all,

We have a SCADA redundant system with Citect SCADA 2018.

  • Machine 1 - Citect Primary Server
  • Machine 2 - Citect Standby Server
  • Machine 3 - SQL Server (for alarm log device)

The larms are logged in SQL Server, using the Device AlarmHistDB.

Lately, we have observed extreme bandwidth from SQL Server to Citect Server 1 (constantly at the network limit which is 100Mbits/s).

 

if we stop the alarm server process in citect server 1, the network bandwidth to Citect 1 normalizes and the Citect Server 2 remains constantly low bandwidth.

Someone have the same issue. can you share the experience.

Thank you

Miguel 

Parents
  • Today, we have made additional tests.

    We saw that the Network bandwidth increase to the limit 100Mbit, every time that there is an interaction with SQL Database ( New Alarm, Alarm Acknowledge, Alarm fallback).

    Without interactions (New Alarm or Alarm Acknowledge or Alarm fallback), the network is working in normally.

    So, we tested this using some PLC Alarms, forcing an alarm entry in SCADA system.

    A simple one alarm entry in SCADA, produces an increase to 100% bandwidth, during approximately 40 to 60 seconds. Then it normalizes.

    So, we can conclude that if we have many alarm coming at same time to the system this can crash the Alarm Server.
Reply
  • Today, we have made additional tests.

    We saw that the Network bandwidth increase to the limit 100Mbit, every time that there is an interaction with SQL Database ( New Alarm, Alarm Acknowledge, Alarm fallback).

    Without interactions (New Alarm or Alarm Acknowledge or Alarm fallback), the network is working in normally.

    So, we tested this using some PLC Alarms, forcing an alarm entry in SCADA system.

    A simple one alarm entry in SCADA, produces an increase to 100% bandwidth, during approximately 40 to 60 seconds. Then it normalizes.

    So, we can conclude that if we have many alarm coming at same time to the system this can crash the Alarm Server.
Children
No Data