AzureSQL databases - wrong tags

[FuriousDBA]

Hi,
I have an AzureSQL server master database added as an instance, plus two databases for that server.
I've created an Tag, with two values. One Tag value is assigned to 1st database, another value is assigned to 2nd database.
I did not assign any tag for the root level of AzureSQLServer or master database.

In the GUI when I go to / Configuration / Tags I see these tags, but they are wrongly checked.
Moreover depending on my last database tags view they are switching from one value to another.
For example I go to 1st database tags, see the correct value, then go to root level (azure server) and see the same value.
Then I go to 2nd database tags, I see the correct (different) value, but then when I go back to root level (azure server) I see the value is switched with the same what was on the 2nd database.
Hopefully it is understandable :)

Thx

[DavidWiseman]

Hi,

The way it works is there is a separate InstanceTags table for AzureDB that associates tags at the server level for AzureDB and a InstanceIDsTags that associates a tag with an individual SQL instances (or AzureDBs). When AzureDBs were added to DBA Dash I wanted to be able to configure tags at the server level rather than for individual AzureDBs (which for me would all share the same tags- same GEO, product etc).

When you configure tags for an individual AzureDB, it's the tags associated with the server that are modified. So if you switch a value for 1 database, you are actually switching it for all. I agree this isn't very intuitive and should probably be changed. I've never had a need to manually configure tags for individual AzureDBs (only at server level) so this issue hasn't come up. The system generated tags are at the individual AzureDB level though as things like CPU count can vary between DBs.

Thanks,

David

[FuriousDBA]

Thx for the answer. In my scenario single AzureSQL server hosts databases for multiple customers, that's way I need a tag for each individual database.

[DavidWiseman]

Included in 3.31 🚀