Missing Spinlock and Execution Time data in SAP ASE (Sybase) agents (4227759)

Some dashboards are missing data in SAP ASE (Sybase) agents

Messages similar to the following appear in the database agent log

Spinlock data

Execution Time

Execution time data is available for Sybase version ASE 15.7 SP100 (May 2013 )and above.

Sybase 15.x releases are listed externally here. 

How to turn off a Sybase collection

1. Edit the Agent Status Properties for the Sybase SAP ASE agent
2. Click the link to Modify the Private Properties for this agent
3. Click the Edit button next to the Collection Details secondary property list
4. Update the True or False value in the Collection Enable column for the appropriate collection (e.g. ExecutionTime)
5. Click the Save button 

How to check the Sybase SAP ASE version

There are two ways to know the about Sybase version,

1) Using this System procedure to get the information about Sybase version

> sp_version
> go

2) Using this command to get Sybase version

> select @@version
> go