Performance Audit of a SQL Server
FASHION & COSMETICS
December 2020 – January 2021
Paris, France
Identify the origin of performance issues occurring frequently on the database server and propose concrete actions to resolve them.
With a monitoring solution developed in-house, “CMM for SQL Server”, I was able to quickly identify deadlocks and lock waits as the main performance bottleneck on SQL Server. By digging deeper with eXtended Events and ClearTrace, a trigger that was itself updating another table using a large SELECT, was able to be identified and stopped.
In collaboration with the development team, we were able to improve the SELECT filter so that it is only used in very specific cases.
I am currently working on correcting configuration errors, implementing “best practices” and better using resources on the server.