SQL Server Performance Forum – Threads Archive

Any SP which can give the no of active connection

I m wondering which stored procedure can give the no of connections.
besides @@connections.
how can these be increased and decreased by a program or sp?

try sp_monitor which displays complete statistics

select
*
from sysperfinfo
where counter_name = ‘user connections’ —-
While sp_monitor is good, the "connections" column displays the logins and/or attempted logins to the server. Dbu

sp_who active. Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>