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