BizTalk Server General - BizTalk DTA database is growing at 1G a day with only 1 orchestration!?

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > April 2005 > BizTalk DTA database is growing at 1G a day with only 1 orchestration!?





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author BizTalk DTA database is growing at 1G a day with only 1 orchestration!?
Jake

2005-04-27, 5:52 pm

I have a single business process running in production. It takes incoming
messages (from a database), processes and translates them and sends the
message contents out. The incoming messages usually contain several
records that each get sent back out to their final destination (a different
database).

The process appears to run flawlessly, but it produces a ton of tracking
data. I have setup the BizTalk SDK stored procedure that purges data from
the tracking database and configured it to run each night, keeping only 7
days worth of data. However, each day we add about 1G of tacking data.
Why? What is in there?

HAT is timing out when I try to get a count of messages for a day. Is
there some other way for me to do this?

What will happen if I just turn off tracking for the host the process is
running in?

What is going to happen when the next three processes go in to production?


--
Jake Watkins
jakew - guerillaprogrammer.com
MCSD - .NET, Web-services, BizTalk, BPM
469-855-5919
Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com