Viewing refreshes and evaluations at the server

You can view the pending and completed UPDATE STATISTICS commands by expanding Server Administration > Auto Update Statistics > List. Select either Pending Commands or Completed Commands from the list.

If there is no work for the refresh task to do, the refresh task disables itself in the Scheduler. However, the next time the evaluation task runs, and creates work for the refresh task, the evaluation task automatically enables the refresh task.

Copyright© 2018 HCL Technologies Limited