AL_Statistics table size issue

[system]

Friends,

My production job performance is getting deteriorated due to AL_Statistics table size issue.

Is there any option in CMC or the designer where we can limit the data retention in al_statistics to last 7 to 10 days or any way to do auto clean up of all the al_statistics, al_history tables on a weekly basis etc ?

Thanks.

---

Dvn (BOB member since 2012-11-24)

[system]

Login to the Central Management Console then go to Application > Data Services Applications

There are values for setting the Retention and how often the Cleanup Job runs.

-Adam

---

avandeweghe (BOB member since 2012-04-25)

[system]

We had already made that change few months back by changing History and Log retention period to 20 days but we still have entries in value column in al_statistics table having date greater than 30 days.

There is another field “Job History Cleanup Period”, is this linked to al_statistics ? Its ask to enter values in seconds, any idea what does this field exactly does ?

---

Dvn (BOB member since 2012-11-24)

[system]

you should first find out why the history is not getting deleted
if you want to cleanup the data manually, check the following post

Automate log deletion for a specific job?

Hi, Does anyone know a method for automating the deletion of logs for a specific job. I have a job that I want to repeat a regular intervals ( every 10 - 15 mins ) , but I don’t need the logs for more than a day. Other logs on the job server I would like to keep for about 60 days. It is a boring task to keep going into the console and deleting! Thanks pxbaker (BOB member since 2007-01-09)

if you are seeing lots of statistics getting generated then you can disable that by making the following changes to %DS_COMMON_DIR%\conf\DSConfig.txt file on the jobServer

first try the following
Enable_Statistics = TRUE
Disable_Transform_Statistics = TRUE

if you still see large amount of stats, then set the values as below
Enable_Statistics = FALSE
Disable_Transform_Statistics = TRUE

if the log deletion is not working properly, I would suggest opening a case with support

---

manoj_d (BOB member since 2009-01-02)

[system]

If you use the Data Quality reports, disabling statistics will also disable all of the reports.

We’ve been having serious issues trying to get reports to export, so tried this with some not so pleasant results.

---

jlynn73 (BOB member since 2009-10-27)