We have an MX install here that has been having a strange problem connecting to SQL Server databases. When actually registering the datasource...it takes about ~30 seconds before it actually succeeds. The problem also shows up in apps running on the machine. There is a huge delay in page execution as it waits for queries to return.
This only happens after the no other traffic has occurred between the db server and CF for a while, so we suspect it may be after a connection is dropped from the pool. We stuck a packet sniffer on the server and watch what happened when we registered a datasource. CF sent data and received an immediate response back from the database server, then sits there and chews on the data for like 30 seconds while no other traffic passes between the servers....then finally it decides everything is ok and registers the dsn. The 30 second time is so consistent, it feels like a manual timeout of some sort... Has anyone seen this, or know of a solution? -- jon mailto:[EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
