Дистанционный мониторинг событий, вызывающих снижение производительности информационных и информационно-поисковых систем

Abstract

The object of research is events that randomly or intentionally exploit the built-in locking mechanism of SQL Server, which significantly reduce the performance of information and information search engines. The subject of the research is the remote monitoring of blocking processes. The purpose of the research is to develop a secure remote monitoring method that can quickly and reliably detect events that cause the operation of the built-in locking mechanism of SQL Server. The use of monitoring is necessary to maintain the required level of system performance, as well as to promptly detect impacts on the information system that destroy the integrity of databases. This article is aimed at solving the main problems of remote monitoring: ensuring the completeness of the assessment of the condition and reliable, prompt transmission of the received information through an open channel. The key feature of the proposed remote monitoring method is the identification of SQL Server objects and SQL language constructs used to implement remote monitoring, taking into account the completeness of the information received. A high degree of security of the remote monitoring information environment is provided by the system means of implementing the author's client-server architecture. It is shown that the efficiency and security of the transfer of valuable control data is ensured by the use of stored procedures. Known stored procedures are redundant, so the authors needed to create their own monitoring tool, which is the main result of this article. The results of the research can be applied in the design of reliable and secure information and information search systems for various purposes.