problem Deadoolk in my instance

Question

Post reply

problem Deadoolk in my instance

abdalah.mehdoini

Ten Centuries

Points: 1012

March 14, 2021 at 9:48 am

#3857564

Good morning all

I reset a deadlook problem every 10 minute Who can help me please optimize the execution of these requests

Sans titre

Please find attached the execution plan of my request

select FMENV.ENVIDX as IDX, 3 as Entity, FMBATCH.BATLOGNAME as
FM_Batch, FMENV.ENVIDX as FM_Document, FMENV.ENVLOGNAME as Name, 
FMENTPROP.EPRCUST19 as FM_ID_Client, FMENTPROP.EPRCUST09 as FM_Checking, FMCATEGORY.CATDESC 
as FM_Category, FMENV.ENVDATECRE as DateCre, FMENV.ENVPRIOR as Priority, FMENV.ENVOWNER 
as Owner from FMENV,FMBATCH,FMENTPROP,FMCATEGORY where 
( ENVSTATE in ('FI.VER1','FI.VER2_VAL1','FI.SWI1_VAL1','FI.EXP_VAL1')) 
and FMBATCH.INBOX in ('101','152','154','155','180','AX1','AX2','BUSINESSGRP','DJN','EN1','EN2','LYN','MLK','NAN','PXM','TLS','&lt;DEFAULT&gt;') and FMENTPROP.EPRENTTYPE = 3 and EPRENTIDX = FMENV.ENVIDX 
and (FMCATEGORY.CATCOD = FMENTPROP.EPRCUST10)
and (FMBATCH.BATIDX = FMENV.BATIDX) 
and FMENTPROP.EPRIDX = 
(select max(EPRIDX) from FMENTPROP where FMENTPROP.EPRENTTYPE = 3 and 
EPRENTIDX = FMENV.ENVIDX) and (ENVOWNER = 0) 
order by FMENV.ENVPRIOR DESC, FMENV.ENVDATECRE ASC

https://www.brentozar.com/pastetheplan/?id=ryi8iLi7u

thank you for your help

March 14, 2021 at 6:33 pm

This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80330 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Sergiy SSC Guru Points: 110208 More actions · Answer 2

Can you post the second query, and probably execution plan for it too?

How is the query you posted is invoked and how its resultet is used?

_____________
Code for TallyGenerator