Results 1 to 8 of 8
  1. #1
    Join Date
    Aug 2007
    Posts
    59

    Unanswered: how to increase user connections

    hi
    In my ASE server
    number of user connections = 600
    @@max_connections =1014

    I want to increase it upto 1200
    But the ASE does not allowed to increase the number of user connections greater than @@max_connections.

    How @@max_connections will be increased ??

  2. #2
    Join Date
    Feb 2007
    Location
    Chennai, TN
    Posts
    68
    Hi,
    You can increase the connection by using the below system stored procedure

    sp_configure "max online engines", 1600

  3. #3
    Join Date
    Aug 2007
    Posts
    59
    Hi
    thanks for the reply
    u said that increase max online engines to 1600
    r u sure about it
    b'se the range of this parameter is 1 -128
    other thing it is mention in manuals that 'never have online engines more than there CPU are'
    My server has only 1 CPU
    Pl reply

  4. #4
    Join Date
    Feb 2007
    Location
    Chennai, TN
    Posts
    68
    Hi,
    Can u please try with the below

    sp_configure "total memory", 2621440 (may or may not required. In 2K pages, to use 5 GB of shared memory from the operating system) then

    sp_configure 'number of user connections', 1600

    and then use the following for checking.

    select @@max_connections
    Last edited by parangiri; 09-10-07 at 09:58.

  5. #5
    Join Date
    Aug 2007
    Posts
    59
    hi
    thanks for reply

    "total memory" is the read only parameter. It can not be changed using sp_configure.
    I can increase the "number of user connection parameter" only upto 750.
    It can not be increases further.
    Then the variable @@max_connections is still remains same.
    "number of user connection parameter" parameter depends on @@max_connections
    Pl reply.

  6. #6
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    Parangiri might mean the parameter Max Memory to be changed.
    Do you get an error when you try to increase the "number of user connections"-parameter?
    I'm not crazy, I'm an aeroplane!

  7. #7
    Join Date
    Aug 2007
    Posts
    59
    hi
    @@max_connections =1014
    when i tried to execute the command:
    sp_configure 'number of user connections',800
    it shows the error:

    Msg 5893, Level 16, State 1:
    Server 'mydb', Procedure 'sp_configure', Line 695:
    The sum, (number of user connections) + (number of devices * max online engines
    * 2) + (number of remote sites) + (max number network listeners) + (max cis
    remote connections) + (number of java sockets), must be no greater than '1014'.
    Msg 5849, Level 16, State 1:
    Server 'ELOSYBAE', Procedure 'sp_configure', Line 695:
    Verification failed for parameter 'number of user connections'.
    (return status = 1)

    where i can not change the other parameters. But i want to change number of user connection.

    Pl reply

  8. #8
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    The number of file descriptors available for Adaptive Server connections is stored in the global variable @@max_connections.

    The maximum allowable number of file descriptors per process is operating-system-dependent; see the configuration documentation for your platform.

Posting Permissions

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