Improving schema issue advisor in the Azure SQL database

An analysis of the telemetry data in the Azure SQL database reveals that the most frequent anomalies are due to the schema inconsistency errors which impairs normal functioning of the customer applications. We assumed that direct e-mail notifications to the customers could shorten time to resolve th...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:TELFOR : 2017 25th Telecommunication Forum : 21-22 November 2017 S. 1 - 4
Hauptverfasser: Dundjerski, Dejan, Lazic, Stefan, Tomasevic, Milo, Bojic, Dragan
Format: Tagungsbericht
Sprache:Englisch
Veröffentlicht: IEEE 01.11.2017
Schlagworte:
Azure SQL database platform
Cloud services
Electronic mail
Feature validation and testing
Monitoring
Pipelines
Relational databases
Schema issue advisor
Telemetry
Testing
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:An analysis of the telemetry data in the Azure SQL database reveals that the most frequent anomalies are due to the schema inconsistency errors which impairs normal functioning of the customer applications. We assumed that direct e-mail notifications to the customers could shorten time to resolve the problems. The benefits are first validated by sending e-mail recommendations manually. Then, an improved schema advisor which detects anomalies and automatically sends the appropriate notifications to the customers. Implementation which respects the feedback from the users was accompanied by continuous testing process as a modern way of a new feature development. Evaluation in a prolonged period confirmed the expected benefits.
DOI:10.1109/TELFOR.2017.8249450