Тёмный

Always on Availability group (AG) cluster in SQL Server 

ARSLANOV
Подписаться 942
Просмотров 3,6 тыс.
50% 1

Опубликовано:

 

21 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 14   
@AbrorAbror-j1b
@AbrorAbror-j1b Год назад
Thanks for this. At last I understood AG. I have never seen this kind of detailed video for AG internals. This is very good channel for internals :)
@fpost337
@fpost337 2 месяца назад
Great content and balance between concepts and practical example!
@arslanov1886
@arslanov1886 2 месяца назад
Thank you. Glad it helped🙂
@umakantkesgire7720
@umakantkesgire7720 9 месяцев назад
Very useful information. Thanks a lot 🙏
@arslanov1886
@arslanov1886 9 месяцев назад
Most welcome 😊
@amarcse06
@amarcse06 Год назад
Good session mate..please make the videos of basic troubleshooting in AOAG..thank you 🙂
@arslanov1886
@arslanov1886 Год назад
Sure mate. Thanks for suggestions
@vijaymunavalli335
@vijaymunavalli335 Год назад
cool explanation.. thanks!!🙂
@arslanov1886
@arslanov1886 Год назад
Glad it was helpful!
@riazkm9136
@riazkm9136 Год назад
when we create windows failover cluster for SQL AG, do we need to have quorum disk / file witness? what is the best practice for the same.
@arslanov1886
@arslanov1886 Год назад
yes, you should create quorum witness as best practice. If you do not have quorum witness, there will be 50% probability that your whole cluster fails when one node goes down. Please refer below official doc: learn.microsoft.com/en-us/azure-stack/hci/concepts/quorum#examples
@riazkm9136
@riazkm9136 Год назад
@@arslanov1886thank you very much for the prompt and detailed reply. our environment is on a vxrail. what will be the best witness to use? will a file share witness created on a nas storage work. have you got any good videos for configuring the windows failover cluster. if yes, please share.
@arslanov1886
@arslanov1886 11 месяцев назад
As long as you have a constant and stable network between your servers and witness, you can choose any type of witness. There are other small points. Please refer below: learn.microsoft.com/en-us/windows-server/failover-clustering/manage-cluster-quorum#witness-configuration Please make sure that the witness is in another server. I do not have videoes but I would follow the below good docs: Step 1 learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/failover-cluster-instance-prepare-vm?view=azuresql&tabs=single-subnet Step 2 learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/failover-cluster-instance-azure-shared-disks-manually-configure?view=azuresql
Далее
Eco-hero strikes again! ♻️ DIY king 💪🏻
00:48
How to Create SQL 2019 Always ON High Availability
1:06:39
Eco-hero strikes again! ♻️ DIY king 💪🏻
00:48