关于2008 标准版镜像的问题。

Question

看到2008 标准版对镜像的支持是“仅同步，单线程”

是指说2008标准版的SQL Server配置镜像之后，只能将模式设置为“同步”？

另外，我们知道，从Principal向Mirror端是传送事务日志并重新应用到Mirror端。

这里的“单线程”是指其中哪个阶段是单线程呢？

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 1

Single thread means sql will not do mirror process (log read/trasfer/apply) in parallel.

Answer 2

Single thread means sql will not do mirror process (log read/trasfer/apply) in parallel.

是指其中单个步骤还是整个Logread/trnasfer/apply?

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 3

是这个对照列表吗

http://www.microsoft.com/zh-cn/SQLServer/product-info/compare.aspx

估计是每个步骤是单线程，不是说Log read/trnasfer/apply

比如apply这个阶段是单线程的

而企业版是多线程的

如果整个阶段都是单线程，那么估计同步会非常长时间

Answer 4

Single thread means sql will not do mirror process (log read/trasfer/apply) in parallel.

是指其中单个步骤还是整个Logread/trnasfer/apply?

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

For whole process, those steps happen on two machines (log read/transfer on primary, apply on partner).