Return
-
Title
Sybase Top Procedure dashboard shows different metrics then sp_monitor output -
Description
A procedure in a Sybase database that runs for three hours and uses a significant amount of CPU does not display in the Sybase dashboard.
-
Resolution
Navigate to the Administration | Agents | Agent Status
Select the Sybase agent
Edit the properties
Click the link to modify the private properties of the Sybase agent.
Edit the following Agent Parameters
Max Rows Returned - 50Query Timeout - no, increase only when socket timeout exception happens.Collection Frequency - suggest to keep the default value: 80s.Save the changesNavigate to Administration | Data | Manage Retention PoliciesFilter by cartridge DB_SybaseFilter the search by top sqlClick on Sybase_MDA_TopSQLAdd a new policy as shown in the following screenshot
