none
SCOM 2007 管理 SQL RRS feed

解答

  • Hi

     

    SCOM 2007 可以監控 SQL 2000

    只要 Import SQL 2000 MP 就好。

     

    但是你可能會發現 SQL 2000 的 Instance 會顯示 Not Monitored

    您需要執行以下步驟配置 Override

     

    CAUSE

    ============================

    "SQL 2000 DB Engine Connection Check" monitor is disabled by default.

    Use overrides to enable the connection Check for selected instances

     

    RESOLUTION

    ============================

    How-to Steps:

    1. On the SCOM Operator Console

    2. Go to "Authoring"

    3. Under "Management Pack Objects", choose "Monitors"

    4. Locate "SQL 2000 DB ENGINE"

    5. Under "SQL 2000 DB ENGINE", expand the "Entity Health"

    6. Expand "Availability"

        |-- "SQL Instance Connection Test"

        |+ "AD Helper Health Rollup"

                |-- "AD Helper Service Busy"

                |-- "AD Helper Service Health"

                |-- "AD Helper Service Started"

        |+ "SQL DB Engine Service Health Rollup"

                |-- "SQL Service State"

                |-- "SQL service terminate unexpectedly"

     


    7. Set override on SQL Instance Connection Test Monitor

     

    For all object of type : SQL 2000 DB Engine

    ============================

    set Enabled = TRUE

    set Generate Alert = TRUE(Default)

    set Auto-Resolve Alert = TRUE(Default)

    set Alert Priority = Medium(Default)

    set Alert On State (Default)

    set Alert Serverity (Default)

    ============================

     

    8. Perform the same with below two aggregate monitor as well

    - AD Helper Health Rollup

    - SQL DB Engine Service Health Rollup

     

    HTH

    Marty

    2008年3月27日 上午 08:12
  • Hi,

     

    如Marty兄所言,SCOM 2007是可以管理SQL 2000的。基本上,只要是微軟家的產品都可以受SCOM 2007管理,最重要的是,管理組件是free的。如果需要使用SCOM 2007管理異質平台,在預算不多的情況下,可以透過SNMP/Syslog這種公開的溝通協定跟Non-Windows被控端溝通。如果預算充足,也可以買國外廠商為SCOM 2007量身定作的異質平台監控加值功能。

     

    另一個問題,"無網域環境可以監控嗎?"。首先要確認的是,(1)貴公司的環境中目前並沒有Active Directory,或者是說(2)要監控的SQL Server 2000並不在網域內,這二種情況的處理方式是不一樣的。

     

    (1) 公司沒有Active Directory:就我們能找到的文件與實際經驗,SCOM 2007一定要存在於Active Directory架構中(這一點如有說錯,還請微軟大大們指正)。但是MOM 2005就不受限於此限制。

    (2) SQL 2000不在網域內:這種狀況就好處理,只要使用certificate based authentication就能解決。

     

    以上供您參考,謝謝。

     

    Regards,

    Rico

    2008年3月27日 下午 02:20
  • Hi,

     

    Rico 兄說的沒錯,OpsMgr2007 需要 AD/DNS 的環境來進行監控 (More of a prerequisite than limitation, as it can monitor workgroup servers)

     

    可以參考:

    About Operations Manager 2007 Environmental Prerequisites http://technet.microsoft.com/en-us/library/bb432134.aspx

    "... The other set consists of those items that are outside the scope of the Prerequisite Viewer, such as the Active Directory domain or forest functional level, or the availability of a certification authority (CA) to issue the certificates that are necessary for deploying agents and gateway servers across trust boundaries..."

     

    Developing an Operations Manager 2007 Implementation Plan http://technet.microsoft.com/en-us/library/bb735401.aspx

    "... Start your lab design by identifying the critical components in your production environment that support the monitoring environment, such as Active Directory and DNS..."

     

    HTH
    Marty

    2008年3月28日 上午 12:47

所有回覆

  • 1.SCCM所管理的,是平台,也就是作業系統,所以是否支援SQL得看底層的OS。
    2.Site server需為網域中的一員,client端可以不用。
     
    2008年3月26日 下午 12:20
  • Hi

     

    SCOM 2007 可以監控 SQL 2000

    只要 Import SQL 2000 MP 就好。

     

    但是你可能會發現 SQL 2000 的 Instance 會顯示 Not Monitored

    您需要執行以下步驟配置 Override

     

    CAUSE

    ============================

    "SQL 2000 DB Engine Connection Check" monitor is disabled by default.

    Use overrides to enable the connection Check for selected instances

     

    RESOLUTION

    ============================

    How-to Steps:

    1. On the SCOM Operator Console

    2. Go to "Authoring"

    3. Under "Management Pack Objects", choose "Monitors"

    4. Locate "SQL 2000 DB ENGINE"

    5. Under "SQL 2000 DB ENGINE", expand the "Entity Health"

    6. Expand "Availability"

        |-- "SQL Instance Connection Test"

        |+ "AD Helper Health Rollup"

                |-- "AD Helper Service Busy"

                |-- "AD Helper Service Health"

                |-- "AD Helper Service Started"

        |+ "SQL DB Engine Service Health Rollup"

                |-- "SQL Service State"

                |-- "SQL service terminate unexpectedly"

     


    7. Set override on SQL Instance Connection Test Monitor

     

    For all object of type : SQL 2000 DB Engine

    ============================

    set Enabled = TRUE

    set Generate Alert = TRUE(Default)

    set Auto-Resolve Alert = TRUE(Default)

    set Alert Priority = Medium(Default)

    set Alert On State (Default)

    set Alert Serverity (Default)

    ============================

     

    8. Perform the same with below two aggregate monitor as well

    - AD Helper Health Rollup

    - SQL DB Engine Service Health Rollup

     

    HTH

    Marty

    2008年3月27日 上午 08:12
  • Hi,

     

    如Marty兄所言,SCOM 2007是可以管理SQL 2000的。基本上,只要是微軟家的產品都可以受SCOM 2007管理,最重要的是,管理組件是free的。如果需要使用SCOM 2007管理異質平台,在預算不多的情況下,可以透過SNMP/Syslog這種公開的溝通協定跟Non-Windows被控端溝通。如果預算充足,也可以買國外廠商為SCOM 2007量身定作的異質平台監控加值功能。

     

    另一個問題,"無網域環境可以監控嗎?"。首先要確認的是,(1)貴公司的環境中目前並沒有Active Directory,或者是說(2)要監控的SQL Server 2000並不在網域內,這二種情況的處理方式是不一樣的。

     

    (1) 公司沒有Active Directory:就我們能找到的文件與實際經驗,SCOM 2007一定要存在於Active Directory架構中(這一點如有說錯,還請微軟大大們指正)。但是MOM 2005就不受限於此限制。

    (2) SQL 2000不在網域內:這種狀況就好處理,只要使用certificate based authentication就能解決。

     

    以上供您參考,謝謝。

     

    Regards,

    Rico

    2008年3月27日 下午 02:20
  •  

    感謝以上各位的解說!!受益匪淺,先著手測試看看!

    2008年3月27日 下午 04:07
  • Hi,

     

    Rico 兄說的沒錯,OpsMgr2007 需要 AD/DNS 的環境來進行監控 (More of a prerequisite than limitation, as it can monitor workgroup servers)

     

    可以參考:

    About Operations Manager 2007 Environmental Prerequisites http://technet.microsoft.com/en-us/library/bb432134.aspx

    "... The other set consists of those items that are outside the scope of the Prerequisite Viewer, such as the Active Directory domain or forest functional level, or the availability of a certification authority (CA) to issue the certificates that are necessary for deploying agents and gateway servers across trust boundaries..."

     

    Developing an Operations Manager 2007 Implementation Plan http://technet.microsoft.com/en-us/library/bb735401.aspx

    "... Start your lab design by identifying the critical components in your production environment that support the monitoring environment, such as Active Directory and DNS..."

     

    HTH
    Marty

    2008年3月28日 上午 12:47