The SELECT program_name, * FROM the Master. The dbo. SYSPROCESSES WHERE (DBID) IN (SELECT DBID
FROM the Master. The dbo. SYSDATABASES
WHERE NAME='database NAME)
, query the database current connection

I use the ADOConnection. Open can increase the number of connections,
But ADOConnection. After the Close of the number of connections did not decrease

CodePudding user response:

This really didn't pay attention

CodePudding user response:

That's just shut down, also empty

CodePudding user response:

I tried it on, seems to be a period of time, the number of connections is less,
Immediately shut down, query the number of connections not less,

CodePudding user response:

The building Lord bingo, no immediate response results,

CodePudding user response:

A gradual rather than immediately? Never pay attention to the case to the original poster of seeking truth from facts worthy of great praise!

CodePudding user response:

Will not immediately reduce, need a period of time, a must for 20 seconds, will update the number of connection,