HOW TO: Get the number of database connections on the Columbus databases
  • KB ID: KB-01032
  • Created: 12/19/2017 7:47 AM
  • Updated: 12/19/2017 7:48 AM
  • Views: 36
  • 0 Ratings

Summary

For the sake of analysis you want to find out how many connections Columbus is opening to your database

More Information

The following statement lists the number of connections per user

Instructions

Follow these steps:

  1. Log on to your MSSQL database management system (e.g. using SQL Management Studio)
     
  2. Open a new query
     
  3. Enter the following statement(s):
    SELECT 
        DB_NAME(dbid) as DBName, 
        COUNT(dbid) as NumberOfConnections,
        loginame as LoginName
    FROM
        sys.sysprocesses
    WHERE 
        dbid > 0 and DB_Name(dbid) in ('Audit','Columbus','EndPoint')
    GROUP BY 
        dbid, loginame
    
    
    Please change the names of your databases accordingly if needed
     

Products

C7

Feedback

Did you find this article helpful?
Powered by Spider Knowledge Base, a product of brainwaregroup