使用Operations Manager監視Windows Server和SQL Server

標籤：operations manager、windows serve、sql server

在這個實驗章節中通過監控Windows Server、SQL Server、來瞭解使用Operations Manager監控企業基礎架構。這裡需要下載

1. System Center Management Pack for Windows Server Operating System管理組件

2. System Center Management Pack for SQL Server管理組件

http://down.51cto.com/data/1895686

一、 監視Windows Server

1. 登陸Operations Manager伺服器，開啟Operations Manager管理主控台

2. 點擊管理，展開裝置管理，右鍵代理管理，選擇匯入管理組件

3. 選擇管理組件頁面，點擊添加，選擇從磁碟中添加，點擊按安裝，等待安裝並匯入完成

650) this.width=650;" height="377" title="clip_image002" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image002" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928068uleG.jpg" border="0" />

4. 點擊監視，展開Microsoft Windows伺服器，點擊Windows Server Status確定“BJ-GW-01”伺服器存在列表當中

650) this.width=650;" height="396" title="clip_image004" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image004" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928068Zsui.jpg" border="0" />

5. 展開Health Monitoring.，點擊作業系統健全狀態，，選擇“BJ-GW-01”伺服器，查看“BJ-GW-01”伺服器的詳細資料

650) this.width=650;" height="173" title="clip_image006" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image006" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928068zlDe.jpg" border="0" />

650) this.width=650;" height="398" title="clip_image008" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image008" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928068mx7x.jpg" border="0" />

6. 點擊查看“BJ-GW-01”伺服器磁碟健全狀態，當前只有一塊C盤

650) this.width=650;" height="324" title="clip_image010" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image010" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928069UnIR.jpg" border="0" />

7. 點擊查看“BJ-GW-01”伺服器的網路介面卡健全狀態，可查看該伺服器的裝置類型、IP地址以及MAC地址等資訊

650) this.width=650;" height="454" title="clip_image012" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image012" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928069Yao9.jpg" border="0" />

8. 右鍵“BJ-GW-01”伺服器選擇開啟，點擊健全狀況總管

650) this.width=650;" height="183" title="clip_image014" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image014" src="http://img1.51cto.com/attachment/201411/2/8995534_141492806916ft.jpg" border="0" />

9. 健全狀況總管頁面將會顯示Windows Server所有資訊

650) this.width=650;" height="336" title="clip_image016" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image016" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928070mLdZ.jpg" border="0" />

二、 監視SQL server

1. 下載完SQL Server的管理組件之後，依照上述步驟3匯入管理組件到Operations Manager伺服器中

650) this.width=650;" height="399" title="clip_image018" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image018" src="http://img1.51cto.com/attachment/201411/2/8995534_14149280708qSm.jpg" border="0" />

2. 登陸DC伺服器，開啟伺服器管理員，點擊工具，選擇Active Directory使用者和電腦

3. 右鍵“SCOM”，選擇建立使用者

650) this.width=650;" height="496" title="clip_image019" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image019" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928070kAGX.png" border="0" />

4. 登陸Operations Manager伺服器，開啟Operations Manager管理主控台

5. 點擊管理，展開運行方式配置，右鍵賬戶，選擇建立運行方式賬戶

650) this.width=650;" height="375" title="clip_image021" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image021" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928070S3Tl.jpg" border="0" />

6. 指定運行方式賬戶的常規屬性頁面，鍵入顯示名稱SQLMonitoring，點擊下一步

650) this.width=650;" height="351" title="clip_image023" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image023" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928071yOid.jpg" border="0" />

7. 指定賬戶憑據頁面，鍵入使用者名稱和密碼，點擊下一步

650) this.width=650;" height="319" title="clip_image025" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image025" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928071nxUK.jpg" border="0" />

8. 選擇分發安全選項頁面，選擇安全層級較高，點擊建立

650) this.width=650;" height="288" title="clip_image027" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image027" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928071eLFG.jpg" border="0" />

9. 右鍵建立的賬戶，選擇屬性

650) this.width=650;" height="182" title="clip_image029" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image029" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928072PAa9.jpg" border="0" />

10.運行方式賬戶屬性頁面，點擊分發，點擊添加，添加SQL Server伺服器，點擊確定

650) this.width=650;" height="325" title="clip_image031" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image031" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928072bhVv.jpg" border="0" />

11.點擊創作，右鍵組，選擇建立新群組

650) this.width=650;" height="215" title="clip_image033" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image033" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928072buuc.jpg" border="0" />

12.鍵入易記名稱和描述頁面，鍵入新組名稱

650) this.width=650;" height="271" title="clip_image035" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image035" src="http://img1.51cto.com/attachment/201411/2/8995534_14149280720S4W.jpg" border="0" />

13.點擊建立，以建立管理組件

650) this.width=650;" height="123" title="clip_image037" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image037" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928072WqUr.jpg" border="0" />

14.管理組件常規屬性頁面，鍵入管理組件名稱，點擊下一步

650) this.width=650;" height="277" title="clip_image039" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image039" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928073SOSC.jpg" border="0" />

15.知識頁面，點擊建立

16.鍵入易記名稱和描述頁面，確認資訊無誤後點擊下一步

650) this.width=650;" height="331" title="clip_image041" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image041" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928073iNv8.jpg" border="0" />

17.明確群組成員（可選）頁面，點擊添加/刪除對象

18.建立組向頁面，鍵入SQL伺服器電腦名稱，點擊搜尋，點擊添加

19.確認資訊無誤後，點擊下一步

650) this.width=650;" height="307" title="clip_image043" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image043" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928073SnLH.jpg" border="0" />

20.動態包含規則（可選）頁面，點擊下一步

21.添加子組頁面（可選）頁面，點擊下一步

22.從此組排除對象（可選）頁面，點擊建立

650) this.width=650;" height="472" title="clip_image045" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image045" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928074dNbe.jpg" border="0" />

23.點擊管理，展開運行方式配置，點擊設定檔

24.右鍵SQL Server Default Action Account選擇屬性

650) this.width=650;" height="395" title="clip_image047" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image047" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928074pGzA.jpg" border="0" />

25.常規屬性頁面，點擊下一步

26.添加運行方式賬戶頁面，點擊添加

27.添加一個運行方式賬戶頁面，選擇SQL Monitoring

28.點擊“一個選定的類、組或對象”，點擊選擇，選擇“組”，選擇BJCloud SQL Servers

650) this.width=650;" height="295" title="clip_image048" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image048" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928075tW7V.png" border="0" />

29.添加運行方式賬戶頁面，點擊儲存

650) this.width=650;" height="236" title="clip_image050" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image050" src="http://img1.51cto.com/attachment/201411/2/8995534_14149280753LfZ.jpg" border="0" />

30.依次右鍵SQL Server Discovery Account和SQL Monitoring Account選擇屬性，添加運行方式賬戶

31.點擊監視，點擊警報，此時這裡會顯示SQL伺服器錯誤資訊，例如“Run as Account does not exist on the target system or does not have enough perssions”

650) this.width=650;" height="170" title="clip_image052" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image052" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928075v5Ld.jpg" border="0" />

32.登陸SQL伺服器“BJ-SQL-01”，使用“lusrmgr.msc”開啟本機使用者和組

33.雙擊administrators組，點擊添加“SQLMonitoring”使用者，點擊確定

650) this.width=650;" height="321" title="clip_image053" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image053" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928075GpvA.png" border="0" />

34.等待一段時間後，發現上述錯誤消失

650) this.width=650;" height="300" title="clip_image055" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image055" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928076fGQY.jpg" border="0" />

35.依然出現的錯誤可根據下面的警報詳細錯誤提示以及解決辦法排除相關錯誤

650) this.width=650;" height="396" title="clip_image057" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image057" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928076Khx3.jpg" border="0" />

36.開啟Operations Manager管理主控台，點擊監視，展開Microsoft SQL Server，展開SQL Server Database Engines，展開Databases，點擊Databases,查看SQL的Database狀態

650) this.width=650;" height="385" title="clip_image059" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image059" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928076JD5i.jpg" border="0" />

37.展開SQL Agent點擊SQL Agent State，查看SQL Agent狀態

650) this.width=650;" height="298" title="clip_image061" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image061" src="http://img1.51cto.com/attachment/201411/2/8995534_14149280767Rge.jpg" border="0" />

38.點擊報表，，點擊Microsoft SQL Server 2012(Monitoring)

39.右鍵SQL Database Engine Counters,選擇開啟

650) this.width=650;" height="385" title="clip_image063" style="margin:0px;border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image063" src="http://img1.51cto.com/attachment/201411/2/8995534_14149280777uWr.jpg" border="0" />

40.查看計數資訊

650) this.width=650;" height="388" title="clip_image065" style="border:0px;padding-top:0px;padding-right:0px;padding-left:0px;background-image:none;" alt="clip_image065" src="http://img1.51cto.com/attachment/201411/2/8995534_1414928077Fq21.jpg" border="0" />

本文出自 “徐庭的部落格” 部落格，請務必保留此出處http://ericxuting.blog.51cto.com/8995534/1570964

使用Operations Manager監視Windows Server和SQL Server