SoftPoint PerfExpert

Main article: IT Service Management, ITSM

PerfExpert is a technology for monitoring, monitoring and analyzing the state of the information system and related IT infrastructure.

2024: Compatibility with Postgres Pro DBMS versions 13, 14, 15, 16

Postgres Professional and SoftPoint announced compatibility of their products on October 28, 2024.

The certificate issued by Postgres Professional confirms the correct operation of the Postgres Pro Standard, Postgres Pro Enterprise DBMS, their certified editions (versions 13, 14, 15, 16) and the PerfExpert server and database performance monitoring platform.

2016: Release of PerfExpert service

On January 11, 2016, it became known about the release of SoftPoint's PerfExpert service.

The performance monitoring service architecture complements the standard server administration tools. The administrator of the company's information system has at his disposal the maximum amount of information for correct decision-making. Performance monitoring technology eliminates changes to the source code of application servers, SQL databases, or user programs of departmental employees located not only on the local network, but also in different cities and regions.

Screenshot of the software window, (2016)

The performance monitoring software continuously monitors MS SQL Server database servers, eliminates gaps in the specified monitoring time ranges, and always all the necessary information for analyzing and finding problems is available.

The performance monitoring and database analysis system processes key information system health parameters:

• Dynamics of load on the DBMS server with detail by user sessions
• User Errors and Emergencies Suboptimal Data Requests from the Application
• Business Duration Analytics
• Database and Server Maintenance Analytics

Based on the results of the collected statistical data over a long period of time, an analytical report on the operation of the information system as a whole is formed, which makes it possible to identify specific problem areas and the causes of their occurrence. Monitoring reports also contain information on the main elements of the servers:

• CPU load, CPU
• of RAM,
• virtual memory,
• number of processes performed,
• loading the disk array and network.

Main tasks

Perfexpert's performance monitoring system performs three main tasks:

• Online monitoring of the health of the information system and the associated hardware and software complex of servers. The administrator has all the necessary information to make the right decision in dealing with emergency situations, failures, errors and slowdowns. Prompt and effective problem solving will minimize business losses.
• Efficient search for bottlenecks in the operation of the information system. In solving this problem, performance monitoring provides information about hardware load, information about heavy and suboptimal database requests, information about the number of errors and how to solve them. The monitoring system allows you to return to the problem situation, for example, for several days back and conduct a qualitative analysis with the identification of the main causes of problem situations. Analytics with different levels of detail.
• For administrators - analytics on information system maintenance, configuration of hardware and software resources;
• For programmers - the heaviest lines of code, locks and deadlocks;
• For business users - analytics on the duration of operations in the information system, the number of errors, user activity.

The performance monitoring system allows you to proactively respond to performance degradation, so the tool is recommended to be used not only in case of performance problems, but also in cases of normal operation to prevent these problems.

PerfExpert is integrated with Microsoft SQL Server databases, any circulation and customized applications on the 1C: Enterprise platform.

Features of the technology

• Monitors the performance of key nodes of the IT infrastructure in real time: Database/Application/Terminal servers.
• It performs autonomous collection, aggregation and output of ready-made statistics for a quick and effective analysis of any anomalies in the system performance and establishing the reasons up to a separate sql-query, lines of 1C code that introduce load.
• Continuously monitors database quality of service for best performance.
• Collects all necessary information to investigate the causes of redundant locks in the system.
• Provides APDEX according to the specified parameters of individual business transactions, in real time.
• Compatible with any versions DBMS MS SQL and information bases. 1C: Enterprise
• Provides the ability to analyze historical data offline.
• It works in real time, while the total load on resources does not exceed 3%.
• When implemented, does not require modification of the application code.