How to track number of connections

• sherpedro

  SSC Rookie

  Points: 28

  More actions

  September 7, 2003 at 7:45 pm

  #81102

  Hi!

  I have an network application that can be installed on multiple computers in the same network. My problem is that i would like to be able to manage the maximum number of connection from a specific program to a specific database.

  It would make user licensing easier for me than having my app do the job!

  Any idea?

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  September 7, 2003 at 9:35 pm

  #472957

  Does the app keep a connection open all the time or connect / disconnect.

  Can count the number of connection to a specific database for a specific hostname with a sp.

  Select Count(*) 
  
     From Master..SysProcesses
  
     Where Program_Name='SQL Query Analyzer'