Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2005
    Posts
    1

    Unanswered: sybase remote connections

    Hi there,

    Is there any way to check the number of remote connections that are currently using in ASE 12.0?

    Best Regards,
    JH
    Last edited by olsen_olsen; 01-25-06 at 22:27.

  2. #2
    Join Date
    Jun 2002
    Posts
    10
    Hello,

    If, by remote connections, you mean the number of user connections logged into the dataserver, then you can run sp_who, which displays connection information and a rowtotal. You can also directly query the master..sysprocesses table (select count(*) from sysprocesses).

    Hope that helps,

    -- Chris

  3. #3
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    sp_monitorconfig 'remote connections'

    works from 12.5.x onwards

Posting Permissions

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