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

Hi Scott,

Thanks again. You were right, the sql script needed to be run to install the
sproc!
This has solved the issue so thanks very much.

Just a question regarding the sproc though, it is mentioned in a couple of
places that you would never run this in production due to it deleting all
live data. What are the alternatives when this occurrs in production? Do
you need to let BizTalk and SQL catch up with all the work they are trying
to perform?

Thanks very much

Sergiy

"Scott Colestock" <scolestock@xxxxxxxxxxxxxxxx> wrote in message
news:023e01c7081d$9fa1e6d0$340b280a@xxxxxxxxxxxxxxxxxx
What does your spool size look like? (Check via the message box perf
counters)
Also, make sure that the stored procedure has "real" implementation in
it - in biztalk 2004, you had run a .sql script in the sdk to get
anything more than a stub implementation.

Scott Colestock
www.traceofthought.net


-----Original Message-----
From: Sergiy [mailto:bryn@xxxxxxxxxxxxxxxxxx]
Posted At: Monday, November 13, 2006 5:38 PM
Posted To: microsoft.public.biztalk.general
Conversation: BizTalk Server 2006 - Running Host Instance consumes 100%
CPU when "Allow Host Tracking" is enabled
Subject: Re: BizTalk Server 2006 - Running Host Instance consumes 100%
CPU when "Allow Host Tracking" is enabled

Hi Scott,

Thanks for the response. I have tried running that stored procedure
(with
the 1 param). It only took less than a second to run, which indicates to
me
that not many records were in the database. I have tried starting the
host
again after this, and exactly the same issue arises.

Also, I'm pretty sure it is BizTalk initiating all the SQL activity.
It's
only when ANY BizTalk host that has tracking enabled is started that SQL

goes from minimal activity to 100% CPU.

I think this indicates that it is not one of the BTS SQL jobs. To check
this, I also stopped the SQL Agent.

Any more thoughts?

Thanks,

Sergiy

"Scott Colestock" <scolestock@xxxxxxxxxxxxxxxx> wrote in message
news:011401c70772$9e839c40$340b280a@xxxxxxxxxxxxxxxxxx
It sounds like you have (for some reason) a large number of items in
your MessageBox database that need to be moved to the tracking
database.
You might want to look at the bts_CleanupMsgbox stored procedure -
See

http://www.traceofthought.net/PermaLink,guid,4490e98e-049a-4c3c-8cb3-538
0f295f61c.aspx for more detail.

Scott Colestock
www.traceofthought.net


-----Original Message-----
From: Sergiy [mailto:bryn@xxxxxxxxxxxxxxxxxx]
Posted At: Sunday, November 12, 2006 7:43 PM
Posted To: microsoft.public.biztalk.general
Conversation: BizTalk Server 2006 - Running Host Instance consumes
100%
CPU when "Allow Host Tracking" is enabled
Subject: BizTalk Server 2006 - Running Host Instance consumes 100% CPU
when "Allow Host Tracking" is enabled

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









.

Relevant Pages