What is the purpose of sys.dm_io_pending_io_requests?

 Posted by Niladri.Biswas on 7/26/2012 | Category: Sql Server Interview questions | Views: 1471 | Points: 40
Answer:

This DMV will return the I/O requests pending in SQL Server side. It provides the below information
a)Io_type: Type of pending I/O request
b)Io_pending: Indicates whether the I/O request is pending or has been completed by Windows
c)Scheduler_address: Scheduler on which this I/O request was issued


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response