昨天单位服务器报错，不知道是什么意思，请各位大哥 指教 ！！！ Time out occurred while waiting for buffer latch type 3, bp 0x18ed4240, page 1:1), stat 0xb, object ID 2:99:0, EC 0x57837998 : 0, waittime 300. Continuing to wait.
可能是内存读写出错. 重启动SQL. 重启动机器,重启动SQL.
On very rare occasions, you may get an error similar to this from SQL Server: [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 845: [Microsoft][ODBC SQL Server Driver][SQL Server]Time-out occurred while waiting for buffer latch type 3 for page (2:0), database ID 15. This error message may also be accompanied by additional error messages, such as a file log or database backup that failed. This error indicates that your disk I/O system is being overloaded and that SQL Server timed out when trying to write data to disk (via the OS). If this error is a rare event, then there is no need to worry. But if this event becomes frequent, it could mean that your disk I/O subsystem has hit a bottleneck that it can't overcome, or that your disk I/O subsystem itself is having problems. You need to find out which one of these is the most likely issue, and then deal with it accordingly. One of the things that you might want to look for is what I/O activity was happening at the time of the error. For example, it is possible that a disk backup, a DBCC command, or other database activity was all happening at the same time, overwhelming the disk I/O. Perhaps the solution to the problem is as simple as rescheduling some scheduled tasks.
to :happydreamer(重返csdn) 有没有中文的?