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.
My questions: - Does this sound like a setting issue in CF? What things should I look for on that regard? - Does this sound like a setting issue in SQL Server? What things should I look for there? - Does this sound like a setting issue in IIS? I know it's not a hardware issue... the new webserver is a quad-processor machine with 4Gb of ram! Thanks! 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 Get the mailserver that powers this list at http://www.coolfusion.com
