Skip to content

Latest commit

 

History

History
38 lines (34 loc) · 2.72 KB

04b-collection-rule.md

File metadata and controls

38 lines (34 loc) · 2.72 KB
Raw

Chapter: Monitoring with Operations Manager

Requirements

For this exercise to succeed, you need to have the SQL Management Pack imported. This has been covered in exercise 03.

Creating a Performance Collection Rule

As Windows Performance collection rules are most often used, this section discusses the steps required to gather a performance counter not collected by OpsMgr by default. For this example, you will be collecting the % Processor Time counter for the SQL Server database engine process (sqlservr.exe).

  1. In the Operations console, open the Authoring workspace.
  2. Right-click Rules and select Create New Rule.
  3. Select Collection Rules -> Performance Based -> Windows Performance as the rule type.
  4. Select the Sample Management Pack you previously created as a target for the rule.
  5. Click Next to continue.
  6. Give the rule this name: SQL Server process CPU Time.
  7. Under rule target, click Select.
  8. Click View all targets.
  9. Target the most specific existing class for this example, which is the MSSQL on Windows: DB Enginge
  10. Click Next.
  11. Use the Select button to open the Select Performance Counter window.
  12. Object: Process (not processor).
  13. Select counter from the list: % Processor Time
  14. Select instance from list: sqlservr process (if this instance does not appear, choose any other and type sqlservr in the Instance variable after selecting OK).
  15. At the Performance Object, Counter, and Instance page, change the collection interval to 1 minute.
  16. Note. This is not a best-practice, but in class we don't want to wait too long for output.
  17. Click Next to continue to the final page of the wizard.
  18. The last page of the wizard allows you to configure optimized collections. Optimized collection reduces the amount of disk space a performance counter collection uses in the data warehouse. Leave it unselected.
  19. Click Create to create the performance collection rule.
  20. Confirm that the changed management pack is downloaded by the agent (verify the 1201 and 1210 events in the event log on the client computer).

Viewing the results of a collection rule

  1. Open the My Workspace pane. Right click Favorite Views and select New -> Performance View.
  2. Enter the following name: SQL Server process performance.
  3. Under Select conditions, click collected by specific rules.
  4. Under criteria descritpion, click the blue specific hyperlink.
  5. In the list that appears, select the rule with the name you specified previously: SQL Server process CPU Time.
  6. Click Ok to close the wizard.
  7. The new view should contain the performance counter. Select it to display a graph.
  8. It might take several minutes for data to arrive.