Skip to Content
0
May 23, 2018 at 08:19 PM

Troubleshooting Sybase ASE performance issues

2314 Views

I'm new to Sybase ASE, but I had been a DBA for MS SQL Server in previous jobs. I'm now one of the development managers for SAP Data Services which using Sybase ASE. Note, I'm not the basis person for Data Services. The Data Services servers and corresponding Sybase ASE server are hosted by a PaaS provider.

At times, Data Services becomes inaccessible. I can't get to Data Services CMC or the Data Services Management Console.

The PaaS provider is telling us a bad query is impacting the Sybase ASE server. I've asked them what database and what tables are being queried, but I never get an answer from them. I know I can determine this from MS SQL Server, but is it possible to identify what query is causing the issue in Sybase ASE? If so, what is the process of determining this?

Thanks.