Skip to Content

critical issue with sybase ASE allocating memory

Dears, kindly help in this critical issue,

we use Sybase ASE 15.7 for our production database, suddenly, for some users while they are executing statements on the database by our company's applications, they got the following message:

select error ct_cmd_alloc() user api layer external error the connection has been marked dead.

I've searched for this error and found maybe the reason is lack of adequate memory

P.S other users complain about slowing the applications that connected to database

please recommend me how to enhance some configuration parameters:

they are listed here with their current values:

max memory: 21000000

heap memory per user 24576 /* kindly note the max number of connections is 1000 , and about 750 user connected daily */

memory per worker process 1024

total logical memory 15586362

total physical memory 16109188

procedure cache size 393216

statement cache size 157184

total data cache size 28835650

p.s the windows server which host ASE has a 64 GB ram,

and during the working hours, memory doesn't exceed 34 GB as shown in windows task manager.

please advice.

Best Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 27, 2017 at 02:59 PM

    Any messages in the ASE errorlog when clients get this message?

    Client-fatal errors often correlate with an error with a stack trace in the ASE errorlog.

    -bret

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 27, 2017 at 10:55 PM

    No answers, just questions:

    1 - do all users of the application experience this problem? [wondering if the issue can be traced to a specific group of users]

    2 - do all users (of the application) on a particular network segment see this problem? [wondering if the issue could be network (segment) related]

    3 - has this always been a problem with the application, and if not, what may have changed lately (eg, new version of the app was recently released, new set of users were added and said users are seeing problems, etc)?

    4 - has anyone checked the application's logs to see if there are any details listed there? [wondering if this could be more of an application issue and not so much a database issue]

    5 - you mention some searches showing a possible issue with lack of adequate memory; can you provide links to some of your search results? [wondering about the context in which others have seen the error, and whether there's any resemblance to your environment]

    ----------------

    As for the comment about slow application ... while this may be related to the connectivity issues, I'd probably want to address performance (at least initially) as a separate issue (and a separate/new question in this forum).

    Unfortunately, there's usually a good bit more effort that goes into tracking down performance issues.

    High-level performance reviews would consist of:

    a - reviewing sp_sysmon sessions from the problematic time periods

    b - reviewing MDA (table) stats from the problematic time periods; this typically requires setting up some sort of MDA collector (eg, ASEMON)

    Add comment
    10|10000 characters needed characters exceeded

    • for this time until finding a solution, I'm thinking to restart an ASE service, not windows server .

      is there any risk by doing this, I 'a afraid that the service will not restarted sommthly, is there any propability to that.

      Regards

  • avatar image
    Former Member
    Mar 20 at 05:30 PM

    Could you please provide below details.

    (1) Select @@maxpagesize

    (2) Could you please give output of sybase Configuration parameters "default network packet size" and "max network packet size"

    Add comment
    10|10000 characters needed characters exceeded

    • Dear, here are the results

      @@maxpagesize = 8192

      Parameter Name Default Memory Used Config Value Run Value Unit Type
      default network packet size 2048 #6830 2048 2048 bytes static

      Parameter Name Default Memory Used Config Value Run Value Unit Type
      max network packet size 2048 0 4096 4096 bytes static