I have an Azure sql server , configured at DTU 200 and Data Max Size 250G.
Now i dont have much traffic on the database cause there arent many customers that use it.
To prove that , i want to get the amount of traffic that hits the database and reducing the dtu to an appropriate value.

I have looked at Metrics and DTU Percentage , its been between 0.8 -1%

How can i check what the Max load on the database would have been at any one time in order to decide which dtu to give the database?