Connection count gone wild after upgrade to SQL2k5!

We upgraded our server last week to SQL 2005. Prior to this on SQL2k we
averaged 100 connections to the server from our web servers and in-house
applications. All we did was update our application config files so the
connection strings pointed at the new server and now we are up to over
5000!!!!! connections. All of our connection strings are either at the
default max connections or lowered to 50-75. We only have 2 web servers
hitting this SQL box and probably a couple dozen workstations running
windows apps in a very subdued manner, i.e. not db intensive at all.
How could this happen? I'm tempted to alter the server config and force a
max# connections but I'm worried what will happen if I do.
Any input/ideas?How do you count the number of connections?
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
"Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
news:%23VDKUMIoGHA.4800@.TK2MSFTNGP04.phx.gbl...
> We upgraded our server last week to SQL 2005. Prior to this on SQL2k we
> averaged 100 connections to the server from our web servers and in-house
> applications. All we did was update our application config files so the
> connection strings pointed at the new server and now we are up to over
> 5000!!!!! connections. All of our connection strings are either at the
> default max connections or lowered to 50-75. We only have 2 web servers
> hitting this SQL box and probably a couple dozen workstations running
> windows apps in a very subdued manner, i.e. not db intensive at all.
> How could this happen? I'm tempted to alter the server config and force a
> max# connections but I'm worried what will happen if I do.
> Any input/ideas?
>|||Perfmon - SQLServer:General Statistics -> User Connections
"Remus Rusanu [MSFT]" <remus.rusanu@.online.microsoft.com> wrote in messa
ge
news:uBVNBWIoGHA.3532@.TK2MSFTNGP04.phx.gbl...
> How do you count the number of connections?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> HTH,
> ~ Remus Rusanu
> SQL Service Broker
> http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
> "Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
> news:%23VDKUMIoGHA.4800@.TK2MSFTNGP04.phx.gbl...
>|||Are you using Service Broker activation by any chance? This would include
also features like SqlDependency or Web pages SqlCacheDependency that are
using activation behind the scenes. Activation can cause the perf counter to
go to abnormaly high values, but is only a perfcounter issue (is not
decremented properly).
You can confirm if the connections really grow or is just the a counter
problem by using a management view, like sys.dm_exec_connections.
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
"Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
news:O8JnogIoGHA.4728@.TK2MSFTNGP03.phx.gbl...
> Perfmon - SQLServer:General Statistics -> User Connections
> "Remus Rusanu [MSFT]" <remus.rusanu@.online.microsoft.com> wrote in mes
sage
> news:uBVNBWIoGHA.3532@.TK2MSFTNGP04.phx.gbl...
>