DURETTE, STEVEN J (AIT) wrote: > > When creating a DSN to a SQL server, what are the recommended settings > for the following? > > Select method (currently set to direct), > Maintain Connections (checked), > Max Pooled Statements (1000), > Timeout [min] (20), > Interval [min] (7)
Depends on your usage. How many datasources do you have, how many concurrent request does your server serve, how many datsources does your average request hit, do you use prepared statements etc. > Recently we started getting "Error establishing socket. Address already > in use" errors related to the database. You are getting these errors on the CF side? On the CF side this can be an indication that you are opening and closing TCP connections faster then the system can reuse them. Can you get a rough estamate from "netstat -an 30" how fast you are cycling through the available ports? What is your setting for MaxUserPort and for TcpTimedWaitDelay? The MS TCP/IP whitepaper is at http://www.microsoft.com/technet/itsolutions/network/deploy/depovg/tcpip2k.mspx (The Win 2003 version is MIA but largely the same.) Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229503 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
