Thanks a lot.

I'm not sure if the app is using repeatable reads but it looks so - is there a way to change that? I already spoke to dev team...

OK, so I have 2 places with deadlock problems the way I see them in the error logs.

This is what a single process does: Select 5 rows from a staging...

Ok, this is what I see:

The app starts and logs as PID.The I could see multiple process running with the same PID. One of this process select and updates records...

Yes, I did the trace and I know exactly where the deadlocks appear but I cannot explain why as the application has the same behavior. And this showed me that...

"Assuming the code isn't awful" ... well, I do not know about that...

Actually the code is not bad - all is with transactions, small, fast, etc., retrieved only data needed...

LOCK_TIMEOUT 10 did not work for me as if the first process times out, then the second process says - #1 is out and i need to quit... So, the...

My app is heavy OLTP. It's a C++ application with rogwave database layer. All it does is to read the files provided in certain format and then decides if it's...

Can we use READPAST for updates? I though it's only for select statements...

Thanks,mj

Yes, I did use the locking hints but I did not see any difference in the behavior.

Thanks a lot,

mj

extreamly busy, and probably there's no resoures left for the profiler at all.

But is there a way to stop it anyway without to kill the profiler process. Sometimes I have...

Please, read the initial posting - thi sis 3rd party java app! The statement and the cursor type come thru the app - I get it into the trace. When...

I'm so sorry - forgot to post the statement. here we go:

declare @P1 int

set @P1=1

declare @P2 int

set @P2=4

declare @P3 int

set @P3=1

declare @P4 int

set @P4=-1

exec sp_cursoropen @P1 output, N'SELECT attribute.attr_id AS...

Thanks a lot - this saved me bunch of time. It does work with 2003 as well and fixed the problem.

mj

No multiple instances. I was trying to install a 3rd party app and there was not enpugh memory - I stopped the SQL server and did it, but I have...

Bellow are the values from sp_config. I have very similar values on another server and its memory showing much less then this one.

What else I can look to determine what...