Replication Transactions per Second Benchmark

• DavidP-340734

  Right there with Babe

  Points: 737

  More actions

  April 25, 2014 at 4:19 pm

  #284994

  Does anyone have info on how many transactions per second transactional replication can handle?

  Server has 128GB RAM, 12 core 2 Process (24 core total) each transaction is approximately 32k.

  Publisher and Subscriber are on different servers on same LAN, separate disks for logs, data, indexes and tempDB.

  I've found data on how many transactions per second SQL Server can handle but nothing on replication.

• Jeff Moden

  SSC Guru

  Points: 1004591

  More actions

  April 25, 2014 at 7:31 pm

  #1708923

  It's not really possible to predict such a thing. Even if you knew precisely how much SQL Server could handle, you still have switches and routers on the LAN to contend with. Things will change if other network traffic occurs unless you have a dedicated fiber channel running directly from one box to another.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)