Bad performance of DBAmp V22

That is not always a fair comparison - SF_MirrorAll can behave quite differently than SF_RefreshAll even in the same version, since SF_Mirror sometimes runs full copies instead of the delta copies that SF_Refresh always does. Is the timing difference on some runs, or all of them? The full copies should only be once every 7 days.

I would suggest sending an email to DBAmpSupport@CData.com and including the complete message output of your longer running SF_MirrorAll. There are a number of small details that can be tweaked with it, perhaps some more performant options that SF_Mirror has that SF_Refresh doesn’t, that can be far more easily addressed by going over the output. If there is some consistent performance issue there also, the support team can open a ticket to work on getting that resolved as well!

As for the error you mentioned, that particular error message is mostly a warning, also related to the difference in the stored procedure that you are using. If you had run SF_MirrorAll in v5.1.9, you likely would have gotten the same warning! That can be caused by permissions issues, or be the result of having another table by the same name in a different schema.