This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 77%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
I have a sql managed db and the LOG IO is hitting 100% all the time. Data IO and CPU is okay.
I have 80Vcores
You may be hitting the "log limit cap" as explained on the article. If that is the case, there is no solution for that as the article explains. You have to make an assessment prior to migrate to Azure SQL MI as the article states.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 54%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Hi Alberto, can i get the link on the article u mentioned? Also does logio affects the db performance? Or what does high logio repesents and what is the effect if it hits max?
Thank you
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
@Nelson Chikati Thank you for reaching out.
Since you mentioned 80 vCores, you are on Gen 5 hardware already.
High Log IO is usually seen when you hit the IOPS/throughput limits for the respective pricing tier.
These limits are documented here if you want to read further
If you are on General Purpose tier, increasing the size of the disk will improve IOPS significantly
You can use the below statement to increase the disk space
alter database YourDatabaseName
modify file (name='YourDatabaseName', size = 140 GB)
If you are on Business Critical pricing tier, you should increase the number of vCores to improve IOPS.
Please let us know if you have any further questions.
----------
If an answer is helpful, please click on 
or upvote 
which might help other community members reading this thread.
@KalyanChanumolu-MSFT am already on Business Critical pricing tier and on Vcores 80 which I believe is the Max. What else should I do?
@Nelson Chikati This is interesting.
Could you provide more details of the workload you are running and some screenshots of the utilization?
If you have hit the throughput limits, I am afraid SQL Managed instance is not the right solution for your use case.
@KalyanChanumolu-MSFT been trying to upload a screenshot but its failing. So I have checked my subscription, we are on business Critical tier with 80 vCores, should we move to premium?
@Nelson Chikati Business Critical is the same as Premium service tier.
There is no other SKU where you can add more than 80 vCores.
If it is possible to migrate your workload to Azure SQL Database, you should consider Hyperscale service tier
@KalyanChanumolu-MSFT , I had a chat with Microsoft engineers and they suggested upgrading to premium. It has higher IOPS than business critical
@Nelson Chikati Are you using Azure SQL Managed instance or Azure SQL Database?
Managed instance does not have a premium service tier, Azure SQL Database does.
@KalyanChanumolu-MSFT We are on Azure sql Database
You mentioned "sql managed db" in your question, hence the conversation on Managed Instance. :) My bad, I should have clarified with you.
If you are on Azure SQL Database, please go ahead with Premium Service Tier