BizTalk Server 2006 - Running Host Instance consumes 100% CPU when "Allow Host Tracking" is enabled

[Sergiy]

Hi all,
I have recently started having a strange issue with my BizTalk Server 2006
installation.

When I start a biztalk Host Instance on my computer, the CPU usage jumps to
100% and stays there
until the host instance is stopped or the BTSNTSvc.exe process is
terminated.

By checking the Processes tab in the Windows Task Manager, the BTSNTSvc.exe
memory usage
increases from approx 30,000K to 270,000K and there's constant activity
between BTSNTSvc.exe
(10% CPU usage) and sqlservr.exe (90% CPU usage) while the host instance is
running.

Please Note:
This happens even after my deployed BizTalk applications are stopped
(unenlisted, unbound - i.e. NOT bound to the host at all) and
there's NO running or suspended instances - no instances running at all and
all ports disabled.
So it cannot be my deployed orchestrations etc, the BizTalk server is doing
it on its own.

Here's what I discovered when trying to troubleshoot:

- The problem goes away when the "Allow Host Tracking" option is disabled on
the host. As soon
as I re-enable this option the BizTalk server starts doing it again.

- When I run a trace in SQL Server Profiler, the following stored procedures
are executed in a non-stop loop:
exec dtasp_CtxBegin
exec dtasp_CtxInsert
exec dtasp_CtxEnd

- The records are being written to the dta_DebugTrace table in BizTalkDTADb
database.

Has anyone else come accross a similar problem? I can't just disable "Allow
Host Tracking" to fix this problem
because I need to debug orchestrations (use HAT).

Any ideas why this is happening or how I could troubleshoot it further?

Thanks in advance.
Sergiy

[Stefan]

Hi,

The symptoms you describe seems strange.
Do you know if there are any running orchestrations that may cause
this?
Is SQL Server used for other applications?

I think that the best solution would be to re-install all the softwares
except Windows.

Did you apply all the service packs?

Best regards,
Stefan
http://www.itsconsulting.fr

Sergiy a écrit :

[Al Salazar]

Just turn on the SQL Server Agent.

Cheers!

BizTalk Utilities - Frustration free BizTalk Adapters
http://www.topxml.com/biztalkutilities

[Shaun]

I had this same problem and solved it by running the MsgBox cleanup stored proc.

*** A word of warning before running it: Microsoft and everything I have seen written about, say USE THIS WITH CAUTION and NEVER run in a LIVE/PRODUCTION environment. ***
This article by Lee Grabers is very helpful. http://blogs.msdn.com/biztalk_core_engine/archive/2005/03/09/390996.aspx

In summary:
By default, this stored proc is empty and won't do anything when you run it. You will need to follow instructions on running Msgbox_cleanup_logic.sql first, then issue the following SQL command:

use BizTalkMsgBoxDB
exec bts_CleanupMsgBox

[parin]

hi,
i am facing a same issue of BTSNTSVC.service occuping entire cpu usage as the one u face some time back.i also noticed that we have to disable the host otherwise it will keep on running and using complete cpu usage.
have u find any solution.can u tell me what could be done.
thanks and regards,
parin.

[saurabh]

hi
i had also phased the same problem,in my case biztalk was polling recieve location in sql;
i had written wrong query where all the record whose status was true but i was not updating status true to false after sending that record so biztalk was continiusly polling that record and so that the cpu usage was showing 100%;

please chake that biztalk is polling any physical location continiously just handle that i think your problem will be solved

[abby]

Also
Had you done any changes in BTNTSVCConfig file?
If Yes check that file can be parsed as XML. Copy, Rename to .xml and open
in Explorer.

Thanks,
Abhay C.