I said not to ask..... Just to answer what the heck are we doing --We are looking at all the possibilities. The instance in question has thousands of pages on it running all sorts of bad code built over10 years by a host of developers. When activity recently picked up on this server and the performance went bad, we got a team together and started digging. And, frankly, I was appalled at what I found. It's not just one query on a page -- we could handle that easy.
We just installed Fusion Reactor and are using it to identify problem areas, help with crash protection, etc. Our fixes includes re-writing code, row limiting, timeouts, query optimization, and other solutions for reports. I've just re-written our Excel POI module to be more efficient to ease our report problems temporarily. Our DB is definitely not underpowered. We will be tuning the JVM, look at CF defaults, and a host of other settings. We have killed threads when needed and are finding that isn't even enough -- we are re-starting CF almost every day. It takes time to change production code in a large corporate environment, especially when there are so many issues. So we have to deal with these long running threads without sockets because they aren't going away any time soon. Adobe support didn't have a solution for it but recommended we do something about it. I just don't know enough about sockets or monitoring them to really understand what's involved. I was hoping someone in this forum may have dealt with this before and thus save me some time. I will see if I can find an expert in our company who can help. Yes, Matt, I agree completely -- having a server monitor is a necessity. I am amazed at what I am learning about the server and my code. We never had Fusion Reactor until now -- we are impressed enough to buy copies for all our CFMX7 servers. I like it better than the CFMX8 Server Monitor but we won't be doing than for cost reasons (hard to beat free). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318045 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
