Using Operations Manager to monitor Windows Server and SQL Server

In this experiment section, you can monitor your enterprise infrastructure by monitoring Windows Server, SQL Server, and using Operations Manager. Need to download here

1. System Center Management Pack for Windows Server Operating System Management Pack

2. System Center Management Pack for SQL Server Management Pack

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

One, monitoring Windows Server

1. Log in to the Operations Manager server and open the Operations Manager management Console

2. Click Manage, expand Device Management, right click Agent Management, select Import Management Pack

3. Select the Management Pack page, click Add, select Add from disk, click on Install, wait for installation and import complete

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. Click Monitoring, expand Microsoft Windows Server, click Windows Server Status to determine the "bj-gw-01" Server exists list

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. Expand Health monitoring., click Operating system Health, select the "bj-gw-01" server, and view the details of the "bj-gw-01" server

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. Click to view "bj-gw-01" Server disk health, currently only a piece of C drive

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. Click on the network adapter health of the "bj-gw-01" server to view information such as the device type, IP address, and MAC address of the server

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. Right click on "bj-gw-01" Server select Open, click Health Explorer

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. The Health Explorer page will display all Windows Server information

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 "/>

II. Monitoring SQL Server

1. After downloading the SQL Server Management Pack, import the Management Pack into the Operations Manager server as described in step 3 above

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. Log in to the DC server, open Server Manager, click Tools, select Active Directory Users and Computers

3. Right-click "SCOM" and select New user

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. Log in to the Operations Manager server and open the Operations Manager management Console

5. Click Manage, expand Run as configuration, right-click Account, select Create Run as Account

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. Specify the General properties page for the Run as account, type the display name sqlmonitoring, and click Next

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. Specify the Account Credentials page, type the user name and password, and click Next

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. Select the Distribution Security Options page, select a higher security level, click Create

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. Right-click the created account, select Properties

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. Run As Account Properties page, click Distribute, click Add, add SQL Server server, click OK

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. Tap Authoring, right-click Group, select Create New group

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. Type the friendly name and description page, type the new group name

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. Click New to create a Management Pack

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. Management Pack General Properties page, type the Management Pack name, click Next

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. Knowledge page, click Create

16. Type the friendly name and description page, confirm the information and click Next

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. Clear group members (optional) page, click Add/Remove Objects

18. Create a group to page, type the SQL Server computer name, click Search, click Add

19. After confirming the information is correct, click Next

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. Dynamically include the rules (optional) page, click Next

21. Add a Sub-group page (optional) page and click Next

22. From this group exclude objects (optional) page, click Create

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. Click Manage, expand Run as configuration, click Configuration file

24. Right-click sql Server Default Action Account Select attribute

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. General Properties page, click Next

26. Add the Run as Account page and click Add

27. Add a Run As Account page and select SQL monitoring

28. Click on "A selected class, group or object", click Select, select "Group", select 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. Add the Run as Account page and click Save

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. Right-click SQL Server Discovery accounts and SQL monitoring account Select Properties to add Run as

31. Click on the Monitor, click on the alarm, here will display the SQL Server error message, for example "Run as account does not exist on the target system or does not having enough perssions"

650) this.width=650; "height=" "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. Log in to SQL server "bj-sql-01" and use "lusrmgr.msc" to open Local users and groups

33. Double-click the Administrators group, click Add "sqlmonitoring" user, click OK

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. Wait a period of time to find the above error disappears

650) this.width=650; "height=" "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. Errors that still occur can be excluded due to the following alert detailed error hints and workarounds

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. Open the Operations Manager management console, click Monitoring, expand Microsoft SQL Server, expand SQL Server Database Engines, expand Databases, click Databasesto view the database status of SQL

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. Expand SQL Agent click SQLAgent state to view the SQL Agent status

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. Click Reports, and click Microsoft SQL Server (monitoring)

39. Right-click SQL Database Engine Counters, select Open

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. View count Information

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 "/>

This article is from the "Xu Ting blog" blog, make sure to keep this source http://ericxuting.blog.51cto.com/8995534/1570964

Using Operations Manager to monitor Windows Server and SQL Server