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...

Full description

Saved in:

Bibliographic Details
Published in:	TELFOR : 2017 25th Telecommunication Forum : 21-22 November 2017 pp. 1 - 4
Main Authors:	Dundjerski, Dejan, Lazic, Stefan, Tomasevic, Milo, Bojic, Dragan
Format:	Conference Proceeding
Language:	English
Published:	IEEE 01.11.2017
Subjects:	Azure SQL database platform Cloud services Electronic mail Feature validation and testing Monitoring Pipelines Relational databases Schema issue advisor Telemetry Testing
Online Access:	Get full text
Tags:	Add Tag No Tags, Be the first to tag this record!

Description
Summary:	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