1 / 71

運用 SCOM2007 監控企業網路應用程式

Welcome. 運用 SCOM2007 監控企業網路應用程式. 以 SQL Server、IIS Server 為例. 運用 SCOM2007 監控 SQL Server 應用程式. Getting Started – Import Management Pack Optional Configuration SQL Server Management Pack 的安全性考量 SQL Server Management Pack 的剖析. Getting Started – Import Management Pack.

kenley
Download Presentation

運用 SCOM2007 監控企業網路應用程式

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Welcome 運用SCOM2007監控企業網路應用程式 以SQL Server、IIS Server為例

  2. 運用 SCOM2007 監控 SQL Server應用程式 • Getting Started – Import Management Pack • Optional Configuration • SQL Server Management Pack 的安全性考量 • SQL Server Management Pack 的剖析

  3. Getting Started – Import Management Pack 下載最新的 SQL Server Management Pack • 你可以在以下的網址找到 Microsoft SQL Server Management Pack -http://go.microsoft.com/fwlink/?LinkId=82105 • 你可以在以下的網址找到最新的文件 - http://go.microsoft.com/fwlink/?LinkId=85414

  4. Getting Started – Import Management Pack SQL Server Management Pack 新功能 • SCOM 2007的 Management Pack (.mp) 已經分割為 2 種檔案，分別為 Discovery 和 Monitoring。 • 在 Operations Console 中能夠顯示各個元件，例如資料庫、代理程式工作和電腦等。 • 在 Operations Console 中能夠顯示元件層級的各個元件狀態。 • 在 Operations Console 中能夠顯示各個元件層級之間的關係。 • SCOM 2007的 Management Pack 包含了三種新報表：SQL Broker Performance (for SQL Server 2005 only) 、SQL Database Space 以及SQL Server Database Counters。 • 可以直接從 Operations Console 中連結到報表。

  5. Getting Started – Import Management Pack 下載 SQL Server Management Pack 的相關檔案，包含: • Microsoft.SQLServer.Library.mp • Microsoft.SQLServer.2000.Discovery.mp • Microsoft.SQLServer.2000.Monitoring.mp • Microsoft.SQLServer.2005.Discovery.mp • Microsoft.SQLServer.2005.Monitoring.mp 建議: (作業系統的相關監測) • 至少監測執行 SQL Server 的 Windows Server Management Pack，例如磁碟空間、磁碟效能、記憶體使用率、網路卡流量以及 CPU 使用率等等。

  6. Getting Started – Import Management Pack Agentless 監控方式的支援 • 狀態監視 • Service discovery • Service availability • Database health • Space analysis • 健康狀態與可用性監視 • Database configuration monitoring • Service pack compliance • Long-running agent jobs • Block analysis • Replication monitoring • 伺服器效能門檻值監視 • 伺服器效能數據收集 • 事件收集

  7. Getting Started – Import Management Pack Agentless 不支援的監控項目 • 啟動、停止 SQL Server 的服務 • 啟動、停止 SQL Server Mail

  8. Getting Started – Import Management Pack 其他管理工具的需求 • 如果需要執行 SQL Management Studio 與 SQL Servr Profiler 的管理工具，你必須安裝 SQL Server Management Studio 以及 SQL Server Profiler在每一台所要執行的 Operations Manager 2007 電腦上。 注意： 在Operations Manager 2007 上進行探索與監視並不需要安裝 SQL Server Management Studio 以及 SQL Server Profiler。

  9. Demonstration Import Management Pack

  10. Optional Configuration Change the setting for automatic discovery 以 Override 變更自動探索方法。 • In the Authoring pane, expand Management Pack Objects, and then click Object Discoveries. • On the Operations Manager toolbar, click Scope, and filter the objects that appear in the details pane to include only SQL Server objects. • In the details pane, click the object type you want to change the setting for. • On the Operations Manager toolbar, click Overrides, click Override the Object Discovery, and then click either For all objects of type: <name of object type>, For a group, For a specific object of type: <name of object type>, or For all objects of another type. • In the OverridesProperties dialog box, click the Override box for the Enabled parameter you want to change. • Under Management Pack, click New to create an unsealed version of the Management Pack, and then click OK.

  11. Optional Configuration 需手動設定的監控項目 • Database configuration monitoring • DB File monitoring • DB File Group monitoring • Excluding databases from monitoring • Excluding DB engine instances from monitoring • Publication component monitoring • Service pack compliance • Subscription component monitoring

  12. SQL Server Management Pack 的安全性考量 SQL Management Pack two Run As Profiles • The SQL Server Discovery Account • The SQL Server MonitoringAccount 系統預設使用SCOM 2007的Action Account，如果需要個別設定則所需權限如下： Monitoring 最低需有DBO權限 Discovery 最低權限需求如下表

  13. SQL Server Management Pack 的安全性考量

  14. SQL Server Management Pack 的安全性考量 SQL Management Pack Groups • SQL 2000 Computers • SQL 2000 DB Engine Group • SQL 2005 Computers • SQL 2005 DB Engine Group • SQL 2005 Replication Computers • SQL Computers • SQL Instances • SQL Server 2000 Databases

  15. Demonstration Change Run As Profiles

  16. SQL Server Management Pack 的剖析 • Objects Discovered by the SQL Server Management Pack • How Health Rolls Up • Key Monitoring Scenarios • Viewing Information

  17. SQL Server Management Pack 的剖析 Objects Discovered by the SQL Server Management Pack

  18. SQL Server Management Pack 的剖析 Objects Discovered by the SQL Server Management Pack

  19. SQL Server Management Pack 的剖析 Change the setting for automatic discovery 以啟用 SQL 2005 Agent Job 的自動探索為例。 • In the Authoring pane, expand Management Pack Objects, and then click Object Discoveries. • On the Operations Manager toolbar, click Scope, and then filter the objects that appear in the details pane to include only SQL Server objects. • In the Operations Manager toolbar, use the Scope button to filter the list of objects, and then click SQL Server Agent Job. • On the Operations Manager toolbar, click Overrides, click Override the Object Discovery, and then click For all objects of type: SQL 2005 Agent, For a group. • In the OverridesProperties dialog box, click the Override box for the Enabled parameter. • Under Management Pack, click New to create an unsealed version of the Management Pack, and then click OK.

  20. Demonstration Change the setting for automatic discovery • 以啟用 SQL 2005 Agent Job 的自動探索為例。

  21. SQL Server Management Pack 的剖析 How Health Rolls Up • Microsoft SQL Server 2005 各元件之間的關係

  22. SQL Server Management Pack 的剖析 How Health Rolls Up • Microsoft SQL Server 2000 各元件之間的關係

  23. Demonstration How Health Rolls Up • Display SQL 2005 Diagram view

  24. SQL Server Management Pack 的剖析 Key Monitoring Scenarios

  25. SQL Server Management Pack 的剖析 Key Monitoring Scenarios

  26. SQL Server Management Pack 的剖析 Key Monitoring Scenarios

  27. SQL Server Management Pack 的剖析 Key Monitoring Scenarios

  28. SQL Server Management Pack 的剖析 Viewing Information • Active Alert – 彙集顯示所有未關閉的警報 • Computers – 顯示所有執行 SQL Server 電腦的狀態 • Task Status -顯示所有可用 Task 的狀態 • Database • Health Monitoring • Performance • Replication • Server Roles • SQL 2000 • SQL 2005 • SQL Agent

  29. SQL Server Management Pack 的剖析 Database Views

  30. SQL Server Management Pack 的剖析 Health Monitoring Views

  31. SQL Server Management Pack 的剖析 Performance Views

  32. SQL Server Management Pack 的剖析 Replication Views

  33. SQL Server Management Pack 的剖析 Server Roles Views

  34. SQL Server Management Pack 的剖析 SQL Agent Views

  35. SQL Server Management Pack 的剖析 Reports 你可以使用SQL Server Management Pack提供的報表來做趨勢追蹤，期間可以是日、週或月。所提供的報表有： • Capacity Information Reports • Operations Information Reports • Trend Information Reports

  36. SQL Server Management Pack 的剖析 Capacity Information Reports

  37. SQL Server Management Pack 的剖析 Operations Information Reports

  38. SQL Server Management Pack 的剖析 Trend Information Reports

  39. Demonstration Change the setting for automatic discovery • Create a test database (TestDB) • 啟用 DB File Group 的自動探索 • Action – Set Database Offline • Views • Reset the database state

  40. For More Information about SQL Server • SQl Server 技術支援中心http://www.microsoft.com/taiwan/technet/prodtechnol/sql/default.mspx • Integration Services：效能微調技巧 http://www.microsoft.com/taiwan/technet/prodtechnol/sql/2005/ssisperf.mspx • SQl Server 支援服務中心 http://support.microsoft.com/ph/2855 • SQl Server 開發人員中心 http://www.microsoft.com/taiwan/msdn/sql/default.mspx

  41. Getting Started – Import Management Pack Configuration IIS Logging IIS Server Management Pack 的安全性考量 IIS Server Management Pack 的剖析 運用 SCOM2007 監控 IIS Server應用程式

  42. Getting Started – Import Management Pack 下載最新的 IIS Server Management Pack • 你可以在以下的網址找到 Microsoft IIS Server Management Pack -http://go.microsoft.com/fwlink/?LinkId=82105 • 你可以在以下的網址找到最新的文件 - http://go.microsoft.com/fwlink/?LinkId=83259

  43. Getting Started – Import Management Pack IIS Server Management Pack 新功能 能夠監控： • Web site • FTP site • NNTP virtual servers • SMTP virtual servers 新功能： • 新增許多的 task，能夠幫助您快速處理解決問題 • 監控項目的知識庫中能連結到相關的 Views與 task ，能夠幫助您快速處理解決問題 • 收集各式基準效能數據，幫助您了解 IIS 效能狀態 • 新的報表讓您有效的分析歷史趨勢資料

  44. Getting Started – Import Management Pack 下載 IIS Server Management Pack 的相關檔案，包含: • Microsoft.Windows.InternetInformationServices.CommonLibrary.MP • Microsoft.Windows.InternetInformationServices.2000.MP • Microsoft.Windows.InternetInformationServices.2003.MP 建議: (服務系統的相關設備監測) • IIS Server 作業系統的監控 • Web 服務的後端資料庫 • 相關應用程式的監控 • 網路設備的監控 • …等等

  45. Getting Started – Import Management Pack Agent-Managed 必須安裝 SCOM 2007 Agent 才能提供所有的監控功能 Agentless Managed Windows Server Internet Information Services 2000 and 2003 Management Packs for Operations Manager 2007 不支援 agentless 方式的監控。

  46. Demonstration Import Management Pack

  47. Configuration IIS Logging 啟用 IIS 的 Log 來增強監控能力 包含的 site 與 virtual server • FTP site • Web site 系統預設會啟用 FTP 與 Web site 的 log，Format為W3C Extended Log，但 SMTP與 NNTP virtual servers 預設未啟用，必須手動起用。 • SMTP virtual servers • NNTP virtual servers 啟用 IIS 的 Log 步驟 1. In Internet Information Services Manager, double-click the local computer. 2. Right-click the SMTP Virtual Server or NNTP Virtual Server folder for which you want to enable logging, and then click Properties. 3. On the General tab, select Enable logging. 4. From the Active log format drop-down list, select W3C Extended Log File format, and then click OK.

  48. Configuration IIS Logging Windows Server 2000 上的IIS Logging相關設定 在 Windows Server 2000 上，IIS Web site 的 Logging 是包含了 Process Accounting extensions，這會產生錯誤”An unknown token name (s-event) was encountered.”因此必須關閉 Process Accounting extensions 的 logging 停用 Process Accounting extensions 步驟 1. In Internet Services Manager, double-click the local computer. 2. Right-click the Default Web Site, and then click Properties. 3. On the Web Site tab, select Enable logging. 4. From the Active log format drop-down list, select W3C Extended Log File Format, and then click Properties. 5. Click the Extended Properties tab. 6. In the Extended Logging Options list box, clear Process Accounting, and then click OK.

  49. IIS Server Management Pack 的安全性考量 IIS Management Pack 預設使用 agent action account • 使用低權限帳號時，必須符合以下條件： • 必須是 local user group 的成員 • 必須是 local Performance Monitor user group 的成員 • 必須有登入本機的權限 • 注意： • 低權限帳號不支援監控 IIS 2000 • Domain 帳號密碼一但變更，低權限帳號密碼必須保持與之一致 • 以下對於 IIS 2003 的 MP 的 tasks 需要更高的權限才能執行

  50. SQL Server Management Pack 的安全性考量 IIS Management Pack Groups

More Related