December 12, 2003 at 7:46 am
Can some one tell me more about this error:
Time out occurred while waiting for buffer latch type 3,bp 0x12db240, page 1:467864), stat 0x400f, object ID 2:-390356597:0, EC 0x6456F568 : 0, waittime 96000. Continuing to wait.
I have frequently this kind of T.O.'s on several Qry's
especialy Qry's with inserts.
December 12, 2003 at 8:30 am
Your problem may be less than optimally designed tables or queries. (perhaps index or trigger related) but there is also a good chance this is related to insufficient hardware. Check out http://support.microsoft.com/default.aspx?scid=kb;en-us;310834&Product=sql for some ideas. If you are unfamiliar with using Performance Monitor to check out possible hardware related bottlenecks see the Performance Monitor sections of http://www.sql-server-performance.com/
Francis
December 14, 2003 at 9:51 pm
December 14, 2003 at 9:51 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply