Logo des Repositoriums
 

Combining Application-Level and Database-Level Monitoring to Analyze the Performance Impact of Database Lock Contention

dc.contributor.authorKnoche, Holger
dc.date.accessioned2023-03-02T13:44:28Z
dc.date.available2023-03-02T13:44:28Z
dc.date.issued2016
dc.description.abstractDatabase lock contention can severely impact application performance and limit scalability. This can be of particular importance when major modifications are made to transactional software, such as large refactorings or modernization projects. In order to assess the criticality of such modifications, it is necessary to measure the current degree of database lock contention, and attribute the effects to the appropriate sections of the application. However, current monitoring tools do not provide both application-level and database-level monitoring data with sufficient detail at the same time. In this paper, we present an approach to combine application-level and database-level monitoring to measure lock contention on a per-section basis, and present first experimental results from a prototypical implementation for PostgreSQL.en
dc.identifier.pissn0720-8928
dc.identifier.urihttps://dl.gi.de/handle/20.500.12116/40638
dc.language.isoen
dc.publisherGeselllschaft für Informatik e.V.
dc.relation.ispartofSoftwaretechnik-Trends Band 36, Heft 4
dc.titleCombining Application-Level and Database-Level Monitoring to Analyze the Performance Impact of Database Lock Contentionen
dc.typeText/Journal Article
gi.citation.publisherPlaceBonn
gi.conference.sessiontitleSonderteil: Proceedings of the Symposium on Software Performance (SSP 2016), 8. - 9. November 2016, Kiel

Dateien

Originalbündel
1 - 1 von 1
Vorschaubild nicht verfügbar
Name:
11-Combining_Application-Level_and_Database-Level_Monitoring_to_Analyze_the_Performance_Impact_of_Database_Lock_Contention.pdf
Größe:
183.42 KB
Format:
Adobe Portable Document Format