RSS
Логотип
Баннер в шапке 1
Баннер в шапке 2
Project

The TGC-2 conducted examination of the SQL servers

Customers: TGC-2 - Territorial generating company No. 2

Contractors: Alan IT
Product: SQL Workloads Software Asset Management (SAM)

Project date: 2016/08  - 2016/09

Content

On December 5, 2016 the ALAN IT company announced the analysis of a SQL environment in TGC-2 LLC.

Project Tasks

TGC-2 made the decision on need to carry out load analysis of SQL servers and to receive the recommendations of specialists, with assistance of Microsoft, within the SAM Services program.

Attracted ALAN IT LLC to the project.

Central office TGK-2, (2014)

In 2014 TGC-2 already used services of SAM Services in the SAM Baseline project, in 2016 SAM SQL Workload is selected.

File:Aquote1.png
Inspection of SQL servers for assessment of performance and licensing, identification strong and weaknesses, risks and vulnerabilities became a project objective.

Alexander Belavin, deputy head of department of ISIT, TGC-2 LLC
File:Aquote2.png

Project Progress

At the first stage specialists carried out the analysis of a configuration of the hardware of SQL servers.

The assessment of a configuration and performance of each copy of SQL servers is carried out.

The SQL infrastructure security level is checked.

The final stage of the project - license reconciliation which consequence optimization of use of the operating products SQL turned out to be.

Project Results

The recommendations prepared by experts ALAN IT became project deliverables. Recommendations are submitted on elimination of the risks connected with security on performance improvement of DBMS, economy of the place and to reduction in cost of storage of backup copies.