Hakim,

The scale that is used to denote the no of user connections is in 1000s.
I would divide the number by 1000 to get the actual number of user
connections.

So you have 30 odd connections open. You can also verify this by
executing sp_who or sp_who2 stored procedures.

Whenever a client makes a connection to SQL Server, it is the
responsibility of the client to disconnect after the work is done.

By having a closer look using the above stored procedures, you can
identify such orphaned processes and take the necessary steps.

For performance tuning, you can also use profiler to trace what kind of
queries the server gets and then you can use the index tuning wizard to
tune the long running queries.

Hope this helps,
John


-----Original Message-----
From: Hakim Tadjer [mailto:[Email Address Removed]
Sent: Wednesday, August 20, 2003 7:24 PM
To: LazyDBA.com Discussion
Subject: Open connection


Hi every one,

-- We have big performance problem in our production database, i want
to
know if
the connection open by client application (ASP, PHP clients) closed
after
thay finish they task.
How can i get this information to b sure the connection is closed
??

-- An other point when using Windows performance i profile user
connections
counter i see
his values between 32600 and 32800 and never less than this value.
and our production database never reach this concurrent users a
maximum
is 500- 1000,

is it normal or it's normal that this values is always like this

Help please

Thanks

_________________________________________________________________
MSN Search, le moteur de recherche qui pense comme vous !
http://fr.ca.search.msn.com/


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page