Max Connections

On a SQL 2005 server I have set the max user connections to 500 and
restarted the SQL Services. The server is showing this as the current
running value.
However the user connections is reporting over 30,000 and sp_who
returns over 150 with the majority of these listed as sleeping.
Why is there difference between the values returned?You are comparing the results of sp_who and what else? Where
are you getting the user connections from?
If you are using @.@.connections, that is the number of
connections and attempted connections since SQL Server
started. It will not correlated to sp_who.
-Sue
On 24 Aug 2006 06:44:11 -0700, robin9876@.hotmail.com wrote:

>On a SQL 2005 server I have set the max user connections to 500 and
>restarted the SQL Services. The server is showing this as the current
>running value.
>However the user connections is reporting over 30,000 and sp_who
>returns over 150 with the majority of these listed as sleeping.
>Why is there difference between the values returned?|||It was a MoM rule which appears to be reporting all connections and
comparing at against concurrent connections.
Sue Hoegemeier wrote:[vbcol=seagreen]
> You are comparing the results of sp_who and what else? Where
> are you getting the user connections from?
> If you are using @.@.connections, that is the number of
> connections and attempted connections since SQL Server
> started. It will not correlated to sp_who.
> -Sue
> On 24 Aug 2006 06:44:11 -0700, robin9876@.hotmail.com wrote:
>|||But that doesn't answer what it's using. I don't have MOM
running where I'm at and don't remember all the details of
what runs what but there is a way to view what it's using.
Otherwise you can use Profiler and see what MOM is executing
when it checks your SQL Server.
-Sue
On 25 Aug 2006 01:32:13 -0700, robin9876@.hotmail.com wrote:
[vbcol=seagreen]
>It was a MoM rule which appears to be reporting all connections and
>comparing at against concurrent connections.
>
>Sue Hoegemeier wrote: