Basom Consulting Audit and Support
CONSULTING & AUDITS
February 2021 – April 2021 (1 month)
Paris, France
The report generation process causes performance degradation and this during each execution, i.e. 5 times per day.
Thus, the objective of the mission is to identify why this process affects user performance and also to resolve this same issue.
A complete analysis of all SQL server instances and the physical machine revealed that the report generation process runs on the same virtual machine as the other SQL instances. In addition, some steps executed during extraction and normalization result in the creation of indexes and the execution of very expensive Deletes on large tables.
Armed with this information, Basom now has a clear path to improve its performance, namely: move the report creation process as well as the SQL instance of the reports to a separate instance. In addition, the analysis revealed a multitude of Active Directory accounts that have access to the data without really needing it.