Share via

Data I/O Percentage Max - Azure Sql Database

M, Murugeswari (Cognizant) 456 Reputation points
2022-01-28T08:02:45.747+00:00

Hi,

In my current production Azure SQL Database, Data I/O Percentage is becoming high (100%). Is there any way to improve this

169333-image.png

Azure SQL Database
0 comments
Accepted answer
  1. Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
    2022-01-28T14:34:25.64+00:00

    Please go to Query Performance Insight on the left vertical panel of your Azure SQL Database, then identify and optimize top ofending queries.

    169443-image.png

    Make a click on the buttons inside the red square on below image.

    169426-image.png

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. M, Murugeswari (Cognizant) 456 Reputation points
    2022-01-31T05:29:22.927+00:00

    Thanks Alberto, I have identified offending queries. Will try to optimize

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.