question

Pradeep407 avatar image
Pradeep407 asked

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
performanceperformance-tuningperformance-metrics
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Did you actually load it in 30 minutes or is that just the estimated time?
0 Likes 0 ·

1 Answer

·
Tim avatar image
Tim answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.