I am trying to save some money by utilizing Azure SQL Elastic Pools. I have a bunch of databases which only peak in usage once a while, so having them in a pool would be optimal. The problem now is that all the databases combined need about 1 TB of storage, which I only get by selecting the standard service tier and selecting 300 DTUs. After trying out some things I noticed that even though the size of the elastic pool is capped to a value (e.g. 500GB with 50 DTUs Standard), I can increase the size of an included database to above the cap (e.g. 750GB, even though the pool size is only 500GB).
My questions now are:
What exactly happens if I increase the database size over the pool size? Am I going to get billed for extra GB as soon as I go over the max pool size?
More a side question, but is there another option to increase the storage size without raising the DTUs so much? I would need maybe like 100 DTUs with 1TB of storage. I looked into the vCPU pricing options, but they seem even worse pricing wise.