Post reply

what is pending io count

  • February 3, 2013 at 1:21 pm

    #394093

    Is someone able to explain what pending_io_count is in sys.dm_os_tasks please. The description on bol suggests it is io done but the name suggests otherwise, before I draw my own conclusions (io done seems to fit my machine) I thought I would ask for a 2nd opinion.

    Thanks

  • February 4, 2013 at 6:48 am

    #1583929

    If you run

    select r.session_id, r.status, r.command, t.pending_io_count

    from sys.dm_exec_requests r

    join sys.dm_os_tasks t on r.task_address = t.task_address

    order by 1 desc

    you should see that pending_io_count for currently running user requests will be low, while for some system requests it will be very high. I think that confirms the BOL description.

    If you want to see pending i/os have a look at sys.dm_io_pending_io_rquests and filter on io_type = 'disk'


    Check Your SQL Servers Quickly and Easily
    www.sqlcopilot.com

  • February 4, 2013 at 7:40 am

    #1583951

    thanks

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

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