You create an object group type to categorize your virtual SQL Server machines. Then you create an object group that contains your virtual SQL Server machines, and apply your custom policy to this group of SQL Server virtual machine objects.

About this task

To have vRealize Operations Manager analyze your SQL Server machines according to the performance criteria in your custom policy, you must apply the custom policy to your group of SQL Server objects.

For this scenario, you create a static object group that contains your SQL Server virtual machines. In your own environment, you might need to create a dynamic object group so that vRealize Operations Manager discovers new SQL Server instances that become available to analyze and report on.

Prerequisites

You configured the custom policy settings for your virtual SQL Server machines. See Configure the Custom Policy Settings to Analyze and Report on vSphere Objects.

Procedure

  1. To create a group type for your virtual SQL Servers, click Content in the left pane, and click Group Types.
  2. Click the plus sign to add a new object group type, and type vSphere Production Virtual Machines.

    You use this group type to categorize your SQL Server virtual machines for analysis.

  3. Click Environment in the left pane, and click Custom Groups.

    A folder that corresponds to the group type that you just created appears in the list.

  4. Click the folder named vSphere Production Virtual Machines, and click the plus sign to add a new object group.
  5. In the New Group dialog box, add your SQL Server virtual machines.
    1. In the Name text box, type vSphere Production SQL Server Virtual Machines.
    2. From the Group Type drop-down menu, select vSphere Production Virtual Machines.
    3. From the Policy drop-down menu, select vSphere Production Virtual SQL Servers.
    4. In the object type drop-down menu in the Define Membership Criteria pane, expand vCenter Adapter and click Virtual Machine.
  6. Click OK to save your object group.

    After vRealize Operations Manager collects data, the Groups tab displays the status for the health, risk, and efficiency of the virtual machines in the object group.

Results

You created an object type and object group to have vRealize Operations Manager analyze and report on the status of your SQL Server virtual machines.

What to do next

Create a custom dashboard so that you can view the status of your virtual SQL Servers and address problems that occur. See Using Dashboards.

Configure a modeling project that includes capacity planning scenarios for your production virtual SQL Servers to have vRealize Operations Manager monitor the capacity trends on these objects and notify you 60 days before your virtual SQL Servers experience capacity problems. See Planning the Capacity for Your Managed Environment Using vRealize Operations Manager.

Have vRealize Operations Manager report on the CPU use and memory use of your virtual machines on a regular schedule, and send the reports to you.