What are in "Other Wait" when looking at Storage I/O performance monitor?
I see it has huge portion of the storage wait time. Pic is attached.
This is for SQL Server DB. Thanks.
non-storage waits. I.e. You may not be storage hamstrung
Is it possible to list out those other wait codes?
Yes and no... The Storage I/O feature presents them as storage-wait vs non-storage-wait. You will see the detailed wait types in the Trends section. For example, in SQL Server, PAGEIOLATCH_XX and WRITELOG are the most common storage wait types. However the Trends section doesn't group them by I/O and non-I/O. The descriptions in the wait types will help you identify what is a storage wait.