by nobob » Wed, 05 Dec 2001 22:13:57
The above mentioned error ocur since we have a high performance SAN attachet
to our database. The error will rise every night in the moment our
SQL-Server 7 make a full dump and concurrent a client try to make some
transaktions.
We gues that the Server do not have enougth time (because of the dump) to
handle the client request.
Does someone have seen this problem befor (and have a idea for a
workaround)?
thank you
by Neil Pik » Thu, 06 Dec 2001 03:18:56
845 17 Time out occurred while waiting for buffer latch type %d for page
%S_PGID, database ID %d, object ID %d, index ID %d."
Do you have SP3 applied to SQL 7 already? Your best bet would be to call this
in to MS PSS as it can't really be debugged via newsgroup support.
MS will probably need a stack dump to see what is going on - see the
traceflagy FAQ entry for how to get one.
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq
3. Isolating 845 errors with SQL7 sp2
4. Help! Can run Sybase 6.0x and 10/11 on same box?
5. DBACCES-Error 801/845 on Informix 7.20 / HP-UX 10
6. ORA-06502: PL/SQL: numeric or value error
7. 614 error on a user database and 806 error on tempdb seen in the error log
9. Error 22030: A MAPI error (error number: 271) occurred
10. Generate an error to an error log on a stored procedure error
11. DTS Error-2147217887 (80040E21) Error string: Errors occurred
12. Error 22030: AMAPI error (error number: 16389) occured
13. UGRGENT: VB4 DAO - Error 31037 Error Loading from File DAO Error 3251