I upgraded the drivers to the article's specs and the problem persists. I will try and collect the other data from CFSTAT. We installed FusionRactor on the server, however, I have not been able to deeply understand what it is showing me. I see connection times ramp up, then time out and fall off. Due to the errors, it appears like they are DB connections that ramp up, stall and fail.
>For ColdFusion MX 7.x, have you tried upgrading the >macromedia_drivers.jar to from the default v3.3 to v3.5? Does 3.4 make >a difference? > >See: Updated DataDirect JDBC drivers (version 3.5) >http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=42dcb10a > >Also, if SQL Server database connections are returning "Connection >reset", can you use netstat on the database to determine just how many >open connections there are? I'm wondering if there are excessive open >TCP connections on SQL Server. How many TCP connections are in >ESTABLISHED, TIME_WAIT, or CLOSE_WAIT? How many of those are TCP >connections to SQL Server? I'm wondering if the problem is simply that >the database server has too many open TCP connections, whether they be >for the database itself or the system overall. > >Review all TCP connections: netstat -an -p tcp >Review only SQL Server connections: netstat -an -p tcp | find "1433" > >Also, the following bit of code will help determine which driver version >you are using: > ><cfset drivernames = >"macromedia.jdbc.oracle.OracleDriver, >macromedia.jdbc.db2.DB2Driver, >macromedia.jdbc.informix.InformixDriver, >macromedia.jdbc.sequelink.SequeLinkDriver, >macromedia.jdbc.sqlserver.SQLServerDriver, >macromedia.jdbc.sybase.SybaseDriver"> ><!--- replace all spaces ---> ><cfset drivernames = replace(drivernames," ","","ALL")> ><cfloop index="drivername" list="#drivernames#"> ><cfobject action="CREATE" class="#trim(drivername)#" name="driver" >type="JAVA"> ><cfset args= ArrayNew(1)> ><cfset driver.main(args)> ></cfloop> > ><cftry> ><cffile action="READ" >file="#server.coldfusion.rootdir#/runtime/logs/coldfusion-out.log" >variable="log"> ><cfset log = listtoarray(log,chr(10))> ><cfloop from="#(arraylen(log)-5)#" to="#arraylen(log)#" index="i"> ><cfoutput>#log[i]#</cfoutput><br/> ></cfloop> ><cfcatch>Look in {cf_root}/runtime/logs/{server}-out.log for results of >driver version info</cfcatch> ></cftry> > > >-Steve ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270849 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
