Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anoop_mig25
Starting Member
20 Posts |
 Posted - 2015-01-07 : 06:28:36
|
| Hi friends basically my question is how can i determine whether transaction executed on primary server would be applied on mirror server or not .I mean in log shipping with restoration job and redo-undo file one is sure that particular transaction would get applied But how is this mechanism implemented in mirroring ?????I mean there is SEND and REDO queue in mirroring purpose but there is is size of queue , oldest unsent transaction , current sent rate and restoration rate etcbut from this counters how can i pull out data whether my transactions is shipped or applied in mirror instance of notRegardsAnoop Pandey |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2015-01-07 : 06:53:59
|
| Database mirroring is continuous log shipping. If you use high-safety mirroring, the transactions must be successfully sent to the mirror before they are committed on the principal. (They may not be redone immediately, but they are at least hardened in the mirror's log).You can query sys.database_mirroring DMV to get information on the log sequence numbers (LSNs) that have been sent, hardened, and flushed to disk:http://msdn.microsoft.com/en-us/library/ms178655.aspxIt will also provide information on mirroring state, in case your mirror is suspended, disconnected, etc. If you set up the mirroring monitor job:http://msdn.microsoft.com/en-us/library/ms403582.aspxYou can query historical mirroring status with the following:http://msdn.microsoft.com/en-us/library/ms366320.aspx |
 |
|
|
anoop_mig25
Starting Member
20 Posts |
Posted - 2015-01-07 : 11:24:41
|
quote:
Originally posted by robvolk
Database mirroring is continuous log shipping. If you use high-safety mirroring, the transactions must be successfully sent to the mirror before they are committed on the principal. (They may not be redone immediately, but they are at least hardened in the mirror's log).You can query sys.database_mirroring DMV to get information on the log sequence numbers (LSNs) that have been sent, hardened, and flushed to disk:http://msdn.microsoft.com/en-us/library/ms178655.aspxIt will also provide information on mirroring state, in case your mirror is suspended, disconnected, etc. If you set up the mirroring monitor job:http://msdn.microsoft.com/en-us/library/ms403582.aspxYou can query historical mirroring status with the following:http://msdn.microsoft.com/en-us/library/ms366320.aspx
Hi robvolk thanks for reply and quote |
|
|
|
|
|
|
|
|
Mointoring Mirroring in sql server