Hi Ryan,

Thank you for your response. But our application hold the lock for so long and our application hang.
Even the select statement from the said process also hold the lock. I don't know how my developers developed the application because it was coded in JAVA. I have already run profiler, performance monitor to check the problem but I have no solution yet.


>Hi Rene,
>
>sometimes table locking depends on the bulk of your transaction processing. usually locked tables will be released upon the completion of the said bulk processed.
>automatically killing of SPIDs are not advisable.
>
>
>>Hi All,
>>
>>My SQL Server database always suffering a process that block by other process.
>>I can check it using SP_WHO and SP_WHO2 stored procedure.
>>There are so many process ID that is idle by still block some other process that is some other process cannot execute successfully.
>>The application was developed using JAVA but I don't know JAVA. My rule in the database is a DBA.
>>I'm a new DBA since I'm a developers from my previous job but I don't know JAVA since I'm only using microsoft products.
>>
>>My question is, Is there a way to automatically kill the idle process that block other process.
>>As of now I have manually kill the process using the KILL command to allow other process to execute.
>>What I have done is to check the available process in the DB Server and determine which process causes the lock and kill it manually.
>>Our application always suffering a deadlock because of idle process that block other process.
>>We are on the process of investigating it. This is my big puzzle that needs to resolve.
>>I have already check my SQL Server and OS configuration and there is no problem on my configuration.
>>
>>Anybody can help me to resolve my problem.
>>
>>
>>Thanks,
>>
>>
>>Rene