Active Connections

Hello,
I got an message in MOM the I have more than 500 concurrent open connections on my sql server. So I checked this and saw that the number is about 200000. Nevertheless I can see only 80 connections in the activity monitor and the corresponding tables in the msdb.
So I restarted the server (it's a test server) and after an hour there already constantly 3000 user connections in the performance monitor and only 80 in the activity monitor.
Does anyone know how I can check what the other connections are or which process these connections create ?
ManfredDid you compare:
EXEC sp_who2;
and
EXEC sp_who2 'active';
Do you have an application that perhaps does not release connections?
"Manfred Schopf" <manfred.schopf@.aon.at> wrote in message
news:newscache$vz4o8j$mg7$1@.news.sil.at...
> Hello,
> I got an message in MOM the I have more than 500 concurrent open
> connections on my sql server. So I checked this and saw that the number is
> about 200000. Nevertheless I can see only 80 connections in the activity
> monitor and the corresponding tables in the msdb.
> So I restarted the server (it's a test server) and after an hour there
> already constantly 3000 user connections in the performance monitor and
> only 80 in the activity monitor.
> Does anyone know how I can check what the other connections are or which
> process these connections create ?
> Manfred|||Manfred Schopf wrote:
> Hello,
> I got an message in MOM the I have more than 500 concurrent open connections on my sql server. So I checked this and saw that the number is about 200000. Nevertheless I can see only 80 connections in the activity monitor and the corresponding tables in the msdb.
> So I restarted the server (it's a test server) and after an hour there already constantly 3000 user connections in the performance monitor and only 80 in the activity monitor.
> Does anyone know how I can check what the other connections are or which process these connections create ?
> Manfred
What counter are you monitoring in Performance Monitor? If you query
the sysprocesses table, you'll see exactly how many connections there are:
SELECT * FROM master.dbo.sysprocesses
Each row is a connection
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I think there might be a leaky application. I want to find out which one
this could be.
sp_who2 - 60 rows and with 'active' - 24 rows.
the perfmon counter tells me that I have about 44 logical connections
and 3000 user connections.
Manfred
Aaron Bertrand [SQL Server MVP] schrieb:
> Did you compare:
> EXEC sp_who2;
> and
> EXEC sp_who2 'active';
> Do you have an application that perhaps does not release connections?
>
>
> "Manfred Schopf" <manfred.schopf@.aon.at> wrote in message
> news:newscache$vz4o8j$mg7$1@.news.sil.at...
>> Hello,
>> I got an message in MOM the I have more than 500 concurrent open
>> connections on my sql server. So I checked this and saw that the number is
>> about 200000. Nevertheless I can see only 80 connections in the activity
>> monitor and the corresponding tables in the msdb.
>> So I restarted the server (it's a test server) and after an hour there
>> already constantly 3000 user connections in the performance monitor and
>> only 80 in the activity monitor.
>> Does anyone know how I can check what the other connections are or which
>> process these connections create ?
>> Manfred
>|||Tracy McKibben schrieb:
> Manfred Schopf wrote:
>> Hello,
>> I got an message in MOM the I have more than 500 concurrent open
>> connections on my sql server. So I checked this and saw that the
>> number is about 200000. Nevertheless I can see only 80 connections in
>> the activity monitor and the corresponding tables in the msdb.
>> So I restarted the server (it's a test server) and after an hour there
>> already constantly 3000 user connections in the performance monitor
>> and only 80 in the activity monitor.
>> Does anyone know how I can check what the other connections are or
>> which process these connections create ?
>> Manfred
> What counter are you monitoring in Performance Monitor? If you query
> the sysprocesses table, you'll see exactly how many connections there are:
> SELECT * FROM master.dbo.sysprocesses
> Each row is a connection
>
>
I got 64 rows.
I am monitoring 4 values in the perfmon:
user connections - 3089
logical connections - about 40
logins/sec, logouts/sec - I have much more logins than logouts per
seconds (about twice as much)
Manfred