AG FAILOVER TESTING

select @@SERVERNAME 'Currnt Primay Replica';

create table Test_failover
(

Id BigInt Identity(1,1) Not Null,
Column1 varchar(255),
Column2 varchar(255),
Column3 varchar(255)

constraint [PK_TEST_Failover] PRIMARY KEY CLUSTERED
(
[Id] asc

));


Declare @Max BigInt,
       @Counter BigInt

  select @Max=20,@Counter=10;
 
  While(@Counter <+@Max)
  Begin

  insert into Test_failover(Column1,Column2,Column3)
  values(replicate('A',100),replicate('B',100),replicate('C',100))

  Print @Counter
  set @Counter =@Counter +1
  Waitfor delay '00:00:01'
  End