Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Exclamation Unanswered: Exceeding Number of User Connections but Why?

    hi, i am using Syb v12.5 on a Sun220R with 1GB of RAM, 2 processors
    and the memory setup for Sybase is provided below. You will see that
    the number of user connections i am allowed is nearly 7000.

    However, truth be told, I cannot raise it much beyond 50. I know 65
    fails for instance. I don't really want to iterate to find the real minimum
    on a production server!

    I have added the error message i get on restart when i am over the
    "limit". {it is the "os_create_region" message that really does the
    damage)

    What am i missing here? I presume i have allocated too much
    space to other things (data/proc cache) and not left enough for more
    connections. But WHY would i then be told i can have 7000 connections!?...

    So, how do i get myself out of this mess?
    thx
    j.


    =============================================

    Group: Memory Use

    Parameter Name Default Memory Used Config Value Run Value Unit Type
    ------------------------------ ----------- ----------- ------------ ----------- -------------------- ----------
    additional network memory 0 0 0 0 bytes dynamic
    allocate max shared memory 0 0 0 0 switch dynamic
    allow resource limits 0 #4 0 0 switch static
    audit queue size 100 2 100 100 number dynamic
    average cap size 200 0 200 200 bytes static
    caps per ccb 50 0 50 50 number static
    deadlock pipe max messages 0 0 0 0 number dynamic
    default network packet size 512 #184 512 512 bytes static
    disk i/o structures 256 46 256 256 number dynamic
    dynamic allocation on demand 1 0 1 1 switch dynamic
    enable rep agent threads 0 0 0 0 switch dynamic
    errorlog pipe max messages 0 0 0 0 number dynamic
    event buffers per engine 100 #10 100 100 number static
    executable codesize + overhead 0 479422 0 479422 bytes NULL
    heap memory per user 4096 0 4096 4096 bytes dynamic
    lock hashtable size 2048 51 2048 2048 bytes static
    lock spinlock ratio 85 0 85 85 ratio static
    max SQL text monitored 0 4 0 0 bytes static
    max memory 33792 700000 350000 350000 memory pages(2k) dynamic
    max number network listeners 5 4864 5 5 number static
    max online engines 1 597448 1 1 number static
    memory per worker process 1024 4 1024 1024 bytes dynamic
    number of alarms 40 4 40 40 number dynamic
    number of aux scan descriptors 200 #206 200 200 number dynamic
    number of ccbs 0 0 0 0 number static
    number of devices 10 #8 10 10 number dynamic
    number of dtx participants 500 150 500 500 number dynamic
    number of java sockets 0 0 0 0 number dynamic
    number of large i/o buffers 6 150 6 6 number dynamic
    number of locks 5000 758 5000 5000 number dynamic
    number of mailboxes 30 6 30 30 number dynamic
    number of messages 64 6 64 64 number dynamic
    number of open databases 12 1384 12 12 number dynamic
    number of open indexes 500 588 500 500 number dynamic
    number of open objects 500 667 500 500 number dynamic
    number of remote connections 20 33 20 20 number static
    number of remote logins 20 22 20 20 number static
    number of remote sites 10 1389 10 10 number static
    number of user connections 25 6935 50 50 number dynamic
    number of worker processes 0 0 0 0 number dynamic
    open index hash spinlock ratio 100 0 100 100 ratio dynamic
    open index spinlock ratio 100 0 100 100 ratio dynamic
    partition groups 1024 864 1024 1024 number dynamic
    partition spinlock ratio 10 0 10 10 ratio dynamic
    permission cache entries 15 #250 15 15 number dynamic
    plan text pipe max messages 0 0 0 0 number dynamic
    procedure cache size 3271 105656 50000 50000 memory pages(2k) dynamic
    process wait events 0 0 0 0 switch dynamic
    remote server pre-read packets 3 #32 3 3 number static
    size of global fixed heap 150 0 150 150 memory pages(2k) dynamic
    size of process object heap 1500 76 1500 1500 memory pages(2k) dynamic
    size of shared class heap 1536 0 1536 1536 memory pages(2k) dynamic
    size of unilib cache 0 120 0 0 bytes dynamic
    sql text pipe max messages 0 0 0 0 number dynamic
    stack guard size 4096 #392 4096 4096 bytes static
    stack size 46080 #4410 46080 46080 bytes static
    statement pipe max messages 0 0 0 0 number dynamic
    total data cache size 0 545050 0 545050 kilobytes NULL
    total logical memory 33792 689534 344767 344767 memory pages(2k) read-only
    total physical memory 0 676192 0 338096 memory pages(2k) read-only
    txn to pss ratio 16 1010 16 16 number dynamic
    user log cache size 2048 0 2048 2048 bytes static
    user log cache spinlock ratio 20 0 20 20 ratio dynamic
    wait event timing 0 0 0 0 switch dynamic

    (1 row affected)
    (return status = 0)
    00:00000:00037:2003/12/15 10:09:29.89 server Configuration file '/export/home/sybase/ASE-12_5/SYBASE4.cfg' has been written and the previous version has been renamed to '/export/home/sybase/ASE-12_5/SYBASE4.025'.
    00:00000:00037:2003/12/15 10:09:29.89 server The configuration option 'number of user connections' has been changed by 'sa' from '50' to '100'.
    00:00000:00017:2003/12/15 19:05:23.63 server SQL Server shutdown by request.
    00:00000:00017:2003/12/15 19:05:23.69 kernel ueshutdown: exiting
    00:00000:00000:2003/12/15 19:06:34.44 kernel Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
    00:00000:00000:2003/12/15 19:06:34.56 kernel Max fd 65536 exceeds internal limit of 10000
    00:00000:00000:2003/12/15 19:06:34.60 kernel Using config area from primary master device.
    00:00000:00000:2003/12/15 19:06:34.67 kernel os_create_region: can't allocate 702799872 bytes
    00:00000:00000:2003/12/15 19:06:34.68 kernel kbcreate: couldn't create kernel region.
    00:00000:00000:2003/12/15 19:06:34.68 kernel kistartup: could not create shared memory

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353

    Re: Exceeding Number of User Connections but Why?

    Originally posted by jeremy_1
    hi, i am using Syb v12.5 on a Sun220R with 1GB of RAM, 2 processors
    and the memory setup for Sybase is provided below. You will see that
    the number of user connections i am allowed is nearly 7000.

    However, truth be told, I cannot raise it much beyond 50. I know 65
    fails for instance. I don't really want to iterate to find the real minimum
    on a production server!

    I have added the error message i get on restart when i am over the
    "limit". {it is the "os_create_region" message that really does the
    damage)

    00:00000:00000:2003/12/15 19:06:34.67 kernel os_create_region: can't allocate 702799872 bytes
    00:00000:00000:2003/12/15 19:06:34.68 kernel kbcreate: couldn't create kernel region.
    00:00000:00000:2003/12/15 19:06:34.68 kernel kistartup: could not create shared memory
    This usually means that your "total memory" configuration is larger than the limit that is set in /etc/system (I think that's the file).

    Michael

  3. #3
    Join Date
    Dec 2003
    Posts
    2
    In /etc/system i have allocated 700MB for shared memory, but i am
    not sure if this is what is the cause....instead ('cos i didn't want to
    reboot it unnecessarily) I reduced the size of the proc and data caches,
    hoping that will leave more room for everything else to expand into.
    Will have to wait for a quite time to reboot & see if it improves things.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •