what is pending io count

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » what is pending io count

what is pending io count

Rate Topic

Display Mode

Topic Options

Author

Message

Balance

Posted Sunday, February 03, 2013 1:21 PM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, May 13, 2013 5:45 AM
Points: 462, Visits: 643

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

Post #1415054

Richard Fryar

Posted Monday, February 04, 2013 6:48 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, May 20, 2013 6:18 AM
Points: 242, Visits: 882

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'

FREE DOWNLOAD
www.sqlcopilot.com

Post #1415273

Balance

Posted Monday, February 04, 2013 7:40 AM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, May 13, 2013 5:45 AM
Points: 462, Visits: 643

thanks

Post #1415300

« Prev Topic | Next Topic »

Permissions