Resolution 1.Grant appropriate permissions to the user account monitoring the Sybase server.
KB 4229296 has general steps how to get the grant script for most Database products.
Resolution 2.To enable the TopSQL collection
globally, the default secondary property list
CollectionDetails can be edited.
- Open Dashboards | Administration | Agents | Agent Properties
- Select Sybase_MDA
- Look up the Secondary Property List Collection Details and click Edit, the Secondary Property List dialog opens
- Look up the TopSQL collection and click on the false value in the Collection Enable column, a context menu opens
- Select True from the context menu and wait for the Radio button to get selected and applied, the value changes to true in red
- Click on Save on the Secondary Property List dialog