We are running 2 sql server 2017 over windows server 2016. All of a sudden the disk active time becomes 100% and query executions become slow. After sometimes it becomes normal and functioning correctly.
We are also having a 3rd vm running with windows server 2016 on the same storage. When the...