BizTalk 2004 host dequeueing problem

 Hi guys,

Could anybody give me an advice in the next situation please?

After power failure which affected Biztalk(2004) and SQL (2000) Servers multiple locks on BiztalkMsgBoxDB were found by DBA.

My findings:

1.       Most of the locks belong to the object (Lock/Object in Enterprise Manager) BiztalkMsgBoxDB.dbo. BiztalkAppSendQ (host dedicated to sending operations through Covast EDI Accelerator although I don’t think it is relevant to the problem). The number of locks for this object  is about 40000. Most of them have bts_DeQueueMessages_ BiztalkAppSendQ as a last operation.

2.       The table BiztalkAppSendQ has approx 140000 rows.

3.       SQL sysprocesses table has about 80 rows but no rows with blocked>0.

4.       BizTalk server CPU utilization – 53%.

5.       HAT – small reasonable number of dehydrated service instances and circa 500 ‘consumed’ message instances.

6.       All Biztalk jobs are executing successfully.

It seems there is a problem with dequeueing messages from BiztalkAppSend. It is relatively long lasting problem so I can't rely on Biztalk itself. How to resolve it?

I am planning now a service window for SQL Server service restarting. What do you think if it is worth to do and it is enough?

Any ideas will be appreciated.

 Hi

Interested to hear how you got on with this.  I think id probably look for host and SQL Restarts like you suggested depending on your ability to arrange a time to do this.

It might also be worth running messagebox viewer against your setup.  Check out the SBUG blog for info on the session we did the other day about this it was recorded on live meeting.  JP mentioned that messagebox viewer supports BTS 2004.

HTh

Mike

 Hi,

Our DBA rebooted Biztalk and SQL Server but the locks have survived!!! And they started to affect other applications working with DBs although it seems that BizTalk is working well. I will try to use messagebox viewer tonight but actually I am running out of ideas what to do with SQL server.

Thanks

W.

Hura! It was a pleasure to try those 2 tools: MBV + Terminator.

2 problems were identified by MBV and Terminator successfully processed them.

Thanks Mike.

Hi

Ive sent your thanks on to jean-pierre

Its good to see it does a great job on bts 2004 also