Before we move further, have a look at my following article as we are going to use the script given in that article:
I have already provided the script to display Disk IO waits in above given article, now we will further enhance that process.
By looking at IO Stall given in above article, can’t help us much. We should have data captured for few hours or may be a few days so that we can have details like which time/day we get high number of stall, we can find pattern of IO based on the statistics we capture for few hours/days. Now question comes into the picture, how can we do it with help of script given in “Find Disk performance with sys.Dm_io_virtual_file_stats in SQL Server” article?
Well we have to enhance the script give there. Let us start our journey to capture pattern of IO.
Click here to read complete article.