Re: Error 845 running backup of one database
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/23/04
- Next message: Tibor Karaszi: "Re: Log Shipping"
- Previous message: Tibor Karaszi: "Re: How to extract only the time or date from datetime"
- In reply to: Connie: "Error 845 running backup of one database"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 23 Jun 2004 18:56:56 +0200
Did you see the specific recommendations in Books Online for this?
Error 845
Severity Level 17
Message Text
Time-out occurred while waiting for buffer latch type %d for page %S_PGID, database ID %d.
Explanation
When under a heavy stress load or high I/O conditions, your system may produce this message.
Action
This message can usually be ignored; however, if you receive repeated messages where the wait time
increases, it may indicate an internal server problem. Contact your system administrator. The system
administrator should check the waittype, waittime, lastwaittype, and the waitresource columns of
sysprocesses to see what activities each SPIDs is performing.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Connie" <cfelt@ga.wa.gov> wrote in message news:OcwIz0TWEHA.1144@TK2MSFTNGP10.phx.gbl... > I have one database that I keep getting an error 845: Time out ocurred while > waiting for buffer latch type 3 for page (0:0), database ID 15, object ID > 569352192, Index ID 0.. > This only started happening last week. The database has not changed (other > than normal data entry) in over a year. Does anyone have any ideas of what > should be checked? > > Thanks in advance > >
- Next message: Tibor Karaszi: "Re: Log Shipping"
- Previous message: Tibor Karaszi: "Re: How to extract only the time or date from datetime"
- In reply to: Connie: "Error 845 running backup of one database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
