Sounds like a CF issue. All the SQL Server is trying to do is service the requests.
How big are your transaction blocks? What locks have you got in place? Can you reduce SQL server use by caching queries? Could be a lot of things. > -----Original Message----- > From: Hatton Humphrey [mailto:hatton@;fishertowne.com] > Sent: 25 October 2002 13:53 > To: CF-Community > Subject: CF Server 5 Locking Help!? > > > 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 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
