Sysnchronous mode Always ON performance impact if secondary server is of low configuration compared to primary server

  • what will be  performance impact if secondary server is of low configuration compared to primary server.
    synchronous mode always on configured with sql server 2016 standard edition

  • meet.dinesh - Wednesday, November 8, 2017 11:36 PM

    what will be  performance impact if secondary server is of low configuration compared to primary server.
    synchronous mode always on configured with sql server 2016 standard edition

    You can probably guess at it. If the secondary server is capable of consuming 10 transactions, but the primary is consuming 11, there will be delays and waits. Now, the processing necessary for the primary vs. that for the secondary is different, so you won't be seeing a literal one-to-one as I suggested, but you must take into account the fact that with a synchronous data flow, any slow down on the secondary is absolutely reflected in the primary.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply