December 29, 2015 at 12:44 pm
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
December 31, 2015 at 3:24 am
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 starthttp://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