Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
agibson
Starting Member
4 Posts |
 Posted - 2009-03-30 : 16:21:42
|
| hello all I have an app (3rd party) which consistantly creates deadlocks in Sql Server 2000 sp4. I am no expert but I have noticed that this app consistantly uses a table call control with a single row. This one row holds all the counters for the different modules of the application. The application has about 8 modules and is used by over 100 different people. Am I correct in thinking that this could create a pretty large bottleneck that would generate my deadlocks?Can anyone refer me to a guide that would help me to definitely identify my problems, so that I can force the developer to correct them?Also is there any special steps I can take to resolve or at less lessen the frequency of these issues.Thanks for all your help Andre Gibson |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2009-03-30 : 20:04:32
|
| There is a pretty good MSDN bulletin about trouble-shooting deadlocks here: http://support.microsoft.com/kb/832524 |
 |
|
|
agibson
Starting Member
4 Posts |
Posted - 2009-04-01 : 07:39:52
|
| sunitabeck, thanks for the feedback. I'll check it out.Do you agree that the manner in which the counters are being handled is contributing to the locks?And if the 3rd party developers are not prepared to make any changes is there anything I can do to resolve the issue? |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-04-01 : 09:26:38
|
| Sounds like poor design and, yes, this could very well be the source of your deadlocks. Being a third party app probably means you cannot modify the code or DDL. Has this been discussed with your vendor? I'm willing to bet it's a known issue with the vendor as you can be sure if you are having this problem, other customers of theirs are too. See what they have to say. It may be a simple patch or service pack that they have already developed. Hope it's that simple otherwise, with a 100 potential angry users, it may be time to explore other package options.Terry-- Procrastinate now! |
|
|
|
|
|
|
Bad App