I am using tools, workload-drivers.zip , from this link: https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0
to test SQL server 2016 AOG write operation.
I run the 'order-insert' and I see that this tools will keep writing to one of DB and I tried to do the SQL 2016 AOG failover while this application is inserting records, and what i found out is, the record will still be inserted JUST AFTER AOG failover done.
but it seems once it is done the insert (for records it is trying during failover), this application stopped to insert data, the connection string it use is:
Server= tcp:<SQL AOG listener>,1433;Database=<database name> ;Integrated Security=true;Column Encryption Setting=disabled;Max Pool Size=250;
So this mean this application can't keep the insert operation when it see AOG is failovering, any way to make such kinds of operation can detect AOG failover and keep inserting data once failover is done.