December 11, 2015 at 12:39 pm
Moving to new job in a week that currently has a high usage OLTP on SQL 2012 on vmware that also has heavy reporting. They probably should have looked at a real time read only node. I was wondering about adding AG and a read only node. Is this feasible on VMWARE, not sure of all specifics will find out more when I get there. Trying to figure out what options may be ahead of time
December 11, 2015 at 1:23 pm
tcronin 95651 (12/11/2015)
Moving to new job in a week that currently has a high usage OLTP on SQL 2012 on vmware that also has heavy reporting. They probably should have looked at a real time read only node. I was wondering about adding AG and a read only node. Is this feasible on VMWARE, not sure of all specifics will find out more when I get there. Trying to figure out what options may be ahead of time
First off hope you are on Enterprise Edition of SQL Server, because cannot do AGs without that.
Also note that making a node readable MODIFIES PRIMARY DATA STRUCTURES, adding the 14-byte snapshot pointer to modified records. If you are like all my clients that means your default index fill factor of 0 will CRUSH your system with page splits, tlog activity (which must also be sent over to the mirror(s)), locks/latches, dirty pages, etc.
And know that there are NUMEROUS bugs, caveats, limitations, provisos, gotchas, etc to AGs, especially readable ones.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
December 11, 2015 at 1:27 pm
Noted and I also just realized they will be on SQL 2014, from what I have heard does a better job with AG.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply