so if I have latency(I can see unsent log when inserting a 10000000 records loop in Launch Database Mirroring Monitor)how can I prevent data loss?Is there any solution?

This is the test script:

DECLARE @i INT

SET @i=1

WHILE @i<10000000

BEGIN

INSERT INTO dbo.Table_1

VALUES( (cast(RAND() AS NVARCHAR(20))),GETDATE() )

SET @i=@i+1

END

If the principal server fails, how can I prevent data loss?manual failover is better or automatic failover?

I am so confused 🙁