How to confirm deamon of auto update statistics working(is there anything shown on process)?What is the trigger to let update statistics work(like how many records insert into table)?
The statistics daemon launch at 3:00 am automatically if the DB_SVRST = 1 is set on dmconfig.ini when database start up. Customers can view whether statistics daemon server is alive by select * from sysuser command; SERVICE_SERVER just is this. Statistics daemon only launch at 3:00 am, if you want to do update statistics at another time, you can use the schedule within the Operation System to implement it. update statistics table_name will update statistics value of table_name totally (default sample = 100).
update statistics daemon will update the statistics of tables following below rules:
- table size doesn’t over 20 page size, doesn’t update statistics data
- if insert data doesn’t over 2 page size, doesn’t update statistics data
- the time is not over 10 days, doesn’t update statistics data.