How to check number of Active connections in SQL server?
Results 1 to 2 of 2

Thread: How to check number of Active connections in SQL server?

  1. #1
    sujit Guest

    How to check number of Active connections in SQL server?

    Hi All

    How to check number of active connections ?
    I know two ways of doing it ..

    1. run sp_who2

    2. in Current Activity in Enterprise Manager ..

    If what ever number I am seeing is the Active Number of Connections ..then

    I am facing a problem here ..

    In My serevr I have 75 Users licenses are configured for Per server option ..
    Through a Java aplication when Developer tried to capture any SQL server Connection it says following error ..

    Details :
    [MERANT][SQLServer JDBC Driver][SQLServer]Login failed. The maximum simultaneous user count of 75 licenses for this 'Standard Edition' server has been exceeded. Additional licenses should be obtained and installed or you should upgrade to a full version.

    If I see from Sp_who2 and Current Activity , I can see only 37 Connections ...?

    Why is so .. If I am having 75 configured and 37 live in sp_who2 ..why I am getting that error message ?

    Is there other way to see Actual Number of Connections made to server ?

    Sujit Kandi
    1 860 520 7454

  2. #2
    rc Guest

    How to check number of Active connections in SQL server? (reply)

    Try using Sp_who2 'Active'


    ------------
    sujit at 1/23/2002 2:51:20 PM

    Hi All

    How to check number of active connections ?
    I know two ways of doing it ..

    1. run sp_who2

    2. in Current Activity in Enterprise Manager ..

    If what ever number I am seeing is the Active Number of Connections ..then

    I am facing a problem here ..

    In My serevr I have 75 Users licenses are configured for Per server option ..
    Through a Java aplication when Developer tried to capture any SQL server Connection it says following error ..

    Details :
    [MERANT][SQLServer JDBC Driver][SQLServer]Login failed. The maximum simultaneous user count of 75 licenses for this 'Standard Edition' server has been exceeded. Additional licenses should be obtained and installed or you should upgrade to a full version.

    If I see from Sp_who2 and Current Activity , I can see only 37 Connections ...?

    Why is so .. If I am having 75 configured and 37 live in sp_who2 ..why I am getting that error message ?

    Is there other way to see Actual Number of Connections made to server ?

    Sujit Kandi
    1 860 520 7454

Posting Permissions

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