n.node_name,

CASE WHEN rs.is_local = 1 THEN NLOCAL ELSE REMOTE END as is_local,

rs.connected_state_desc,

CASE WHEN drs.suspend_reason_desc=SUSPEND_FROM_USER THEN 用户手动挂起数据移动

WHEN drs.suspend_reason_desc=SUSPEND_FROM_REDO THEN 在重做阶段中出错

WHEN drs.suspend_reason_desc=SUSPEND_FROM_CAPTURE THEN 在捕获主副本上的日志时出错

WHEN drs.suspend_reason_desc=SUSPEND_FROM_UNDO THEN 在撤消阶段中出错（请参阅错误日志）

WHEN drs.suspend_reason_desc=SUSPEND_FROM_XRF_UPDATE THEN 找不到公共日志点（请参阅错误日志）

END as is_suspended, --是否数据库挂起及原因

drs.synchronization_health_desc,

ISNULL(drs.redo_queue_size,0) as redo_queue_size, --辅助副本的日志文件中尚未重做的日志记录量 (KB)

ELSE CAST(ISNULL(drs.log_send_queue_size,0)*1./ISNULL(drs.log_send_rate,0) AS DECIMAL(18,2))

CASE WHEN ISNULL(drs.redo_rate,0)=0 THEN 0 

END as redo_need_time --辅助副本中日志记录重做完成需要时间（秒）