How can I determine where my Windows Server 2012 is using Random or Sequential I/O operations when writing/reading the local SSD storage?
I have been asked to provide details to our hardware vendor on server usage in order to performance tune the server. They want to know if we are using Random or Sequential. The servers are running SQL Server 2012. I would like to be able to compile some stats and/or logs that show the various I/O operations to determine whether we are using random or sequential I/O and how much of each and when. I imagine this could be accomplished through some Performance Monitor counters or some other type of trace events. I hope this explains the situation better.