Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
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?
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?
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 for the feedback. It is good to keep monitoring. There can be many factors which can cause slowness on specific moments.
Business Applications communities