Windows Storage Diagnostics

Image shows the process executable file name.PID shows the process id.Read (B/Sec), Write (B/Sec) and Total (B/Sec) show the average bytes per second in the last 60 seconds.I/O Priority can be Normal, Background, ...For Response Time (ms) anything below 10 ms is considered ok, over 20 ms warrants attention, over 50ms suggests a serious issue.Active Time (%) consistently over ~80% may suggests a bottleneck.Average Disk Queue Length is complicated... consistently high numbers are bad, but what constitutes a high number is influenced by many factors in the underlying storage (e.g. number of spindles, RAID level, stripe size etc)... for a single disk, a value of 2 is considered high and over 5 would be considered critical, but for a LUN with 10 spindles values would generally not be considered high until over 20.

DiskSpd

https://aka.ms/getdiskspd

diskspd (github)

CrystalDiskMark

CrystalDiskMark Download

Capacity

WinDirStat

Portable

windirstat.net

TreeSize Free

TODO

WizTree

TODO

JDiskReport

TODO

Scanner

TODO

Bibliography

https://www.sqlservercentral.com/blogs/the-fundamentals-of-storage-systems-introduction
Storage Performancehttps://www.techrepublic.com/blog/the-enterprise-cloud/use-resource-monitor-to-monitor-storage-performance/ https://www.techrepublic.com/article/use-resource-monitor-to-monitor-storage-performance/https://answers.microsoft.com/en-us/windows/forum/all/resource-monitor-disk-tab-question-on-the-right/9bc26be7-5e0b-47da-b884-481ff30ce0e5
https://www.mssqltips.com/sqlservertip/2329/how-to-identify-io-bottlenecks-in-ms-sql-server/
http://www.acnc.com/windows
https://serverfault.com/questions/344629/resource-monitor-and-how-to-spot-if-you-have-disk-i-o-problemshttps://mssqlwiki.com/sqlwiki/sql-performance/io-bottlenecks/
https://crystalmark.info/en/download/#CrystalDiskMarkhttps://en.wikipedia.org/wiki/CrystalDiskMarkhttps://www.brentozar.com/archive/2012/03/how-fast-your-san-or-how-slow/
https://en.wikipedia.org/wiki/DiskSpdhttps://github.com/microsoft/diskspd
Storage Capacityhttps://portableapps.com/apps/utilities/windirstat_portablehttps://windirstat.nethttps://www.fosshub.com/WinDirStat.htmlhttps://www.fosshub.com/Disk-Analysers.htmlhttps://www.makeuseof.com/windirstat-alternatives/
MSSQLhttps://www.mssqltips.com/sqlservertip/2329/how-to-identify-io-bottlenecks-in-ms-sql-server/https://www.mssqltips.com/sqlservertip/1039/system-monitor-perfmon-counters-for-sql-server/

Page updated

Google Sites

Report abuse