SBX - Search With Button

SBX - Forum Post Title

DELETE FROM VENDPAYMSCHEDLINE WHERE..... (SQL Script running multiple times)

Microsoft Dynamics AX Forum

GSD asked a question on 8 Nov 2018 4:03 AM

Question Status

Unanswered

Hi all, 

We have recently configured Dynamics Perf software and is running successfully. When investigating the result we see a DELETE query running multiple time throughout the day and taking a considerable amount of resource in the process. 

The script is

DELETE FROM VENDPAYMSCHEDLINE WHERE ((RECID=@P1) AND (RECVERSION=@P2))

Does anyone know where the script is scheduled to run and what this is used for?

Many thanks

Reply

Hi GSD,

It could be caused by user actions while they are working in this area. You can try to find out where in AX 2012 this table is used on forms or in coding. Have you tried to see if there are fragmented indexes on this table which can cause high resource consumption?

Reply
GSD responded on 13 Nov 2018 5:18 AM

Hi Andre - sorry for the delay.

I've checked the fragmentation and it was around 60%. I've since dropped the index and recreated. This issue hasn't cropped up since but I'm thinking it was actually another issue which caused this process to run slowly.

I shall continue to monitor and report back any changes,

Thanks again,

Dan

Reply

Hi Dan,

Thanks for the feedback. It is good to keep monitoring. There can be many factors which can cause slowness on specific moments.

Reply

SBX - Two Col Forum

SBX - Migrated JS