| Author |
Archiving the InterchangeDTA database
|
|
| Jeremy 2005-07-18, 5:51 pm |
| My InterchangeDTA database is about 45GBs. We are archiving about 2GBs of
data a night using the archive job(dta_purge_old_records). Unfortunately
removing this much data is locking the tables for about 15 minutes which is
effecting performance of incoming documents at this time.
Has anyone had experience with running this job mutiple times a day. Does
anyone have an other ideas that may help me with the locking.
| |
|
| Hi Jeremy,
I have the same problem as you. We have Biztalk 2000 and its database is
installed in same machine. It been in operation for three+ years now. My
InterchangeDTA has grown to 50GBs now. I checked the purge job that is
provided in the SDK. It seems is not working. I tried to shrink the database.
Its shrunk to its max level.
I need to purge the data thats older than 6 months. Can you help me with the
scripts to purge this data? (Or any one)
Thanks,
Karu
"Jeremy" wrote:
> My InterchangeDTA database is about 45GBs. We are archiving about 2GBs of
> data a night using the archive job(dta_purge_old_records). Unfortunately
> removing this much data is locking the tables for about 15 minutes which is
> effecting performance of incoming documents at this time.
>
> Has anyone had experience with running this job mutiple times a day. Does
> anyone have an other ideas that may help me with the locking.
>
>
| |
| Jeremy 2005-08-31, 5:58 pm |
| Karu,
I never received any help for this from Microsoft on this. What I ended up
doing was writing a wrapper that calls dta_purge_old_records. I added a
parameter that allows me to set how many records to delete every time it
loops through(I am using 5000) this prevents excessive locking and has worked
great.
Karu" wrote:
[vbcol=seagreen]
> Hi Jeremy,
>
> I have the same problem as you. We have Biztalk 2000 and its database is
> installed in same machine. It been in operation for three+ years now. My
> InterchangeDTA has grown to 50GBs now. I checked the purge job that is
> provided in the SDK. It seems is not working. I tried to shrink the database.
> Its shrunk to its max level.
>
> I need to purge the data thats older than 6 months. Can you help me with the
> scripts to purge this data? (Or any one)
>
> Thanks,
> Karu
>
> "Jeremy" wrote:
>
| |
|
| Can you forward me that? I want to test in my QA and deploy it in production.
"Jeremy" wrote:
[vbcol=seagreen]
> Karu,
> I never received any help for this from Microsoft on this. What I ended up
> doing was writing a wrapper that calls dta_purge_old_records. I added a
> parameter that allows me to set how many records to delete every time it
> loops through(I am using 5000) this prevents excessive locking and has worked
> great.
>
>
> Karu" wrote:
>
|
|
|
|