I can t say any think about that what is your app is need?

You can take a trace on server which filter is your remote client hostname any query have problem in duration if it do not check your client anti virus or...

I think there is a problem in usp_CALLMAN_UPDATE_ADVISERS first look at this query execution plan and if it need any index. And

it is a query like this

Maybe you...

Maybe but look at this query execution plan. fragmentation is affect query performance

I think this query is problem

update CVResults set LastScanDate = @P1<c/> Platform_Idn = @P2<c/> results = @P3 WHERE CVResults_Idn = @P4

look at this query execution plan is it make index...

Thanks much

it is trigger in that s why i set the hints application before update set isolation level read commited

Is it true to change isolation level in triger

UPDATE isolation level read...

I think this the same think

REPEATABLE isolation level and row base locking

SELECT ID FROM TESTROWLOCK (HOLDLOCK,ROWLOCK)

Isolation level setting comming from application only i can edit triger that s why i try to find a hint

I m trying to do that

I want to be sure

BEGIN TRANSACTION

SELECT * FROM SomeRecords where id=1

............

Some Select and if statment

..........

UPDATE SomeRecords set=somerow where id=1

UPDATE SomeRecords

COMMIT TRAN

I have to...

I think i can not change this sql script to lock that rows and then do something

In my application i set the transaction first

BEGIN TRAN

UPDATE TESTROWLOCK SET ID=ID WHERE ID=2

SELECT ID FROM TESTROWLOCK WHERE ID=2

i want to change

this

BEGIN TRAN

SELECT ID FROM TESTROWLOCK ...

Think that i have a item total table and it inculudes all item totals and take 300.000 insert and update per a day and it has a

two index threee...

What about inculude columns in indexes?

You have to create and what is your isolation level