can we control how transaction send from principal to mirror ?

Hi,

can we control how transaction send from principal to mirror ?

If application inserting 10000000 rows in one transaction to principal database

how infomation will be transfered once it is commited and where it will be stored before it is replayed on mirror database?

1. Is it going to be 1 big data packet ?

2.is it going to be split on many packets (of what size ?)

Thanks

Alex

Log records are sent from principal to mirror by log block boundary (64k max). In this case, since the transaction log for the transaction will be larger than 64K, multiple log blocks will be sent to the mirror. The log records are being sent continuously -- it doesn't wait for the commit.

The log records are stored on the log files on the mirror and are are applied on the mirror database continuously.

|||

Hi Sanjay , thank for you help

can you post link where I can read about "log block boundary" in db mirroring

you wrote

> The log records are stored on the log files on the mirror and are are applied on the mirror database continuously

Do you you mean they written to .ldf file of mirrored database ?

Alex

|||

Yes, the log is written to the .ldf file of the mirror database.