sql 2014 AG on VMWARE

  • New job new day, looking at a migration from sql 2008 physical cluster to a new sql server install on sql server 2014 on vmware. I am fine with moving db's jobs etc. Question is more of a architect view. This is a heavy duty oltp pharmacy system, would like to use AG and have a read only node to move some of the load off current server. THis seems doable, but any experience or gotchas ahead of time would be great. Was using the link below as a start

    http://www.derekseaman.com/2014/09/sql-2014-always-ag-pt-1-introduction.html

  • tcronin 95651 (12/29/2015)


    New job new day, looking at a migration from sql 2008 physical cluster to a new sql server install on sql server 2014 on vmware. I am fine with moving db's jobs etc. Question is more of a architect view. This is a heavy duty oltp pharmacy system, would like to use AG and have a read only node to move some of the load off current server. THis seems doable, but any experience or gotchas ahead of time would be great. Was using the link below as a start

    http://www.derekseaman.com/2014/09/sql-2014-always-ag-pt-1-introduction.html

    There's quite a bit to understand about WSFCs and SQL Server HA, the best place to start is with my stairway guide starting at this link

    http://www.sqlservercentral.com/stairway/112556/[/u[/url]

    Heavy load systems can push AGs, mainly due to the send queue size and latency and also the redo time on the secondaries. With extremely high load you may not see realtime data on a secondary, this is something that others have seen previously.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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