SQL Server Always On Availability Groups - An Introduction

This video introduces SQL Server Always On Availability Groups! We discuss what they are, the general architecture, how they can be used, how to create, and some of the nuances.
If you would like to submit a question please drop it below!
Company Website
www.serverside-ts.com
Contact Email: [e-mail]

[@sqlanswers]

Have a question about Always On Availability Groups? Feel free to drop it below!

[@n18ldn]

Hello thank you for the video I have some questions around the failover during synchronous and asynchronous between sites first I guess is is it possible to create an auto failover between sites with asynchronous mode and second would synchronous be an option at all if we had a steady dedicated vpn tunnel between sites with a reliable ping?

[@sqlanswers]

Hi, yes, in order to configure auto failover the nodes need to be is synchronous mode. And, yes, you could have nodes with different synchronous/asynchronous setting. I would definitely suggest making sure the network connectivity is reliable. If you have more questions please let me know!

[@n18ldn]

@@sqlanswers the connectivity is reliable lease lines to isp can I use synchronous? Between sites

[@sqlanswers]

I'm not an expert on communications infrastructure, but leased lines are advertised to be reliable. And in some cases, you can get an SLA from your provider to assure the leased line is available so you may want to investigate that if your requirements are critical.

[@n18ldn]

@@sqlanswers ok thank you for coming back to me really appreciate your time! I'll watch and support the channel!!

[@plutonhouse]

A live demo in SQL Management Studio would be nice. Just having slides is a bit dull.

[@sqlanswers]

Thanks for the feedback! I'll see if I can put something together for you!

[@sqlanswers]

@plutonhouse - Here you go! czcams.com/video/tWWrpFEBiu0/video.html