In talking with the server guy right now he's saying that the average Queue time (?) when the server gets bogged down has hit up to 25 seconds.
Hatton Hatton Humphrey wrote: >> >> >>>Hi folks, I've had my head buried in what we refer to as a "HOT" >>>issue... one of our applicaitons just moved from CF 4.5/SQL 7 to CF >>>5/SQL 2000 and is now having extreme problems. Basically what I'm >>>getting back from the server guys is, "the SQL Statements being >>>generated by the application are all locking each other out". This >>>application runs fine most of the time but now it's getting a HUGE >>>jump in usage and it's turning into a massive issue. >>> >>> >>> >>Need... more... information :) >> >> >> >> >Without being too specific the application was moved to a new server for >several reasons, technology not being one of them. The application is >an online ordering system that was originally written in 1999. It has >been in continous use since then and had enhancements over the years, >but it has always been a stable app when it comes to system performance. > >Wednesday marked the launch of a new client to the ordering system and >their usage has crippled the system. It was load-tested with 100 >concurrent users ordering 10 lines each and the system preformend >admirably. Now it is killing the service. When the CF service is >restarted everything flies... runs great and beautiful. After 30 or 45 >minutes of usage the sytem starts slowing down and eventually crawls to >a halt. It takes a service restart on the CF server and things get back >up to speed. > > > >>>My questions: >>>- Does this sound like a setting issue in CF? What things should I >>>look for on that regard? >>> >>> >>> >>> >>What settings are different? Connection pooling? Connection timeouts? >> >> >> >That's the aggrivating part. I don't have access to either server >directly but I'm the "pivot point" for communications. > > > >>>- Does this sound like a setting issue in SQL Server? What things >>>should I look for there? >>> >>> >>> >>> >>The one thing that jumps to mind is the default transaction isolation >>level. But without knowing if you use transacions at all, stored >>procedures, pass-through-queries or prepared statements I don't know. >> >> >> >That I know of there are no transactions used in the system (I know, I >know). The CF settings for transations are whatever the default >settings are. > >Anyone got an aspirin? > >Hatton > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
