SQL Data Compare 11 consumes CPU 100 %

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

Paresh Bhadekar April 28, 2016 10:59

Comments

3 comments

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.

Anu D May 02, 2016 08:04

0
Hi Annu,

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

Paresh Bhadekar May 06, 2016 07:35

0
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.

SQL_ME_RICH May 24, 2016 16:47

0

Add comment

Please sign in to leave a comment.

How can we help you today?

SQL Data Compare 11 consumes CPU 100 %

Comments

Add comment