OMW message table with blocking locks on console selects

Hi,

I occasionally find that the OMW OV_Message table locks up. When I issue sp_who2 on the database I see blocking locks caused by console sessions running selects against the database. These blocking locks can sometimes be seen for longer than two hours. When I observe that the console is no longer updating I may need to kill the offending session.

 

I cannot rely on my manually handling this kind of scenario. I need either a way of automatically killing sessions that block lock the message table or at the very least a SQL job that can email me if such a lock exists.

 

Anybody done anything similar and have developed some similar solution?

 

This is a mission critical implementation with a high message volume and I must have a workaround.

 

Kind Regards

Graham