none
High IO || SQL Azure RRS feed

  • Question

  • Hello Team, 

    Currently we are on P15 tier and already reaching 4000 DTU ( which is the max ) . we wanted to understand why we are hitting high DTU so that we can fix this issue ? Also, is there any other way to increase the DTU for temporarily ? 

    As per the query performance insight, we are seeing high IO but not CPU , so what does this mean ? are we doing lot of insert and deletes at same time and that is the reason for high DTU ? 

    Please find the details below

    Any pointers are highly appreciated 


    Monday, June 17, 2019 11:04 PM

All replies

  • Hi Rock421,

    With the vCore Business Critical service tier you will have the following available in terms of IOPS (link):

    "5000 IOPS per core with 200,000 maximum IOPS"

    You are currently paying roughly $21/hour for 4000 DTUs. If you made the switch to vCore, you could achieve up to 2000,000 IOPS.

    "Gen 5 vCore Business Critical 32 @ $21.7420/hour (license included) or $4.3837/hour (~80%) 3 YEARS RESERVED WITH AZURE HYBRID BENEFIT (% SAVINGS)."

    The above would get you above 100,000 IOPS at the same price point. Migration steps can be found here.

    Please let us know if you have additional questions.

    Tuesday, June 18, 2019 11:04 PM
    Moderator
  • Thanks Mike for insights . 

    Have configured SQL analytics and have found that LOGIO is reaching 100% when my SSIS package are kicking off and doing big transactions

    In P15 , you will get 1.5 TB of log space and in VCore the maximum you will get 1 TB , so not sure switching to vcore model with  highest ( Gen 5, 80 cores, 4TB ) will help here . 

    could you please confirm 


    Wednesday, June 19, 2019 6:35 PM
  • DTU sizing is the old way and vCore is the new sizing methodology. So, if log space is important to you then stick with what you currently have provisioned. Take a look at this blog (there are a few) to understand some details about each, DTU versus vCore.

    Please let us know if you have additional questions.

    Thanks,

    Mike

    Please mark as answered the information tha has answered your question(s) so as to help others looking for the same information.

    Thursday, June 20, 2019 1:53 AM
    Moderator