I have a SQL agent job running SF_Mirror for a single object every 15min. When the job runs I can see the DBAmpAZ.exe process restart and I get CPU spikes to 80-100% for the duration of the run. The job generally runs in about 30 sec.
Is there anything I can do to cap its CPU usage, or anything I can look at changing to prevent it from spiking that high?
