[freetds] php and freetds

James K. Lowden jklowden at freetds.org
Thu Oct 20 08:34:12 EDT 2005


Erez Epstein wrote:
> I'm running a site balanced between 5 apache servers running on FC3,
> apache 2.0.53,php 4.3.4,freetds 0.63.
> 
> I have this strange problem that sometimes, not even times of load, the
> connections table at the sql server gets to a very high value (about
> 1000) my average is below 200.

I don't think you have a FreeTDS problem, and are therefore unlikely to
find much help on this list. :-(  FreeTDS makes connections when
requested.  You want to know who's doing the requesting, and why.  

If you want a suggestion, I'd analyze the traffic.  Find out which
machines are forming those extra 800 sessions; see what SQL they're
sending.  Microsoft's Profiler is your friend.  

--jkl


More information about the FreeTDS mailing list