Getting lots of DB Errors: Transaction was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

2013-07-16 Thread Brook Davies
Hey Guys, I am getting a lot of these errors today: Transaction (Process ID 65) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. On a system that is used to track 'views' of a page via an ajax

Re: Getting lots of DB Errors: Transaction was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

2013-07-16 Thread Byron Mann
Index on sessionid will help immensely with that many rows. Ultimately, I would suggest never using a Guid as a primary key, performance is going to be less than ideal, even with an index. Byron Mann Lead Engineer Architect HostMySite.com On Jul 16, 2013 1:02 PM, Brook Davies

re: Getting lots of DB Errors: Transaction was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

2013-07-16 Thread Jeff Garza
Absolutely you should have an index on sessionID. Without that index you are forcing a table scan for that id so the engine can do the update. When your table was smaller, SQL could deal with that a lot easier. Once you start getting to 3-4 million rows, the performance starts to slow down

RE: Getting lots of DB Errors: Transaction was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

2013-07-16 Thread Brook Davies
Thanks Jeff and Byron! -Original Message- From: Jeff Garza [mailto:j...@garzasixpack.com] Sent: July-16-13 10:38 AM To: cf-talk Subject: re: Getting lots of DB Errors: Transaction was deadlocked on lock | communication buffer resources with another process and has been chosen as the

and SOAP

2013-07-16 Thread John M Bliss
Hi. Submitting a in a text field to a webservice is causing the webservice to throw an error. Should I be using: amp; or just: urlencodedformat() or something else? -- John Bliss - http://about.me/jbliss ~| Order the

Re: and SOAP

2013-07-16 Thread Dave Watts
Hi. Submitting a in a text field to a webservice is causing the webservice to throw an error. Should I be using: amp; or just: urlencodedformat() I suggest xmlFormat(). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a

Re: and SOAP

2013-07-16 Thread John M Bliss
Lord. Easiest Answer Of The Year entry. Thanks. On Jul 16, 2013 5:40 PM, Dave Watts dwa...@figleaf.com wrote: Hi. Submitting a in a text field to a webservice is causing the webservice to throw an error. Should I be using: amp; or just: urlencodedformat() I suggest