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.
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.
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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.