Always On Availability Groups (SQL Server)
Hello,
We're considering a change from SQL Cluster to a SQL Always On configuration. Please help me with the benefits this may also bring in relation to OS and SQL Updates in the future. As it stands now, we'd need to rebuild our cluster to update the servers OS and I'm interested to know whether Always On will provide additional benefits that allow making updates to the OS or SQL version without taking the entire system down.
Thanks,
Troy Taylor
We're considering a change from SQL Cluster to a SQL Always On configuration. Please help me with the benefits this may also bring in relation to OS and SQL Updates in the future. As it stands now, we'd need to rebuild our cluster to update the servers OS and I'm interested to know whether Always On will provide additional benefits that allow making updates to the OS or SQL version without taking the entire system down.
Thanks,
Troy Taylor
ASKER
Pawan,
Thank you. I did also see this article earlier. I'm also interested in how moving to the Always On will position us for future upgrades. For example, if we're using SQL 2016 now but want to upgrade in the future, will we be able to do that on a replica server, make it the Primary, and then go on to update the other SQL servers without taking the environment down?
Thanks,
Troy
Thank you. I did also see this article earlier. I'm also interested in how moving to the Always On will position us for future upgrades. For example, if we're using SQL 2016 now but want to upgrade in the future, will we be able to do that on a replica server, make it the Primary, and then go on to update the other SQL servers without taking the environment down?
Thanks,
Troy
There is also costs to Always on as well.
Secondary DB needs the same amount of disk as the Primary DB.
A share with adequate room for DB Backups.
OS should be on it's own drive.
DB's and Logs on separate drives (SAN).
Secondary DB needs the same amount of disk as the Primary DB.
A share with adequate room for DB Backups.
OS should be on it's own drive.
DB's and Logs on separate drives (SAN).
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
The advantages of SQL Server Always on are here-
https://blog.sqlrx.com/2015/04/07/features-and-benefits-of-alwayson-availability-groups/
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/always-on-availability-groups-sql-server