怎樣監控sqlserver 2005中的mirror運行狀態?

Question

大家好，我在兩臺server的數據庫上配置了Mirror功能，目前對監控這一塊不是很了解。

只是知道存在一個數據庫鏡像監視器，里面存在鏡像的運行狀態，另外發現在鏡像數據庫的實例上存在一個Job，名為database mirroring monitor job.

不知道這個Job是用來監控鏡像的狀態的（運行失敗表示鏡像失敗？）還是用作其他用途？

---

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

Job checkes status, you can check certain things like redo queue size in perfmon.

Answer 2

Job checkes status, you can check certain things like redo queue size in perfmon.

Answer 3

Job checkes status, you can check certain things like redo queue size in perfmon.

所以Job也是可以用來check鏡像的運行狀態？

---

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

Answer 4

Sql does that.

Answer 5

sql server 自带 sqlmonitor 这个工具, 用它就可以了

参考下述链接及相关说明

http://technet.microsoft.com/zh-cn/library/ms365809(SQL.90).aspx

Answer 6

sql server 自带 sqlmonitor 这个工具, 用它就可以了

参考下述链接及相关说明

http://technet.microsoft.com/zh-cn/library/ms365809(SQL.90).aspx

老大問下，

在Windows 2003 Cluster上安裝了sqlserver 2000 Cluster。

當前服務器上的SQLServer服務停止了，就會轉移到新的服務器。還是說操作系統掛了，才會轉移當前的SQLServer服務？

---

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

Answer 7

Not really, will failover if lose heartbeat.

Answer 8

Not really, will failover if lose heartbeat.

心跳線應該僅僅是監控服務器是否可以被連接，那是否會偵測服務？

---

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

Answer 9

Failover happens when there's network problemor so, not only sql down.