Code was not updating the RequestedSLO as expected.

We had to change line 200 of the AutoScaler.cs file from ...

var index = availableSlos.IndexOf(currentSLO.ToString());

to...

var index = availableSlos.IndexOf(currentSLO.ToString().ToLower());

Once we did that, the RequestedSLO was showing correctly on the [dbo].[AutoscalerMonitor] table and also the ALTER DATABASE script was executing as expected to scale up/scale down the server.

Neither were happening with the old line 200.

I am also a Microsoft employee, you can reach me at jobender@microsoft.com.

Inspect line 200 of AutoScaler.cs and compare the currentSLO value with the availableSlos entries. Reproduce the autoscaler path and verify that RequestedSLO appears correctly in dbo.AutoscalerMonitor and that the ALTER DATABASE script executes for scale-up and scale-down.

Written by the indexing model from the issue text.