SYMPTOMS
The SQL Server errorlog file may contain one or more of the following
errors if there is stress on the SQL Server lock limit threshold:
Error : 1204, Severity: 19, State: 3
SQL Server has run out of LOCKS. Re-run your command when there are
fewer active users, or ask your System Administrator to reconfigure SQL
Server with more LOCKS.
Error : 5904, Severity: 17, State: 0
Background checkpoint process suspended until locks are available.
Continued stress may cause one or more of the following errors:
bufwait: timeout, BUF_IO, bp 0xee55e0, pg 0x26f7, stat 0x1004/0x6, obj
0x8, bpss 0xfa31f0
udread: Operating system error 6(The handle is invalid.) on device
'C:\MSSQL\DATA\devTempdb.DAT' (virtpage 0x020022f7).
EXCEPTION_ACCESS_VIOLATION raised, attempting to create symptom dump
WARNING: Pss found with open sdes; pspid 11, psuid 1, pcurdb 1, system
table entry 0, sdesp 0xf51ba0, objid 1
Error : 826, Severity: 20, State: 1
Attempt made to hold allocation page 11520 that is
Error : 602, Severity: 21, State: 3
Could not find row in Sysindexes for dbid '2', object '16003088',index
'0'. Run DBCC CHECKTABLE on Sysindexes.
Error : 913, Severity: 22, State: 2
Could not find row in Sysdatabases with database id -27352. Run DBCC
CHECKTABLE on Sysdatabases.