First published on MSDN on Feb 08, 2019
There are multiple ways to achieve this and there are also some
storage types
you should be aware
There is a good ...
Updated Mar 14, 2019
Version 2.0
Blog Post
karlarr If you run that in master, you get the max_size for master. I don't think there is a TSQL query you can run in master that gets you the size data for each user database. You have to connect to each user database in the Azure SQL Database Server to get the information individually.
Similarly, although you can run this in master to get the max_size for an elastic pool:
SELECT TOP 1 elastic_pool_name, elastic_pool_storage_limit_mb AS ElasticPoolMaxSizeInMB
FROM sys.elastic_pool_resource_stats
ORDER BY end_time DESC
I don't think there is a TSQL query you can run in master to get the max_size for each user database in the elastic pool.
