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