Performance issue in loading data from Salesforce to SQL.
Hello, I'm trying to load 2 million records from Salesforce cloud to one of the SQL Databases using Informatica Cloud and estimated time shows 200 hours. Case - 1 Specifications: SQL Server 2005. 4 cores. 12 GB OS memory and 9 GB SQL memory. SQL Database is in Simple recovery model. Estimated time 200 hours When I try to load the same thing to another server, with the below specifications it takes just 30 Minutes. Case - 2 Specifications: SQL Server 2008. 12 cores. 16 GB OS memory and 14 GB SQL memory. SQL Database is in Simple recovery model. Estimated time 30 minutes Please suggest how do I get it to load faster in SQL 2005 as mentioned in case 1. Thank you, Pradeep
Why would you want to use SQL Server 2005, end of extended support ends in less than 1 year. There are so many optimization improvements with SQL Server 2008, 2008R2, 2012 and 2014 and those are under support as well. You would need to review your wait stats, memory usage and other values to help determine why SQL Server 2005 is so much slower. My advice, don't use SQL Server 2005 if you have 2008 and higher in your shop.