Re: Templog.ldf growth on MessageBox..

Can you confirm that all of your BizTalk SQL Agent jobs are running
successfully? Do you have a Host flagged as the Tracking Host with a
Host Instance that is running?

Regards, Nick.

On 1 Apr, 18:41, KriS <K...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hello,

Recently we had an issue where our BizTalk installation stopped due to no
free disk space on MessageBox. Issue turned out to be templog.ldf file was
taking up almost all the space which we allocated for our MessageBox.

Did a shrink on the log file and it immediately freed around 60 GB worth of
space. BizTalk started and life seems to be ok, but in a day the same
templog.ldf file grew from around 1000 KB to 2GB. I think the same issue is
more than likely going to happen in the next 15 days or so..

Ran SQL profiler to figure out what was causing this growth but I am unable
to find any thing.

All the BizTalk jobs seem to be happy, the load is minimal on the BizTalk
application servers. The only other thing which I noticed was that the memory
being used on the messageBox servers was more than 4GB (we have a total of
4GB RAM) not sure if this would cause any issues.

Environment:
BizTalk 2006 Enterprise edition.
Windows 2003
Active Passive MessageBox cluster on SQL server 2000.
Two BizTalk app servers connected to the messageBox cluster.

Could someone please point me in the right direction on where to go from here?

Any help would be greatly appreciated!

Thanks in Advance

.

Relevant Pages

  • RE: Very odd behaviour of our receivehost (bts2006 R2)
    ... I know biztalk heavily relies on AD... ... It's not the isolated receive host, it's the 'normal' receive host that is ... receivehost after that and still this sometimes doesn't help, ... It's my impression that the adapters I installed (AX2009 biztalk adapter ...
    (microsoft.public.biztalk.general)
  • RE: BizTalk Server 2006 - Running Host Instance consumes 100% CPU when "Allow Host Tracking" is
    ... When I start a biztalk Host Instance on my computer, the CPU usage jumps to ... So it cannot be my deployed orchestrations etc, the BizTalk server is doing ...
    (microsoft.public.biztalk.server)
  • Re: Adapter Error on non-default host
    ... When your issue originally came up, did things work okay on the default host for the BizTalk group but not on other hosts in the group, or did it fail in all cases? ... since my issue only pops up when the adapter is associated with the non-default host. ... Well when I looked at the SoapreturnMsg I found that a second xml declaration was being added to the msg. ...
    (microsoft.public.biztalk.general)
  • RE: Health activity tracking tool timing out
    ... SQL scheduled jobs by BizTalk installation are up and running. ... deletion and moving messages from MessageBox towards DTADB. ...
    (microsoft.public.biztalk.general)
  • Re: Changing Biztalk Sevice Login Accounts
    ... You'll want to change the identity on the host instances, ... sure it is in IIS_WPG group and that for web services it has rights to the ... > I'm a Biztalk newbie, I installed a two server simple Biztalk setup ... > logins during the installation as the authenticating login. ...
    (microsoft.public.biztalk.general)