0
votes

We are running an azure SQL database on an old resource group with a not great name, so I wanted to move the databases to a new Resource group, when doing so it seems to all move ok, but we don't see any metrics information like CPU,Logio, Dataio for the databases if I move it back to the original resource group that the metrics are shown there with no issues and even show the data when it was on new resource group. I have tried looking metrics settings but does not make a difference, anyone got any ideas?

New resource group New Resource Group no data

old resource group Moved back to the old group seems fine

The staging Database server we have I have managed to move around to different resource groups with no issues, just this one seems to an issue, I searched everywhere and no seen anyone else with the issue. The only difference is that Production is hyperscale and staging is dtu

1
I asked Azure Support, please waiting the replay.Leon Yue

1 Answers

0
votes

I contacted with Azure Support and they give me the answer:

The reason is Metrics provider is Microsoft.Insights, it doesn't support move resource group and subscription:

enter image description here

Reference: microsoft.insights.

When we move the SQL database to another resource group, it will get a new resource ID and new Metric.

enter image description here

Screenshot:

enter image description here

Hope this helps.