We have problem with large amount of data in trackin database. Following
tables have no primary keys or unique indexes. Why?

dta_MessageInOutEvents
Tracking_Parts1
Tracking_Parts2
dbo.Tracking_Fragments1
dbo.Tracking_Fragments2
dbo.Tracking_Spool1
dbo.Tracking_Spool2

We copy all messagebodies to the trackingdatabase and when searchin theese
tables. We now have problems with long running queries towards theese tables
when searching messages.

Regards
Kristian

[ Post a follow-up to this message ]

It does not have any indexes by design. This is to avoid slowing down the
inserts.
For BizTalk 2004, we are about to ship the Archiving and Purgind QFE that
will help you to maintain
size for these tables.
The feature has already been shipped as a part of BizTalk 2006.

[ Post a follow-up to this message ]

Do you have any date for qfe on 2004? We heard about this last year but hav
not seen anything yet

Kristian

"Vishal Chowdhary" wrote:

> It does not have any indexes by design. This is to avoid slowing down the
> inserts.
> For BizTalk 2004, we are about to ship the Archiving and Purgind QFE that
> will help you to maintain
> size for these tables.
> The feature has already been shipped as a part of BizTalk 2006.
>
>
>
>

[ Post a follow-up to this message ]

Hi,

There is already a QFE for purging this database, you archive the current
database and purge it. However I'm keen to get my hands on the new QFE, as
it was requested for 2004 long ago, we received the purging QFE as a short
term fix.

Paul Somers

"Vishal Chowdhary" <vishal.online@microsoft.com> wrote in message
news:sYtMx5CVGHA.5252@TK2MSFTNGXA01.phx.gbl...
> It does not have any indexes by design. This is to avoid slowing down the
> inserts.
> For BizTalk 2004, we are about to ship the Archiving and Purgind QFE that
> will help you to maintain
> size for these tables.
> The feature has already been shipped as a part of BizTalk 2006.
>
>
>

[ Post a follow-up to this message ]

Hi Kristian,

The QFE is available. You can call our CSS to obtain it:

FIX: The dtasp_PruneTrackingdatabase() stored procedure may take many hours
to clean up the DTA database in BizTalk Server 2004
http://support.microsoft.com/defaul...kb;en-us;894253

Best regards,

WenJun Zhang
Microsoft Online Partner Support

This posting is provided "AS IS" with no warranties, and confers no rights.

[ Post a follow-up to this message ]