RE: Health activity tracking tool timing out



Hi,

I would be checking following:
1. Do you have any TrackingHost enabled. At least one BizTalk HostInstance
should be enabled to act as a Tracking Host. This helps in flagging messages
from MessageBox as being consumed and ready for eviction.
2. SQL scheduled jobs by BizTalk installation are up and running. There
are several jobs that should be running every minute. Those are essential for
deletion and moving messages from MessageBox towards DTADB.

To me it seems that your MessageBox is hevily impacted.
--

Ivan Jocic
blog: http://biztalkia.com/blogs/IvanJo


"biztalk2006" wrote:

when I open HAT in biztalk 2006 , and select find message or any queries,
they are timing out. BiztalkDTADB is not huge . it is about 1GB in size. I
tried a hot fix . I think the article number is 983380. it did not get
installed properly because I looked at the sql in the patch and that index
included in the sql is not installed. In the eventviewer, it is complaining
about not finding a project template for Visual studio .
What are the alternative ways of opening HAT? I donot know how my solution
is performing. BiztalkMsgboxdb is also about 1 .5 GB . Please advise.
Thanks
.



Relevant Pages

  • Re: Biztalk basics...
    ... that if you are setting up with BAM then the biztalk user (and i think the ... Biztalk users do need access to the SQL box. ... According to the installation guide, I need not create any user accounts ... confused on adapters was because, in receive location and send ports, we ...
    (microsoft.public.biztalk.general)
  • Re: How To use BizTalk Server Synchronous Calls - Pls help
    ... We have separate platform for BizTalk Server, ... orchestraton communicates web services, and executes process steps. ... Orchestration communicates web services. ... When you receive the intial request the pipeline publishes to the messagebox ...
    (microsoft.public.biztalk.general)
  • Re: BizTalk and SQL on different machine?
    ... When installing BizTalk and SQL on the same machine, ... While you can do this without using domain accounts, ... See the installation guide, it outlines this in explicity detail. ...
    (microsoft.public.biztalk.general)
  • RE: Health activity tracking tool timing out
    ... At least one BizTalk HostInstance ... SQL scheduled jobs by BizTalk installation are up and running. ... deletion and moving messages from MessageBox towards DTADB. ...
    (microsoft.public.biztalk.general)
  • Re: Templog.ldf growth on MessageBox..
    ... Do you have a Host flagged as the Tracking Host with a ... Recently we had an issue where our BizTalk installation stopped due to no ... taking up almost all the space which we allocated for our MessageBox. ... Ran SQL profiler to figure out what was causing this growth but I am unable ...
    (microsoft.public.biztalk.server)