Hi
I have an overnight process that moves allot of claims records Been working fine for many years.
Now it hits this part of the code (across a linked server) and gets the (1596567ms)MEMORY_ALLOCATION_EXT wait type and will sit there forever and never move any records - no delta movements at all. Used to complete in an hour now will sit there for over 12 before I have to stop it to let other steps in the job complete.
I am at a loss as what to do next. Both servers seem to have plenty of memory 512 GB.