I/O Consumption at 100% after the new release

Rishi Parpyani 0 Reputation points
2024-08-21T02:36:06.7066667+00:00

we recently released a software update where we released a couple of log tables and other things. after the release , the I/O consumption reached at 100% . the perfomance of the website has gone down drastically . there are a lot of read write operation happening but the I/O time has increased drastically sometimes causing transport level error.

we did some inspection in temp db where we rolled back log trigger. the log tables have been there for a couple of months now but we thought could be an issue since ever write operation is at 2x.

any idea how to go about inspection I/O percentage?

Azure SQL Database

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.