Support notes that I have used, or found to be useful.
| DocID | Abstract |
|---|---|
| 308518 | Refresh of Current Activity in SEM May Cause “Error 1222: Lock Request time out period exceeded” Error Message |
| 309256 | How to troubleshoot SQL Server error 8645, “A time out occurred while waiting for memory resources to execute the query” |
| 316749 | There may not be enough virtual memory when you have a large number of databases in SQL Server |
| 906344 | The blocked column in the sysprocesses table is populated for latch waits after you install SQL Server 2000 SP4. You will notice this in sp_who2 as the BlkBy value being identical to SPID. These are not true blocking locks. |
| 919710 | Error message when you try to connect to an instance of SQL Server 2005: “No process is on the other end of the pipe” or “An existing connection was forcibly closed by the remote host” This describes a problem whereby an invalid certificate prevents database connection. |