SQL INDONESIA

I am actively working to improve my skills and knowledge as a Database Administrator (DBA) with a focus on Microsoft SQL Server AlwaysOn technology using the new Windows Server 2022 and MS SQL Server 2022. I need to familiarize myself with various terms related to Availability Group Architecture. To set up my environments, I am using VMware technology and will prepare three (3) virtual machines.

• • Computer Name: INDSQLP1N1
    • Processor: 1 sockets and 8 vCPU
    • Memory: 16 GB
    • O/S: Window Server 2022
    • Installed Microsoft SQL Server 2022 CU20
  • Computer Name: INDSQLP2N2
    • Processor: 1 sockets and 8 vCPU
    • Memory: 16 GB
    • O/S: Window Server 2022
    • Installed Microsoft SQL Server 2022 CU20
  • Computer Name: INDSQLP3N
    • Processor: 1 sockets and 8 vCPU
    • Memory: 16 GB
    • O/S: Window Server 2022
    • Installed Microsoft SQL Server 2022 CU20
• Second, Installed and setup Window Server 2022 Standard edition on each VM.
• Third, I joined the Virtual Machine into my Domain Controller.
• Forth, I am going to configure Window Server Failover Clustering with Node majority.
  • There is no share disk storage
• Forth, I installed and setup Microsoft SQL Server 2022 on each Virtual Machine.
• Next, I turned on the AlwaysOn High Availability features.
• I make sure the user database must be using full recovery mode.
• A full database backup must have been performed.
• Finally, I  started setting up and configure the new Availability Group that called “AG[ApplicationName][P1]”

References:

• Availability Group –
  • AG is a container that represents a unit of fail-over
  • AG can have one or more user databases
  • When the availability  Group fails over from one replica to another replica, all the user databases will fail over.
• Primary Replica
  • Microsoft SQL Server instance that is currently hosting the AG (Availability Group).
  • The AG is active and hosting a user database that can be modified.
  • There is only one primary instance at any give point in time.
• Secondary Replica
  • SQL Server 2012 supports four secondary replicas
  • SQL Server 2014- 2016 supports eight secondary replicas
  • is hosting a copy user database that cannot be modified.
• Failover partner
  • SQL Server 2012 – 2014 support one failover partner
  • SQL Server 2016 – support two failover partners
  • Is the secondary replica that configured to be auto failover destination when the Primary Replica goes wrong.
• Synchronous vs Asynchronous
  • Synchronous is designed to setup Microsoft SQL Server AlwaysOn on Premises
  • Asynchronous is designed to setup Microsoft SQL Serer AlwaysOn  outside Premises.

References:

https://www.mssqltips.com/sqlservertip/4717/what-is-sql-server-alwayson/