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: 1390 | Points: 40

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