Sybase Top Procedure dashboard shows different metrics then sp

立即与支持人员聊天

Sybase Top Procedure dashboard shows different metrics then sp_monitor output (4231983)

反馈已提交

本文是否解决了您的问题？

选择评级

标题

Sybase Top Procedure dashboard shows different metrics then sp_monitor output
说明

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.
解决办法

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 - 50
Query Timeout - no, increase only when socket timeout exception happens.
Collection Frequency - suggest to keep the default value: 80s.
Save the changes
Navigate to Administration | Data | Manage Retention Policies
Filter by cartridge DB_Sybase
Filter the search by top sql
Click on Sybase_MDA_TopSQL
Add a new policy as shown in the following screenshot

反馈已提交

本文是否解决了您的问题？

选择评级

建议的内容

产品：: Foglight
6.1.0, 6.0.0, 5.9.8, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2; Foglight Evolve
6.1.0, 6.0.0, 9.3, 9.2, 9.1, 9.0; Foglight for Databases
6.1.0, 6.0.0, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2

Sybase Top Procedure dashboard shows different metrics then sp_monitor output (4231983)