Method for carrying out online monitoring on database server fault of convertor station control protection system

Abstract

According to a method for carrying out online monitoring on a database server fault of a convertor station control protection system, a server fault and warning event storage process is directly established by an sql language, then the storage process is directly called in real time by a Visual Basic application and information of a warning or fault event is acquired so as to achieve rapid positioning on a fault. A system automatically searches all servers on a host, all the servers are provided for an operator and the operator selects a server which needs to be monitored; the system is connected with the server; connection is judged whether to be successful; information of a warning and fault event data column is set, a warning and fault event of the server is tracked and warning and fault information is acquired; and the data column information of the warning and fault event is displayed, the fault is processed and the fault information is stored so as to complete the monitoring process. According to the method disclosed by the present invention, the server fault and warning event storage process is directly established by the sql language, then the storage process is directly called in real time by the Visual Basic and the information of the warning or fault event is acquired so as to achieve rapid positioning on the fault.

Description

technical field [0001] The invention relates to an online fault monitoring method for a database server of a converter station control and protection system, which relates to the field of converter station monitoring. Background technique [0002] In the DC converter station system, the control and protection system of the DC converter station is closely coupled with the server. The failure of the server may cause the failure of the host computer, which directly affects the safe operation of the host system of the DC converter station. Any tool for server diagnosis can only be completed with the help of the event detector that comes with the server when it needs to monitor server failures. The event detector that comes with the server is a tool for fault monitoring of all SQL servers used. In order to meet different There are many types of events and the amount of information in each event data column. When the staff of the DC converter station needs to monitor the server, t...

AI Technical Summary

Problems solved by technology

This method is relatively complicated to implement, and cannot perform real-time fault tracking on the server

[0005] The Chinese patent "ORACLE Database Operation Monitoring System" (publication number CN: 102855319A) proposes a stored procedure that calls the server Trace through the sql language to complete the monitoring of database addition, modification and deletion. It is not effective Other failures such as login failures detected in the database

Images