Clota Blog

Category: High Availability

  • New features of SQL Server 2022

    Hello guys, hope you are doing well. In this blog I’m going to discuss about the “New features of SQL Server 2022”  The release of the SQL Server 2022 is much anticipated by the audience since the announcement of it being in the works on November 2nd, 2021. Although the complete details of this brand-new version will…

  • AOG on Azure Blob with a different region SQL Server instance

    Hello there, everyone! I hope everything is going well for you. Today, I’ll show you AOG on Azure Blob with different region SQL Server Instance. Ø Created SQL disk layout and formatted with 64K- ·       Disk E: SQL Binaries ·       Disk T: TempDB ·       Disk R: User Databases ·       Disk L: User DB transaction logs Ø SQL Server Memory Configuration as…

  • AAOG Log Sync Analysis

     SELECT r.replica_server_name             AS Replica, DB_name(rs.database_id) ‘database_name’,        rs.is_primary_replica IsPrimary,        rs.last_received_lsn,        rs.last_hardened_lsn,        rs.last_redone_lsn,        rs.end_of_log_lsn,        rs.last_commit_lsn FROM sys.availability_replicas r      INNER JOIN sys.dm_hadr_database_replica_states rs ON r.replica_id = rs.replica_id ORDER BY replica; select log_reuse_wait_desc from sys.databases where name like ‘DB_Name’ SELECT   ar.replica_server_name as  Replica,        adc.database_name,        drs.is_local,        drs.is_primary_replica,        drs.synchronization_state_desc,        drs.is_commit_participant,        drs.synchronization_health_desc,        drs.recovery_lsn FROM sys.dm_hadr_database_replica_states AS drs      INNER JOIN sys.availability_databases_cluster AS adc ON drs.group_id = adc.group_id      AND drs.group_database_id = adc.group_database_id      INNER JOIN sys.availability_groups AS ag ON ag.group_id = drs.group_id      INNER JOIN sys.availability_replicas AS ar ON drs.group_id = ar.group_id      AND drs.replica_id = ar.replica_id ORDER BY Replica; Secondary replica is lagging behind the Primary replica  SELECT ag.name AS ag_name, ar.replica_server_name AS ag_replica_server, db_name(dr_state.database_id) AS database_name, is_ag_replica_local = CASE     WHEN ar_state.is_local = 1 THEN N’LOCAL’     ELSE ‘REMOTE’…