You create an operational policy for your virtual SQL Server instances, where only these settings differ from the main production policy. In this policy, you change the memory and CPU settings for specific objects. You then configure vRealize Operations Manager to send alerts to you when the performance degrades on your virtual SQL Servers.

About this task

In this procedure, you create a dedicated policy for a subset of virtual SQL Server objects, and change settings for the memory and CPU capacity for your virtual SQL Server instances. At this point in the scenario, your custom policy has only minor differences from the production policy.

The difference between the main production policy and your virtual SQL Server policy is in the overcommitment of compute resources. For the SQL Server policy, you do not overcommit compute resources. You have the SQL server policy inherit most of the settings from your overall production policy, except that you change the capacity settings that apply directly to the virtual SQL servers.

After you apply the main production policy to your entire production environment, you create the dedicated policy, have it inherit settings from the main policy, and make minor changes to settings in the dedicated policy to adjust the capacity levels for your virtual SQL Servers.

To create this policy, you choose a cluster that contains the data center and the vCenter Server that uses this policy. You make minor changes for all the objects, including the cluster, data center, host system, resource pools, and the virtual machine resource containers.

Prerequisites

Verify that the following conditions are met:

Procedure

  1. In the menu, click Administration, and then in the left pane click Policies.

    The Active Policies tab displays the current policies in effect.

  2. Click the Policy Library tab, and click the Add New Policy icon to add a custom policy.
  3. In the workspace navigation pane, click Getting Started and define the basic information for the policy.
    1. In the Name text box, enter vSphere Production Virtual SQL Servers.
    2. In the Description text box, enter Analyze capacity of virtual SQL Servers.
    3. To start with a base policy, select Default Policy from the Start with drop-down menu.
  4. View the policy configuration settings.
    1. In the policy workspace, click Select Base Policies.
    2. To view the policy configuration for virtual machine objects, click the Show changes for drop-down menu, click vCenter Adapter - Virtual Machine, and click the Show object type filter.

      The Virtual Machine policy configuration appears in the right pane.

    3. To view the inherited settings, in the Policy Preview pane, click Configuration inherited from base policy.
  5. In the workspace navigation, click Analysis Settings.
  6. In the workspace navigation, add the following object types to the list so that you can change their settings.
    1. Click the drop-down arrow, click vCenter Adapter - Cluster Compute Resource, and click the filter.
    2. Click the drop-down arrow, click vCenter Adapter - Data Center, and click the filter.
    3. Click the drop-down arrow, click vCenter Adapter - Host System, and click the filter.
    4. Click the drop-down arrow, click vCenter Adapter - Resource Pool, and click the filter.
    5. Click the drop-down arrow, click vCenter Adapter - Virtual Machine, and click the filter.

    The analysis settings for these object types appear in the right pane.

  7. On the Cluster Compute Resource bar, click the double arrows to expand the list of analysis settings.
  8. Locate Capacity Remaining Time Remaining and click the lock button to enable changes.
  9. In the resource table, set the overcommit for Memory Allocation value to 0 so that vRealize Operations Manager does not overcommit these objects for your SQL Server policy.
  10. In the resource table, set the overcommit ratio for CPU Allocation to 2 so that vRealize Operations Manager overcommits a 2:1 ratio for CPU allocation on each SQL Server.
  11. Repeat 7 through 10 for each object type that you added to the right pane.
  12. Click Save.

Results

You created a policy and made minor changes to settings so that vRealize Operations Manager can analyze and report on your SQL Server objects.

What to do next

Configure the alert definitions and symptom definitions for your SQL Server policy. You apply the policy to your SQL Server object groups.