As a DBA we need to investigate the SQL errors from the error log. if you need info on finding your errorlog file location you can refer this article.
The below are some of the common sql server errors i have seen, may be this can help you to get some insights into this errors.
Error: 18210, Severity: 16, State: 1.
Causes: Backup device
not accessible or SQL Backup process expecting a reply, but could not get
reply.
Observation: This can be a message when your third party backup software is not sending the info needed by SQL server to say that backup was successful. This error is random, so needs investigation from third party backup tools and logs to check the status of backup.
Error: 1205
Causes: Deadlock and victim has been killed.
Observation: Source: Locking, Blocking and
transactions open
Error: A time-out occurred while waiting for buffer
latch -- type 4
Causes:
·
You enable the row
versioning feature on a database in SQL Server 2008 R2 or in SQL Server 2008.
·
You configure the
database to use the snapshot isolation level.
·
You run many
transactions that update the database concurrently.
Observation:
essage:A time-out occurred while
waiting for buffer latch -- type 4, bp 00000000E5FD39C0, page 1:90809119, stat
0xc0000b, database id: 7, allocation unit Id: 72057594492944384, task 0x0000000004FB9708
: 0, waittime 300, flags 0x1038, owning task 0x0000000000000000. Not continuing
to wait.
Error: 18456, Severity: 14, State: 38.
Causes: Login failed due to wrong access issues
Observation: Usually observed when login is trying to access Database or perform action on restricted database.
