6.3

Table Of Contents
Procedure
1 Determine the operational requirements for your vSphere production environment.
In this scenario, the following requirements will be applied to the environment.
2 Develop a plan to create a custom operational policy that meets the requirements to analyze and
monitor the objects in your environment.
a Ensure that virtual SQL Servers continuously have adequate memory and CPU capacity.
b Ensure that you do not overcommit memory on your production virtual SQL Servers.
c Overcommit only a small percentage of the CPUs on your SQL Servers.
In this scenario, you set the value to 2. In some production environments, a typical value might be
4.
d Ensure that vRealize Operations Manager alerts you if the capacity of your virtual SQL Servers
drops below the dened thresholds.
e Set the Co-Stop value on your production virtual SQL Servers to an acceptable level so that the SQL
Servers do not experience delay because of CPU scheduling contention.
f Determine whether to overcommit compute resources for certain ratios.
After you plan the custom policy requirements, you can implement the policy.
What to do next
Create an operational policy for your virtual SQL Server instances.
Create a Policy to Meet vSphere Operational Needs
You will create an operational policy for your virtual SQL Server instances, where only these seings dier
from the main production policy. In this policy, you change the memory and CPU seings for specic
objects. You then congure vRealize Operations Manager to send alerts to you when the performance
degrades on your virtual SQL Servers.
In this procedure, you create a dedicated policy for a subset of virtual SQL Server objects, and change
seings for the memory and CPU capacity for your virtual SQL Server instances. At this point in the
scenario, your custom policy has only minor dierences from the production policy.
The dierence 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 seings from your overall production policy,
except that you change the capacity seings 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 seings from the main policy, and make minor changes to seings 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 will use
this policy. You make minor changes for all of 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:
n
You know the vSphere operational requirements. See “Determine the vSphere Operational
Requirements,” on page 87.
n
A default policy is in eect for your entire production environment of vSphere objects.
vRealize Operations Manager Customization and Administration Guide
88 VMware, Inc.