Hi to all,
Just moving over to a new firm I was asked to find out the reason why most of the clustered servers where prompting "SEMAPHORE TIMEOUT" every now and than so I digged in.
This message occurs when using all kinds of I/O to the subsystem (which resides on the SAN).
The exact error message is;
Executed as user: . TCP Provider: The semaphore timeout period has expired. [SQLSTATE 08S01]
(Error 121) Communication link failure [SQLSTATE 08S01] (Error 121). The step failed.
Hardly any info is to be found in the Internet so I need your help guys!!
As far as I found out this is an OS error which is written in the SQL server 2005 logs just before losing contact with one of the parts of the subsystems. This can be Hardware response timeout or an Autodetect setting on cluster network interface card. Others say this could be a Memory issue on windows 2003 SP1 cluster node with sql 2005 Ent. 64 bits SP1 or this is a bug/failure to properly release the cached memory. . . . .
Who delt with this issue before and /or can help me out on this?