Hi,

The company i'm working for is considering to use an elastic database pool. When we tried to compare the pricing we saw a formula that isn't clear to us. The formula:

MAX(Total number of DBs * average DTU utilization per DB, number of concurrently peaking DBs * Peak DTU utilization per DB).

How do we get the "average DTU utilization per DB"? And how do we find the "Peak DTU utilization per DB"?

Any help or examples are welcome!

• Edited by Anthony-tje Monday, September 07, 2015 1:05 PM

Anthony,

    You can get the DTU utilization of a database by using the DMV sys.dm_db_resource_stats. This DMV provides average resource usage at 15 second intervals for the last one hour. You can keep querying this DMV at periodic intervals to get this data to get longer term averages and any peak usage over that period. Elastic pool guidance article at Azure.com also provides a powershell script that you can setup and execute to get the DTU calculation for the pool. 

Azure portal also provides a DTU utilization chart for your database for customizable intervals. Granularity of the data in that chart is lower, so you may not be able to get the average and peak utilization data as accurate as querying the DMV.

-- srini