SQL Server Notes

Support notes

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.