Help get this topic noticed by sharing it on Twitter, Facebook, or email.

How does DBAmp impact performance on the SQL Server host?

Our DBA and System Engineers have concerns about DBAmp negatively impacting the performance of the host it's running on or over utilizing resources. Can you talk to the specific areas we could potentially see negative impacts?
1 person has
this question
+1
Reply
  • Considering that the size of a company's salesforce org can go from 10,000 rows to 150 million rows, it is tough to offer a general performance "rule" for DBAmp impact.

    I can make the following observations:

    1. Once DBAmp gets the row to SQL, then all performance issues are SQL issues. In other words, storing and querying a 50 million row table in SQL has the same SQL performance issues regardless of whether the data came from salesforce via DBAmp or some other source.

    2. CPU wise, DBAmp is normally waiting for the salesforce server to respond. Therefore there is not much cpu impact.

    3. Memory wise - Linked server code lives in the VAS memory of SQL. Therefore a 64 bit version of SQL is a must.

    4. Finally, the usage pattern matters. 100 users each accessing the linked server directly puts a much higher load on the SQL instance then using the DBAmp replication procs and then having the 100 users access the local, mirrored table.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned