Hi Paul,
I am facing the same issue:
Error: 845, Severity: 17, State: 1
Time-out occurred while waiting for buffer latch type 4 for page (1:407399), database ID 7.
I get this in eventvwr, the time stamp is same as finish time of Reindex job, also we are running the Veritas backup(os backup) on this.
Environment:
VMWare
OS:Windows 2003 sp2
Sql: MSSqlServer 2000 3a Standard Edtion
impact: sql server is non responsive, only reboot is solving issue.
Observation:
1. will it solve if we upgrade to Sql server SP4
2. is this happening due to Veritas is using heavy IO and causing sql to nonresponsive.
3. Any other issue?
*How to prove that:-)
Please help , its critical for us.
Appriciate you help.
Thanx.
Vinay
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay