OGK-4 implements solutions of monitoring of databases

The Softline company performed delivering solutions of monitoring of databases in OGK-4.

In anticipation of

"OGK-4 was faced the need to simplify service of databases without staff increase. We stopped on option of acquisition of software providing idle time and convenient monitoring of a DB", – Roman Melikhov, the head of department of information systems of JSC OGK-4 told.

Selection

On analysis results of offers, solutions Quest — SpotLight On SQL Server Enterprise and Foglight Performance Analysis for SQL Server as which supplier the company acted were selected Softline.

Implementation

IT specialists of OGK-4 independently implemented the selected solutions, using consultations of staff of Softline and technical support of Quest Software on optimization of a DB and integration of software into the existing infrastructure. Functioning of IT-systems was not interrupted.

Results

Product introduction allowed to perform fast and convenient monitoring of performance (including the retrospective analysis) the SQL server and blocking of users, timely to react to the arising problems and to permit them. Time of the analysis and solution of incidents was reduced by 2-3 times.

Responses

"Before implementation we had to open daily SQL Server Management Studio, to check working off of SQL tasks and volume of free disk space, to manually remove blocking of users of a DB. In the presence of serious blocking it was necessary to start the SQL Profiler that reduced the capacity of the server and complicated work of users. After software implementation the operational notification about problems happens instantly, all necessary information is displayed in one console of the application therefore it is easily perceived. The efficiency of the solution of incidents increased, time for operation of systems decreased", – Roman Melikhov notes.