Azure SQL Database – P11 and P4 utilization

Published on Author admin1 Comment

Today I ran this t-sql scripts to found out what utilization has P11 and P4 performance level of Azure SQL Database:

I like a whole picture so I ran given queries also on P1, P2 a P6 and here is a result:

  • P1 (125DTU) – 1 core, 5,9 Gb ram, 500 GB hdd – 393 eur/month
  • P2 (250DTU) – 2 cores, 11,9 Gb ram, 500 GB hdd – 785 eur/month
  • P4 (500DTU)– 3 cores, 17 Gb ram, 500 GB hdd – 1569 eur/month
  • P6 (1000DTU)– 6 cores, 33,8 GB ram, 500 GB hdd – 3128 eur/month
  • P11 (1750DTU)– 8 cores, 43,5 GB ram, 1000 GB hdd – 5904 eur/month

 

If I look on the performance tier and pricing I see that DTU is not only about cores, ram and hdd, because for example P3 is not double of P2  compared to DTUs.

 

Thanks,

Tomo

One Response to Azure SQL Database – P11 and P4 utilization

Leave a Reply

Your email address will not be published. Required fields are marked *