Thanks Tom, I found this article on trouble shooting deadlocks and it was quite helpful. I think I need to create an index on the table.
http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx In step 4 of the article I ran the Analyze Query in DTA and its recommendation was to create an index. At least I think that is what it is telling me. DTA had this T-SQL in the "definition" CREATE NONCLUSTERED INDEX [_dta_index_JobTicketColor_5_662345474__K2_K3_1] ON [dbo].[JobTicketColor] ( [JobTicketID] ASC, [ColorName] ASC ) INCLUDE ( [JobTicketColorID]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY] I will read up on what this T-SQL is doing before running it. > -----Original Message----- > From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] > Sent: Thursday, December 17, 2009 10:17 AM > To: cf-talk > Subject: Re: deadlocks > > > On Thursday 17 Dec 2009, Chad Gray wrote: > > I have a feeling in need to optimize my data and not the CF code. > > Making it run faster will not stop you getting deadlocks (entangled pairs > of > conflicting transactions). It might reduce the frequency of them, however. > > You really need to establish who/what is making the changes under you, and > use > a suitable locking strategy to mitigate it. > > -- > Helping to confidentially entrench error-free innovative slick back-end > customers as part of the IT team of the year, '09 and '08 > > **************************************************** > > This email is sent for and on behalf of Halliwells LLP. > > Halliwells LLP is a limited liability partnership registered in England > and Wales under registered number OC307980 whose registered office address > is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 > 3EB. A list of members is available for inspection at the registered > office together with a list of those non members who are referred to as > partners. We use the word "partner" to refer to a member of the LLP, or > an employee or consultant with equivalent standing and qualifications. > Regulated by the Solicitors Regulation Authority. > > CONFIDENTIALITY > > This email is intended only for the use of the addressee named above and > may be confidential or legally privileged. If you are not the addressee > you must not read it and must not use any information contained in nor > copy it nor inform any person other than Halliwells LLP or the addressee > of its existence or contents. If you have received this email in error > please delete it and notify Halliwells LLP IT Department on 0870 365 2500. > > For more information about Halliwells LLP visit www.halliwells.co > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329225 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
