Explain DB Mirroring operating modes?

1.	Explain DB Mirroring operating modes?
Answer» ALWAYSON provided you with the feature of Readable replica. This is a long-awaited feature where you can UTILIZE your passive node. Unlike cluster where your passive node CONSUME all your resources but you cannot utilize them before the primary node goes. Benefits: Offloads your read-only workload from primary to secondary. Utilize your resources of secondary mode Temporary statistics on readable secondary HELP in performance TUNING on secondary. Offload T-log backups to secondary reduce backup load.

Answer»

ALWAYSON provided you with the feature of Readable replica. This is a long-awaited feature where you can UTILIZE your passive node.

Unlike cluster where your passive node CONSUME all your resources but you cannot utilize them before the primary node goes.

Benefits:

Offloads your read-only workload from primary to secondary.
Utilize your resources of secondary mode
Temporary statistics on readable secondary HELP in performance TUNING on secondary.
Offload T-log backups to secondary reduce backup load.

Discussion