833
Product Name Event ID 833 Event Source MSSQLSERVER Component SQLEngine Symbolic Name BUF_LONG_IO Mes
Product
Name
Event ID
833
Event Source
MSSQLSERVER
Component
SQLEngine
Symbolic
Name
BUF_LONG_IO
Message
Text
has encountered %d occurrence(s) of I/O requests taking longer than %d
seconds to complete on file [%ls] in database. The OS file handle is 0x%p. The
offset of the latest long I/O is: %#016I64x.
This message indicates that SQL Server has issued a read or write request from disk, and that
the request has taken longer than 15 seconds to return. The SQL Server reports this error and
indicates a problem with the I/O subsystem. A database management system (DBMS), such as
, relies on the timeliness of file input and output (I/O) operations. Any one of the
following items may cause stuck or stalled I/O operations and adversely affect SQL Server
responsiveness and performance:
Faulty hardware
Incorrectly configured hardware
Firmware settings
Filter drivers
Compression
Bugs
Other conditions in the I/O path
ノ
Expand table
[%ls] (%d)