SQL Data Compare 11 consumes CPU 100 %

Paresh Bhadekar

Hi Team,

We are using Redgate SQL Data Compare with batch scripting
batch scripts are automated into windows task scheduler.

While running these tasks consumes CPU up to 100 %. this issue started when we use SQL Data Compare 11.0

For information, Earlier we were using redgate 6.1 with the same windows server configuration, now we are using RedGate 11.0

Anu D

Hi Paresh,

Thanks for your post!

Can you try few suggestions mentioned in these articles:

Improving the performance of SQL Data Compare
Troubleshooting comparison and deployment performance problems
Troubleshooting System.OutOfMemoryException during comparison

Let me know if this helps.

Paresh Bhadekar

Hi Annu,

We are still facing the problem. Do we have any suggestion on this concern.

SQL_ME_RICH

Check the task manager both before and after you start your tasks, and pay close attention to how many instances of svchost.exe you see (and especially what resources each is taking).

I don't know what version of Windows / Windows Server you are running, but I would start troubleshooting there.