This has nothing to do with CF, so locking your queries and sp calls won't help you.
The deadlocks are probably occuring because a user is trying to read at the same time someone else is trying to write, or vice versa, or two people are trying to write to the same record at the same time, etc, etc. If you're really lazy, use SET TRANSACTION ISOLATION LEVEL SERIALIZABLE in your sp calls, etc. This entails a performance hit however. I'd recommend a redesign to minimize deadlocks. ----- Original Message ----- From: John McCosker <[EMAIL PROTECTED]> Date: Thursday, December 5, 2002 10:03 am Subject: deadlock errors > Hey, > been getting the page of DOOM on our development server over the > last couple > of weeks, I am properly locking all queries and stored proc calls > but still > it creeps in, > averaging 2 a day. > > error desc: > > [Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction > (process ID > #20) was deadlocked with another process and has been chosen as > the deadlock > victim. Rerun your transaction. > > Our devserver is connected to the same SQL server as our > Production server, > I know, I know but budget is an issue here, > > which is getting a lot of transactions / "INSERT" / per day > averaging 44,100 > transactions, > this is excluding GET transactions, thses transactions a set to > get bigger > also, > which makes me think of Clustering SQL server, has anyone done this? > > The reason for clustering SQL and not CF is because about 2 thirds > of these > are done > by Exchange, > > I know there is things that should be looked into at SQL server side, > currently looking at this, but, > > any direct advice on this matter would be appreciated, > > Respectfully, > j > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
