Optimizer Statistics

In the Performance display of the Database Alert Monitor and liveCache Alert Monitor, you can find, among other things, information regarding SQL Optimizer statistics.

Procedure

Open the Database Alert Monitor or liveCache Alert Monitor. Choose Performance Optimizer Statistics .

Result

Display	Default for Alerts
Last Collection	Yellow alert: Yellow alert, if the last update of the SQL Optimizer statistics is older than 30 days Red alert: Yellow alert, if the last update of the SQL Optimizer statistics is older than 60 days
Last Collection Type	Type of update carried out

Display

Default for Alerts

Last Collection

Yellow alert: Yellow alert, if the last update of the SQL Optimizer statistics is older than 30 days

Red alert: Yellow alert, if the last update of the SQL Optimizer statistics is older than 60 days

Last Collection Type

Type of update carried out

Update the SQL Optimizer statistics at regular intervals. To do this, follow the procedure described in Scheduling the Updates of the SQL Optimizer Statistics.