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 ?
Manfred
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
|||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