What is the easiest/recommended way to find out when a checkpoint is done when r

shamec over 9 years ago

What is the easiest/recommended way to find out when a checkpoint is done when run for all engines? In my scenario we have nightly cron job that runs the checkpoint-suite script and we're trying to run some other scripts(cleanup/backup) after the checkpoint is complete and to do that we need to get a good idea of how much the checkpointing is taking so we can schedule the other scripts accordingly. To do that we need to monitor the checkpointing for a time and get an average duration so I need to know what our options are for doing that? Can it be done programmatically v.s. manually?

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 9 years ago

Shame,

You can get an average by opening your db_* logs and searching for this keyword

tailsave

the amount of milliseconds is logged in that line. This is an example of checkpoint taking 369 ms

WARN .a.pf.te "" "369" ".a.db.tailsave"

Usually the engines that'll take longer to checkpoint are: EXEC, DESIGN and ANALYTICS depending on which one is larger on memory/disk and the usage.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 9 years ago

Shame,

You can get an average by opening your db_* logs and searching for this keyword

tailsave

the amount of milliseconds is logged in that line. This is an example of checkpoint taking 369 ms

WARN .a.pf.te "" "369" ".a.db.tailsave"

Usually the engines that'll take longer to checkpoint are: EXEC, DESIGN and ANALYTICS depending on which one is larger on memory/disk and the usage.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data