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
can we control how transaction send from principal to mirror ?
Benedikt
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.
Adam Miles
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
MarcBeuret
Yes, the log is written to the .ldf file of the mirror database.