SQL statement to query the current database IO waiting status

Time:2021-4-2

sys.dm_ io_ pending_ io_ Requests can return the Current IO pending status. For each pending I / O request in SQL server, a corresponding line is returned, followed by sys.dm_ io_ virtual_ file_ With stats, you can see which database IO has problems.


select DB_NAME(database_id) as DBNAME,
    database_id,
    file_id,
    io_stall,
    io_pending_ms_ticks,
    scheduler_address
from sys.dm_io_virtual_file_stats(null,null)i ,
sys.dm_io_pending_io_requests s
where s.io_handle = i.file_handle

Recommended Today

Talk about uiscrollview

First, before we talk about uiscrollview, let’s first understand how coordinate systems work in UIKit. Coordinate system Because everyviewDefines its own coordinate system, which looks like this: the X axis points to the right and the Y axis points down (as shown in the following figure). Logical coordinate system png However, it should be noted […]