What does it mean? What do I do about it?
Example alert from the ProTop Portal:
What does it mean?
This is only relevant if your users use SQL connections to run queries against this database (think ODBC). It tells you that SQL statistics have not been updated for this database (-1) or have not been updated recently (> 30). Doing so informs the SQL query optimizer to improve the performance of SQL queries against the database.
What to do?
If you have SQL connections to this database, use ProTop RT (^u) to produce the SQL update stats script. If your schema changes regularly, you should run the ^u command regularly as well. Use the basic instructions provided to run the script to run at least once per month. Consider scripting it and running it from your job scheduler.
If you do not have SQL connections to the database, comment on this alert in your etc/alert.*.cfg. NOTE: The line to look for begins SQLStats (not sqlStats).
If all else fails...
Contact us at support@wss.com or use the online chat. We'll be happy to help.