Indicadores de Desempenho de Bases de Dados

Abstract

Nowadays, due to the ease of access to the Internet, there has been an increase of users that utilize e-commerce platforms. This accelerated growth together with the demand for high availability associated with these kind of services creates, within the companies, the need to ensure the performance levels of the services they provide. Databases are a main part of the business success and their performance is a process that demands continuous improvement. Farfetch is a company that fits into the described setting due to the growth recorded on their business, therefore the performance of the services they provide is absolutely essential in order to strengthen their position on the market. This thesis has as its objectives the identification of a set of indicators that can allow for the monitoring of the databases which serve as grounds for the business and from that defined set develop a tool that will collect, store and present the values collected in such a way that will allow the improvement of the preventive administration of databases. There are some database monitoring tools available on the market, however they don't fit the individual needs of each particular business and they do not possess the proactive characteristics that we aim to develop on this thesis. Therefore it is also a goal of this thesis to develop a system easily changeable and that presents the data in such a way that allows for a proactive analysis. The developed tool presents a set of performance indicators for the servers where the databases are stored and also presents a set of performance indicators for each database stored on the server. Another functionality of the tool is the ability to compare data from different time ranges, which allows for a proactive performance analysis.Finally, the thesis will be evaluated by the Database Administration Team currently working at Farfetch that will utilize the developed system.