SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [D:\Data\af_shanghai_4.ndf] in database [af_shanghai] (7).  The OS file handle is 0x00000960.  The offset of the latest long I/O is: 0x000023101f0000
1、把偏移量0x000023101f0000转化为十进制为：150594322432
2、把该值除以8192即为page number: 150594322432/8192=18383096
3、通过page number求的table name

select object_name(object_id) as tblname,* 
from sys.partitions sp with(nolock)  
where sp.partition_id in (
select au.container_id from 
sys.dm_os_buffer_descriptors obd with(nolock)  
join sys.allocation_units au with(nolock)  
on obd.allocation_unit_id=au.allocation_unit_id
where obd.page_id=18383096)![](http://i2.51cto.com/images/blog/201805/17/efc3a108cfca93c7ab3b493919d43ffe.png?x-oss-process=image/watermark,size_16,text_QDUxQ1RP5Y2a5a6i,color_FFFFFF,t_30,g_se,x_10,y_10,shadow_20,type_ZmFuZ3poZW5naGVpdGk=)