On Mon, 10 Jan 2005 19:57:11 -0000, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > Hey > > We came to the conclusion through rigorous testing and monitoring of stats > etc over the past 6 months. We used JVMStat to get the data we required > from the JVM from this we adjusted the JVM configs etc and we used SQLDiag > to get info from SQL Server at the time of a hung server so we knew that SQL > Server was pretty busy and indeed we knew that there were exclusive locks on > some core tables...(when we say hung we mean a CF server which has literally > just stopped serving pages mainly due to queued up requests). We have some > serious logging of EVERYTHING which is going on each webserver at any given > time.
hmm, sounds lilke a different issue - our servers never hang, and the dB CPU is avg 22%, min 0% max 56%. And there are never any deadlocks - sorted them out months ago, and we don't get any dB errors logged in CF. We had a few probelms with one particular query taking longer than it should a few months ago, but that was sorted by manually updating SQL server's statistics. > > You should only be using ParallelGC if you have more than 1 CPU on board the > box, MarkSweep will have serious impact and performance issues and could > crash the server if you have only 1 CPU and you have a pretty busy server. we've got 2 CPUs. > > Are you running IIS? If you are try running an iisreset.exe on the IIS > Server instead of rebooting or restarting as this will severe the connection > to SQL Server and start afresh. but most of the time we don't need to do *anything*: JRun just restarts. If we look in the event viewer it says: Warning: The Macromedia JRun CFusion Server service for the "cfusion" server is restarting. then about 5 seconds later: Informaton: The Macromedia JRun CFusion Server service for the "cfusion" server was started. PID is 5404. Note, theres no mention of JRun stopping.... > We are probably going to buy and upgrade > our drivers to DataDirect 3.4 or move totally over to Microsoft JDBC Type 4 > as I think the 3.3 driver which ships with CFMX is faulty under load in its > vanilla CF config. > > Any help I can provide OL I will be glad to help. > > N Cheers Bert ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:10:5098 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/10 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:10 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.10 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
