connections

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: "Everaldo Ricardo" <etc_ricardo@xxxxxxxxxxx>
Date: Thu, 16 Feb 2006 18:54:20 -0300

when I type 'select @@connections' in sql query analyzer, it show about
200.000, and never decrease, just increase, is it a problem ?

I have just 50 hosts

.

Follow-Ups:
- Re: connections
  - From: giorgio rancati

Prev by Date: Re: connections
Next by Date: Re: How to insert a New Line into a text field?
Previous by thread: Complicated Connection Problems bewteen ADP and SQL Server
Next by thread: Re: connections
Index(es):
- Date
- Thread

Relevant Pages

RE: SUMMARY:RE: TCP_keepalive
... of short and unreliable connections). ... creating a TCP socket. ... printf "Decrease the tcp time wait interval\n" ...
(SunManagers)
Re: Setting Max Threads TOO HIGH !!!
... I don't believe you will get any performance gain or decrease as the number ... of threads does not correspond to number of connections. ...
(microsoft.public.sqlserver.server)
Re: connections
... @@CONNECTIONS ... Giorgio Rancati ... [Office Access MVP] ... 200.000, and never decrease, just increase, is it a problem? ...
(microsoft.public.access.adp.sqlserver)
Re: Max number of threads that can be used?
... - changing the stack size of the thread will decrease the used address space ... switch to 64 bit OS ... Change the architecture of your program ... Use a connection pool with a reasonable, limited amount of connections ...
(comp.programming.threads)