In SQL server, DDL triggers can be used to trap changes to procedures, indexes etc, and/or modification dates on some objects can be checked periodically.
Of course not all such changes will affect performance, so there should be options to prevent or hide the automated annotations, by type or individually.
Could also set rowcount or Gb thresholds on large tables, to get markers as they increase in size.
