• 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