Post reply

Digging into the Buffer I/O Wait Category

  • May 14, 2014 at 7:50 am

    #307309

    Hello,

    I can't seem to find much information on what the Buffer I/O wait category that you see in the SSMS activity monitor covers. From what I've been able to piece together, it seems to be aggregating some numbers from sys.dm_os_wait_stats, but I'm not sure which waits are used. Could somebody point me to a resource that would help?

    Thanks!

    Jim

  • May 14, 2014 at 8:07 am

    #1713482

    It's absolutely using sys.dm_os_waits_stats. But if you want to know which query, just run extended events/trace to capture it.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • May 14, 2014 at 9:12 am

    #1713518

    Thanks!

    Jim

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply