Sybase Top Procedure dashboard shows different metrics then sp

Chatee ahora con Soporte

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

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

Sybase Top Procedure dashboard shows different metrics then sp_monitor output
Descripción

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.
Resolución

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

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

Producto(s):: 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

Historial del artículo:: Creado el: 11/19/2020
Última actualización: 5/7/2023

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