[User story] ....Identify metrics and dimensions that will impact SCI for a Azure SQL database

[srini1978]

As a developer I want to identify all the metrices and the corresponding dimensions that will impact SCI scores for an Azure SQL database so that I can call the Azure Monitor API with the right metric name and filter.

Implementation Idea To identify all metrics that are possible in an Azure SQL database, call the REST APIs given below.

https://learn.microsoft.com/en-us/azure/azure-monitor/essentials/rest-api-walkthrough?tabs=portal#retrieve-metric-definitions https://learn.microsoft.com/en-us/azure/azure-monitor/essentials/rest-api-walkthrough?tabs=portal#retrieve-dimension-values

Look at the metric definitions and dimension values to understand which will impact carbon.

[srini1978]

For Azure SQL Managed Databases we can look at the following metrics

https://learn.microsoft.com/en-us/azure/azure-monitor/reference/supported-metrics/microsoft-sql-managedinstances-metrics

1. Average CPU percentage
2. Storage space used/Storage space reserved in percentage
3. IO bytes read+ IO bytes written