cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 11

I/O Write Stalls versus I/O Wait by File (Write Tab)

Jump to solution

The MS SQL Tips article below talks about "I/O Stalls" in investigating I/O bottlenecks. In DPA Write performance by file there
is also a bar graph Total Wait and I/O Wait By File. Are I/O Wait Stalls the same as the I/O Wait represented in that graph?

 

https://www.mssqltips.com/sqlservertutorial/254/investigating-io-bottlenecks/

 
 

 

 

 

0 Kudos
1 Solution
Level 17

@MediThwack 

Yes, I consider the terms to be synonymous. DPA is using information from sys.dm_io_virtual_file_stats to display the data, just as Greg mentions in the article. HTH

View solution in original post

1 Reply
Level 17

@MediThwack 

Yes, I consider the terms to be synonymous. DPA is using information from sys.dm_io_virtual_file_stats to display the data, just as Greg mentions in the article. HTH

View solution in original post