Search results

  1. P

    purge and resize db

    Thank you Stefan, That could at least explain the rather long time that Cringer did mention. So probably nothing wrong with disks and so. Bit weird though that Priority is already 3 (checked the export xml) Actually the daily backup IS a kind of low priority process and should not slow down...
  2. P

    purge and resize db

    hmm the 90 min were wrong (wishful thinking), usual duration is 160 min :( so i started a backup after removing the last one, but so far it won't make a big difference around 20 k Blocks/10sec @ 176 M Blocks total -> 135 min Disk transfer rate is oscillating, but maxes at about 125 MB/s so i'm...
  3. P

    purge and resize db

    Yes I do so and i will consider... Great hint, thank you
  4. P

    purge and resize db

    This discussion was very insightful so far, i'm armed with arguments for the upcoming discussion with the manufacturer. As we pay him, we will demand him to provide a solution. I'll probably will invest in a few hours of progress bootcamp follow up. Had 15 hours last year and made substantial...
  5. P

    purge and resize db

    sorry i mean we do have read-only direct access to the db (circumventing the application). we use it for odbc connections but we have no means of writing to the db except through the actual application and it's dedicated processes. All of them come with a license fee. So it's on the one hand...
  6. P

    purge and resize db

    I would prefer to D&L, rebuild, do whatever" on a recent copy of the db on server B (no downtime concern), while doing uninterrupted business with original db on server A. Then "synchronize" the newly refurbed instance on B "somehow" with all data that has been accumulated in the meantime on A...
  7. P

    purge and resize db

    no, no ABL compiler, no pw for writing, read only PW for ODBC
  8. P

    purge and resize db

    duh...o_O
  9. P

    purge and resize db

    :) >> ToDoList
  10. P

    purge and resize db

    Type II safely means old enough to no longer be required in current business, not in technical sense huge 1st time purge would be followed by regular incremental purges to keep only data up to a certain age. Concerning growth, i would reason: delete 30-40% of total data (acquired more than 10yrs...
  11. P

    purge and resize db

    Hello, Old Version was 10.2B (sorry) Daily full backup takes 90 min (online) WIN19,130GB RAM, 12*2 cores at 3 Mhz , VMWare7.1 (no system expert though) I keep an "archive instance" of db and Application on a dedicated server with all data from day one to end of 2023. However data retention...
  12. P

    purge and resize db

    Hi everyone, Great food for thought, thank y'all. I really appreciate your expertise and willingness to help Size and number of extents are up to date, reflecting the application structure and following manufacturers guidelines during last major upgrade to 10.7 Purging is done by means of the...
  13. P

    purge and resize db

    Thank you, didn´t know that about idxbuild and RF
  14. P

    purge and resize db

    Hi Everyone, I‘m an openedge admin in the making Progress 11.7.5, Runtime Version Db disk-size around 700GB (663 GB according to promon), lots of historic Data (running since 15 yrs) Recent Database Block Usage Summary Active blocks: 170322260 Data blocks: 170319324 Free blocks: 2936 Empty...
Top