OMW message table with blocking locks on console selects


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