slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
運用 SCOM2007 監控企業網路應用程式 PowerPoint Presentation
Download Presentation
運用 SCOM2007 監控企業網路應用程式

Loading in 2 Seconds...

play fullscreen
1 / 71

運用 SCOM2007 監控企業網路應用程式 - PowerPoint PPT Presentation


  • 154 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about '運用 SCOM2007 監控企業網路應用程式' - kenley


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

Welcome

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

以SQL Server、IIS Server為例

slide2

運用 SCOM2007 監控 SQL Server應用程式

  • Getting Started – Import Management Pack
  • Optional Configuration
  • SQL Server Management Pack 的安全性考量
  • SQL Server Management Pack 的剖析
slide3

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
slide4

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 中連結到報表。
slide5

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 使用率等等。
slide6

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
  • 伺服器效能門檻值監視
  • 伺服器效能數據收集
  • 事件收集
slide7

Getting Started – Import Management Pack

Agentless 不支援的監控項目

  • 啟動、停止 SQL Server 的服務
  • 啟動、停止 SQL Server Mail
slide8

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。

slide9

Demonstration

Import Management Pack

slide10

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.
slide11

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
slide12

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 最低權限需求如下表

slide14

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
slide15

Demonstration

Change Run As Profiles

slide16

SQL Server Management Pack 的剖析

  • Objects Discovered by the SQL Server Management Pack
  • How Health Rolls Up
  • Key Monitoring Scenarios
  • Viewing Information
slide17

SQL Server Management Pack 的剖析

Objects Discovered by the SQL Server Management Pack

slide18

SQL Server Management Pack 的剖析

Objects Discovered by the SQL Server Management Pack

slide19

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.
slide20

Demonstration

Change the setting for automatic discovery

  • 以啟用 SQL 2005 Agent Job 的自動探索為例。
slide21

SQL Server Management Pack 的剖析

How Health Rolls Up

  • Microsoft SQL Server 2005 各元件之間的關係
slide22

SQL Server Management Pack 的剖析

How Health Rolls Up

  • Microsoft SQL Server 2000 各元件之間的關係
slide23

Demonstration

How Health Rolls Up

  • Display SQL 2005 Diagram view
slide24

SQL Server Management Pack 的剖析

Key Monitoring Scenarios

slide25

SQL Server Management Pack 的剖析

Key Monitoring Scenarios

slide26

SQL Server Management Pack 的剖析

Key Monitoring Scenarios

slide27

SQL Server Management Pack 的剖析

Key Monitoring Scenarios

slide28

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
slide35

SQL Server Management Pack 的剖析

Reports

你可以使用SQL Server Management Pack提供的報表來做趨勢追蹤,期間可以是日、週或月。所提供的報表有:

  • Capacity Information Reports
  • Operations Information Reports
  • Trend Information Reports
slide36

SQL Server Management Pack 的剖析

Capacity Information Reports

slide37

SQL Server Management Pack 的剖析

Operations Information Reports

slide38

SQL Server Management Pack 的剖析

Trend Information Reports

slide39

Demonstration

Change the setting for automatic discovery

  • Create a test database (TestDB)
  • 啟用 DB File Group 的自動探索
  • Action – Set Database Offline
  • Views
  • Reset the database state
for more information about sql server
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

slide41
Getting Started – Import Management Pack

Configuration IIS Logging

IIS Server Management Pack 的安全性考量

IIS Server Management Pack 的剖析

運用 SCOM2007 監控 IIS Server應用程式

slide42

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
slide43

Getting Started – Import Management Pack

IIS Server Management Pack 新功能

能夠監控:

  • Web site
  • FTP site
  • NNTP virtual servers
  • SMTP virtual servers

新功能:

  • 新增許多的 task,能夠幫助您快速處理解決問題
  • 監控項目的知識庫中能連結到相關的 Views與 task ,能夠幫助您快速處理解決問題
  • 收集各式基準效能數據,幫助您了解 IIS 效能狀態
  • 新的報表讓您有效的分析歷史趨勢資料
slide44

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 服務的後端資料庫
  • 相關應用程式的監控
  • 網路設備的監控
  • …等等
slide45

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 方式的監控。

slide46

Demonstration

Import Management Pack

slide47

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.

slide48

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.

slide49

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 需要更高的權限才能執行
slide51

IIS Server Management Pack 的剖析

  • Objects Discovered by the SQL Server Management Pack
  • How Health Rolls Up
  • Key Monitoring Scenarios
  • Viewing Information
slide52

IIS Server Management Pack 的剖析

Objects Discovered by the IIS Server Management Pack

slide53

IIS Server Management Pack 的剖析

How Health Rolls Up

  • Microsoft IIS Server 各元件之間的關係
slide54

Demonstration

How Health Rolls Up

  • Display IIS Server Diagram view
slide55

IIS Server Management Pack 的剖析

Key Monitoring Scenarios -

Is My IIS Web-Base Application Healthy?

  • To create a distributed application definition for a Web-based application
  • 1. Open the Operations Manager 2007 Operations Console.
  • 2. In the navigation pane, click Authoring.
  • 3. In the Authoring pane, right-click Distributed Applications, and then click Create new distributed application.
  • 4. When the Distributed Application Designer displays, do the following:
  • a. Type a Name, such as LOBWebApp1.
  • b. Select the Line of Business Web Application in the Template list.
  • c. Save the Distributed Application Definition to a Management Pack, such as LOBWebApp1MP.
  • d. Click OK.
  • 5. On the Distributed Application Designer menu, click Save.
  • To add Web sites and databases to the distributed application definition
  • 1. In the navigation pane of the Distributed Application Designer, click Web Site.
  • 2. Select the Web sites for this application, and then drag them to the LOBWebApp1 Web Application Web Sites
  • box.
  • 3. In the navigation pane, click Database.
  • 4. Select the databases for this application, and then drag them to the LOBWebApp1 Web Application Database
  • box.
  • 5. On the Distributed Application Designer menu, click Save.
slide56

IIS Server Management Pack 的剖析

Key Monitoring Scenarios -

Are My IIS 2003 Web,FTP,SMTP,and NNTP Server Available?

  • Are service-base monitors.
  • Set the state of the server to critical if the service is unavailable.
  • Raise an alert with a name similar to the name of the monitor.
  • The product knowledge for the monitors provides an inline task to start the respective
  • server service. The following monitors verify the availability of Web, FTP, SMTP, and
  • NNTP servers.
slide57

IIS Server Management Pack 的剖析

Key Monitoring Scenarios -

How Are My IIS 2003 Web Servers Performing?

slide58

IIS Server Management Pack 的剖析

Key Monitoring Scenarios -

How Are the Operating System of My IIS Sevrers Performing?

slide59

IIS Server Management Pack 的剖析

Key Monitoring Scenarios -

Are My IIS 2003 Web,FTP,SMTP,and NNTP Sites and Virtual Servers Available?

  • Set the state of the site or virtual server to critical if it is unavailable.
  • Raise a low-priority critical severity alert with a name similar to the name of the
  • monitor.
  • Provide product knowledge that provides an inline task to start the respective site or
  • virtual server.
slide60

IIS Server Management Pack 的剖析

Key Monitoring Scenarios -

Are My IIS 2003 Sites Configured Properly?

  • Configuration Monitors for IIS 2003 Web Sites
  • Are event-based.
  • Set the state of the site to warning if the event is raised.
  • Raise a critical alert of a similar name.
  • Deactivate the site.
slide61

IIS Server Management Pack 的剖析

Key Monitoring Scenarios -

Are My IIS 2003 Sites Configured Properly? -續-

  • Configuration Rules for IIS 2003 Web Sites
  • Are event-based.
  • Collect the event data.
  • Do no raise alerts.

Views

slide62

IIS Server Management Pack 的剖析

Key Monitoring Scenarios -

How Are My Mission-Critical Site and Virtual Servers Performing?

Performance Rules for IIS 2003 Web Site

slide63

IIS Server Management Pack 的剖析

Key Monitoring Scenarios -

Are My IIS 2003 Application Pools Available and Configured Properly?

  • Availability Monitor for IIS Application Pools
  • Sets the state of the application pool to Healthy if the application
  • pool is running.
  • Sets the state of the application pool to Critical if the application pool is not
  • running.
  • Raises a critical alert of a similar name if the state of
  • application pool was set to Critical.
  • Configuration Monitors for IIS Application Pools
  • Are event-based.
  • Set the health state of the application pool to warning if the event
  • was raised.
  • Generate an alert with a name similar to the name of the event was
  • raised.
slide64

IIS Server Management Pack 的剖析

Key Monitoring Scenarios -

Are My IIS 2003 Application Pools Available and Configured Properly? –續-

Configuration Monitorsfor IIS Application Pools

slide65

IIS Server Management Pack 的剖析

Key Monitoring Scenarios -

Are My IIS 2003 Application Pools Available and Configured Properly? –續-

  • Configuration Rules for IIS Application Pools
  • Are event-based.
  • Do not raise alerts.
slide66

IIS Server Management Pack 的剖析

Viewing Information

  • Active Alert
  • All Performance Data
  • Application Pool State
  • FTP Site State
  • IIS Computer State
  • IIS Role State
  • Task Status
  • Web Site State
slide68

IIS Server Management Pack 的剖析

Reports

你可以使用IIS Server Management Pack提供的報表來了解特定期間的趨勢狀態。所提供的報表有:

  • All IIS Server Application Pools
  • All IIS Servers
  • Application Pool Failure
slide69

Demonstration

錄製使用者存取網頁行為模型,並加以監控。

technet
在何處取得TechNet相關資訊?
  • 訂閱 TechNet資訊技術人快訊http://www.microsoft.com/taiwan/technet/flash/
  • 訂閱 TechNet Plus

http://www.microsoft.com/taiwan/technet/

  • 參加TechNet的活動http://www.microsoft.com/taiwan/technet/
  • 下載 TechNet 研討會簡報與錄影檔http://www.microsoft.com/taiwan/technet/webcast/