Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 After event OS doesn't work

Author  Topic 

csc
Starting Member

1 Post

Posted - 2009-06-01 : 00:12:38
hi,

2009-05-19 10:22:04.99 spid1 SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15
2009-05-19 10:22:04.99 spid1 SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15
2009-05-19 10:26:43.29 spid56 Waiting for type 0x2, current count 0x100022, current owning EC 0x3A68B568.
2009-05-19 10:26:43.29 spid56 Time out occurred while waiting for buffer latch type 2,bp 0x1f0bdc0, page 3:29
2009-05-19 10:26:45.25 spid71 Waiting for type 0x2, current count 0x22, current owning EC 0x24F71550.
2009-05-19 10:26:45.25 spid71 Time out occurred while waiting for buffer latch type 2,bp 0x1fbf680, page 1:55
2009-05-19 10:26:46.68 spid62 Waiting for type 0x2, current count 0x100022, current owning EC 0x21F7D550.
2009-05-19 10:26:46.68 spid62 Time out occurred while waiting for buffer latch type 2,bp 0x1fbce00, page 3:82
2009-05-19 10:26:48.56 spid60 Waiting for type 0x2, current count 0x100022, current owning EC 0x24605560.
2009-05-19 10:26:48.56 spid60 Time out occurred while waiting for buffer latch type 2,bp 0x1fa89c0, page 3:79

it appears in the log of the SQl Server. After that the system hangs and only helps to hard reset.
Please if anybody know about this problem say a solution
thnx.

Microsoft SQL Server 2000 - 8.00.2187 (Intel X86) Mar 9 2006 11:38:51 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-04 : 05:20:00
Are all your databases online?
It seems some IO request takes a very long time to complete.


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -