ATM and tables without stats.

[former_member272879]

Viewing DBAcockpit, we can see under Diagnostics > Table Statistics we have a number of tables with incomplete statistics.  ATM is configured with the default profiles and default windows.  From what we can tell, Although DBAcockpit is aware of tables without stats, ATM doesn't seem to run against those tables.  This makes sense if ATM is only concerned with tables that have changed and met the threshold.  Is there a way to configure ATM (or any other settings) to automatically run stats on tables without stats?  We are aware of the Job scheduler and planning calendar where we can write a custom script to be kicked off, but is there a built in way / recommended way to do this?

[former_member188883]

Hi Matthew,

You may check for ATM configuration as below to ensure that they are correct

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00a022d1-dce2-2e10-e687-f4903ed95...

Maintenence window in ATM are based on start date and time.So you need to wait for the next time the window is started.

Refer to further suggestions in the thread http://scn.sap.com/thread/3460691

Hope this helps.

Regards,

Deepak Kori

[former_member272879]

Deepak,

Thank you for the reply.  We already have the ATM document.  We know ATM is running and doing stats / reorgs on tables and indexes because we can see it running as a process and in the logs/history.  But we have a number of tables without stats that haven't been run against or in the queue

Does ATM need a set of baseline stats run on a table in order to pick up a % change (or however it's watching it)?

I guess the question boils down to:

Is there a way to get ATM (or some other option next to writing our own scripts) to automatically run stats on a table without stats?

[Former Member]

Hello,

we have the same problem on our side. Almost 350 tables have go incomplete statistics and we had performance trouble witha a table that had no statistics and therefore took the wrong index. After performing a manual update of the statistics of this table and removing it from statement cache the job ran three times faster!

So I just want to repeat the question:

Is there a way to get ATM (or some other option next to writing our own scripts) to automatically run stats on a table without stats? Does it make sense to do something like "update statistics all" on a regular basis?

Regards

[former_member272879]

Take a look at the size of the tables that are listed as incomplete.  ATM, by default, excludes tables under a specific number of rows.  They do this so that smaller tables aren't constantly run.  However, we've witnessed some of these smaller tables need up-to-date stats else they will cause performance problems.  Our work around was to change the small profile for stats to where it would pick up these tables.