Query blocking in SQL creating work stoppages
Hello, we are getting some frequent query blocking in SQL for ServiceDesk Plus. It seems to happen 1-3 times a day. We have tried to create a support dump file since when the query is blocking we cannot do much of anything in ServiceDesk and it is mainly unavailable.
We are running SDP 9324 on a VM with 10 GB RAM and 4 Cores.
95% of the time the blocking query is this:
(@P0 bigint,@P1 bigint,@P2 bigint,@P3 bigint)UPDATE "WO_Tech_Info" SET "NEXTTECHNICIANID"= @P0 , "ENDTIME"= @P1 , "TIMESPENT"= @P2 WHERE ( ("WO_Tech_Info"."ASSESSMENTID" = @P3 ) )
Once we kill that process in SQL, Servicedesk resumes for everyone and they can continue working. I've mentioned this in the past on the forums but i didn't get much help. Any help is appreciated.
It would be nice to get this resolved soon since we have been running into this a lot and it keeps everyone from working, and takes time away from our DBAs who need to go in and kill those queries that are blocking.
We are running SDP 9324 on a VM with 10 GB RAM and 4 Cores.
95% of the time the blocking query is this:
(@P0 bigint,@P1 bigint,@P2 bigint,@P3 bigint)UPDATE "WO_Tech_Info" SET "NEXTTECHNICIANID"= @P0 , "ENDTIME"= @P1 , "TIMESPENT"= @P2 WHERE ( ("WO_Tech_Info"."ASSESSMENTID" = @P3 ) )
Once we kill that process in SQL, Servicedesk resumes for everyone and they can continue working. I've mentioned this in the past on the forums but i didn't get much help. Any help is appreciated.
It would be nice to get this resolved soon since we have been running into this a lot and it keeps everyone from working, and takes time away from our DBAs who need to go in and kill those queries that are blocking.