I'm using Azure's metrics chart to see if it's feasible to merge two databases into one Pool. The two databases are currently in tier S3.
The first chart is the result with "DTU Used" metric using MAX() aggregation function in the last 30 days. It can be observed that during several intervals the "DTU Used" reached close to 100.
The second is the result with "DTU Used" metric using SUM () aggregation function. The period is the same of the first chart.
I found it strange because observing the second chart it seems that there have never been such peaks of use close to 100. Even the sum of "DTU Used" of the two bases seems to never have reached 40.
I'm a bit confused by the graphics interpretation, should I trust the second, where it seems feasible to join theses two databases in one 100 eDTU Pool?
And what would be the best way to set Azure SQL Database metrics chart to do this analysis?