Troubleshooting Sybase ASE performance issues

[#1]

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.

[M-B]

Hello Mel,

From a database perspective, you have to ask the PaaS provider to start by sending you a sybdiag output from ASE. This is a collection of logs and configs that 'may' give you valuable information about the problem, if the latter writes an error in the ASE log. The sybdiag will also be helpful to check whether ASE needs tuning. Without the provider giving you details about the 'bad query', it'll be difficult to troubleshoot.

The ASE log is the first thing to check. If no errors are seen in the log at the time of the problem, then you need them to send you evidence of the bad query. That will allow you to check the related table.

Here is how to get a sybdiag :

1. Log in as sybase user. On Windows systems, make sure you open the cmd prompt in administrator mode

2. Execute the following on the command line

sybdiag -S<servername> -Usa -T asecore, keyfile, aseadd, osdata

For more details see : https://launchpad.support.sap.com/#/notes/2041802

Hope this helps

Mehrab