What are the recommended system specs?
slimshaky
Posts: 13 Bronze 1
I have several long running sql data compares that run throughout the day. I just noticed that the box they are running on only has 2GB of RAM, and I'm wondering if this is a factor in the length of these compares. What are the recommended system specs for SQL Data Compare 13? This box is running Windows Server 2008 R2 SP1.
I don't know if this would be helpful to know for recommendations as well, but I am seeing a lot of async_network_io waits in sql monitor related to these compares.
I don't know if this would be helpful to know for recommendations as well, but I am seeing a lot of async_network_io waits in sql monitor related to these compares.
Answers
We don't have any specific recommended specs as what you'll need will definitely depend on how much data you're comparing.
You can try using the below documentation to see if that helps with your issue:
https://documentation.red-gate.com/sdc13/getting-more-from-sql-data-compare/getting-better-performance-out-of-sql-data-compare
Thanks!
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?