Hi,

in my SQL server error log , i am seeing so many errors as below: it is showing process id 0 and no host name,

could you please help me to troubleshoot this issue.

Source spid32s

Message

Process ID 529 was killed by hostname , host process ID 0.

It shows that someone killed your process. This might happen manually, another app or SQL job. Please contact your DBA to find out who did that.

Hello,

Please examine the jobs scheduled to run by SQL Server Agent that may kill inactive processes every X period of time.

This also may be related to settings/configuration of connection pooling.

http://blogs.msdn.com/b/spike/archive/2009/04/16/a-transport-level-error-has-occurred-when-sending-the-request-to-the-server-provider-tcp-provider-error-0-an-existing-connection-was-forcibly-closed-by-the-remote-host.aspx

To properly manage connection pooling please read the following article.

http://www.pythian.com/blog/sql-server-understanding-and-controlling-connection/

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Edited by Alberto MorilloMVP, Moderator 11 hours 49 minutes ago

spid32s

Process ID 529 was killed by hostname , host process ID 0.

SPID shown in the message is system SPID and due to that hostname is blank and host process ID is zero. I am almost sure that you have some service broker mechanism in place which captured SPIDs and kills them. Its not done via a user process (i.e. SQL Agent Job, User Kill) because they would be used SPIDs.

I was able to reproduce the issue by creating a service broker queue and an activation procedure to kill the spid if there is a long blocking.

Your environment must have something similar. Profiler is your friend. You can see the Activation procedure name and then you can track the service which is responsible for this.