I've found this article on SQL deadlocks extremely helpful. Reducing SQL Server Deadlocks http://www.sql-server-performance.com/tips/deadlocks_p1.aspx
Paul Alkema http://paulalkema.com/ -----Original Message----- From: Mark A. Kruger [mailto:mkru...@cfwebtools.com] Sent: Wednesday, June 09, 2010 11:15 PM To: cf-talk Subject: RE: Avoiding SQL deadlocks Even in a larger application.... if, for example, you are supported 150k users against a database. Say there is regular uniform logging going on - say search results or whatever. Whether the code is in different files or not if insert update queries are being run against the same tables you may suffer DB performance issues (including deadlocks). It's not wether the code is split - it's how the DB is being used and how much pressure is put on shared resources. Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Wednesday, June 09, 2010 10:03 PM To: cf-talk Subject: RE: Avoiding SQL deadlocks In a smaller app where there is only one piece of code that performs the actions that are causing deadlocks, sure. .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Wednesday, June 09, 2010 7:28 PM To: cf-talk Subject: Re: Avoiding SQL deadlocks > Since there is no deadlock error until a deadlock exists, the error you > reported is most likely the victim and not the culprit. Of course it could > have caused it then the same page was hit again and reported the error. In most CF applications with deadlocks that I've seen, the same code run concurrently is usually the cause of the deadlock. That is, there's a single script being run by multiple users, and that causes the deadlock. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334449 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
