![Page 1: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/1.jpg)
Table of ContentsLab Overview - Components ............................................................................................. 2
Infrastructure Components - vCenter...................................................................... 3Infrastructure Components - VMware ESXi hosts .................................................... 4Infrastructure Components - Virtual Machines ........................................................ 5Application Components - Microsoft SQL server...................................................... 6Infrastructure Components - VMware App HA......................................................... 7Infrastructure Components - VMware vCenter Operations Manager .....................10Business Critical Applications - About this Lab...................................................... 11
Module 1: High Availability for Business Critical Applications .........................................13M1.1 - Preparation................................................................................................. 14M1.2 - Test Policy................................................................................................... 24M1.3 - Summary.................................................................................................... 30
Module 2: CPU Contention Situation on the MS SQL Virtual Machine (CPU Limit in VirtualMachine Settings) ........................................................................................................... 31
M2.1 - Preparation................................................................................................. 32M2.2 - Analysis ...................................................................................................... 37M2.3 - Remediation ............................................................................................... 41M2.4 - Summary.................................................................................................... 46
Module 3: Memory Contention Situation on the MS SQL Virtual Machine (Memory Limit inVirtual Machine Settings) ................................................................................................ 47
M3.1 - Preparation................................................................................................. 48M3.2 - Analysis ...................................................................................................... 53M3.3 - Remediation ............................................................................................... 57M3.4 - Summary.................................................................................................... 58
HOL-SDC-1317
Page 1VMware Beta Program CONFIDENTIAL
![Page 2: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/2.jpg)
Lab Overview -Components
HOL-SDC-1317
Page 2VMware Beta Program CONFIDENTIAL
![Page 3: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/3.jpg)
Infrastructure Components - vCenterIn this lab vCenter manages a 3-node vSphere Cluster and several VMs
Overview of the vCenter Environment Used for the vCloudSuite BCA Lab
This screenshot shows that you are using a relatively small environment for the lab.vCenter Server is built using the appliance.
HOL-SDC-1317
Page 3VMware Beta Program CONFIDENTIAL
![Page 4: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/4.jpg)
Infrastructure Components - VMwareESXi hostsOverview of VMware ESXi™ resources used.
vSphere Hosts
The lab consists of three ESXi servers.
HOL-SDC-1317
Page 4VMware Beta Program CONFIDENTIAL
![Page 5: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/5.jpg)
Infrastructure Components - VirtualMachinesListing of All Virtual Machines Contained in the Lab Setup
The lab is built on the following four virtual machines:
1 Microsoft Windows 2008 R2 running SQL Server 2008R2.
2 SLES 11 virtual machines running tc Server 2.8.
1 SLES 11 virtual machines running htproxy as an HTTP load balancer.
HOL-SDC-1317
Page 5VMware Beta Program CONFIDENTIAL
![Page 6: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/6.jpg)
Application Components - MicrosoftSQL serverSQL Server Management Studio
This lab uses Microsoft SQL Server 2008 R2 to host the databases that run the SpringTrader application.
HOL-SDC-1317
Page 6VMware Beta Program CONFIDENTIAL
![Page 7: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/7.jpg)
Infrastructure Components - VMwareApp HA
HOL-SDC-1317
Page 7VMware Beta Program CONFIDENTIAL
![Page 8: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/8.jpg)
vSphere App HA
Helps Minimize Downtime from Application Failure
vSphere App HA is a new feature that complements the functionality of VMwarevSphere® High Availability with application-level monitoring and automatedremediation. App HA improves application uptime through:
Policy-based application monitoring and remediation
Integration with vSphere HA to provide multiple recovery options, e.g. restart theapplication service or restart the virtual machine
Reduces Complexity
App HA eliminates the need for application-specific clustering solutions, thereforereducing the complexity involved in managing infrastructure silos, as well as costassociated with the solutions. App HA provides:
Uniform protection and support for many commonly used, off-the-shelf applications
Simple, centralized management through app-health visibility from VMware® vCenterServer™
Architecture Overview
vSphere App HA leverages VMware vFabric® to monitor applications. Deploying App HAbegins with provisioning two virtual appliances (per vCenter Server): App HA andHyperic. The App HA virtual appliance stores and manages App HA policies. Hypericmonitors applications and enforces App HA policies.
After the simple process of deploying the Hyperic and App HA virtual appliances,Hyperic agents are installed in the virtual machines containing applications that will beprotected by App HA.
App HA Policies
App HA policies are easily configured in the Administration section of the vSphere WebClient. Policies define items such as the number of times App HA will attempt to restarta service, number of minutes it will wait for the service to start, the option to reset thevirtual machine if the service fails to start, and reset the virtual machine when theservice is unstable.
HOL-SDC-1317
Page 8VMware Beta Program CONFIDENTIAL
![Page 9: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/9.jpg)
HOL-SDC-1317
Page 9VMware Beta Program CONFIDENTIAL
![Page 10: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/10.jpg)
Infrastructure Components - VMwarevCenter Operations ManagerIntroduction to VMware vCenter Operations Manager
VMware vCenter Operations Manager is the key component of the vCenter OperationsManagement Suite. It provides a new and simplified approach to operationsmanagement of VMware vSphere® physical and cloud infrastructure. Using patented,self-learning analytics and an open, extensible platform, vCenter Operations Managerprovides operations dashboards that provide insights and visibility into health, risk andefficiency of your infrastructure, performance management, and capacity optimizationcapabilities.
Using vCenter Operations Manager, you can do the following:
• Gain comprehensive visibility into the health, risk, and efficiency of yourinfrastructure and applications.
• Proactively manage the health of vSphere, virtual machines, and applications.• Spot potential performance bottlenecks early and remediate before it affects end
users.• Right-size and reclaim overprovisioned capacity to increase consolidation ratios.• Manage thousands of virtual machines, physical servers, and applications across
multiple datacenters from a single console.• Automatically correlate and analyze monitoring data across infrastructure and
applications silos to gain a holistic view of root cause and effect.
vCenter Operations Manager and the vCenter Operations Management Suite areessential tools for infrastructure teams and operations teams who want to enablequality of service, operational efficiency, and continuous compliance of dynamic cloudinfrastructure and business critical applications.
HOL-SDC-1317
Page 10VMware Beta Program CONFIDENTIAL
![Page 11: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/11.jpg)
Business Critical Applications - Aboutthis LabVMware vCloud Suite Business Critical Applications Lab
This Lab demonstrates the use of VMware technology such as vSphere APP HA andVMware vCenter™ Operations Manager™ to successfully operate and monitor BusinessCritical Applications.
The two most important considerations for virtualizing business critical applications(BCA) are high availability and performance management. This lab provides hands onexperience in using VMware solutions to manage availability and performance forbusiness critical applications.
Availability:
vSphere HA protect against hardware failures, while vMotion and DRS protect againstdowntime during planned maintenance activities. These aspects are covered in lab HOL-SDC-1310. These features protect business critical applications during unplanned andplanned hardware related downtimes.
Many business critical applications have single points of failure such as load balancers,central queue and lock management services, etc. that have a small compute footprintand can fit within 1 vCPU. These critical components can leverage vSphere FaultTolerance for protection and instantaneous always on recovery.
To protect against Application level failures there is a need for an app aware monitoringand remediation platform. vSphere APP HA with Hyperic provides application awaremonitoring and remediation. This lab will provide the user hands on experience withcreation of application protection policies and remediation.
Performance Management:
Performance management is critical for business critical applications. The ability tomonitor, troubleshoot and resolve performance related problems quickly is veryimportant. vCenter operations provides the capability to monitor, troubleshoot andmanage performance problems. In this lab vCenter Operations will be showcased totroubleshoot and perform a quick root cause analysis on a CPU related problem and aMemory related problem. The traditional IT manager dashboard will be used forinfrastructure visibility. The SQL dashboard that comes the vCenter OperationsManagement pack will be used to look at database level performance criteria.
Modules in this lab
Module 1: High Availability for Business Critical Applications
HOL-SDC-1317
Page 11VMware Beta Program CONFIDENTIAL
![Page 12: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/12.jpg)
Module 2: CPU contention situation on the MS SQL virtual machine (that is, CPU limit invirtual machine settings).
Module 3: Memory contention situation on the MS SQL virtual machine (that is, Memorylimit in virtual machine settings).
HOL-SDC-1317
Page 12VMware Beta Program CONFIDENTIAL
![Page 13: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/13.jpg)
Module 1: HighAvailability for Business
Critical Applications
HOL-SDC-1317
Page 13VMware Beta Program CONFIDENTIAL
![Page 14: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/14.jpg)
M1.1 - PreparationACME requires that the SQL database server for its business critical application behighly available. There is a requirement for SQL to be protected against hardware andapplication failures.
Login to vCenter web client
HOL-SDC-1317
Page 14VMware Beta Program CONFIDENTIAL
![Page 15: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/15.jpg)
Go to the administration menu and choose vSphere AppHA
HOL-SDC-1317
Page 15VMware Beta Program CONFIDENTIAL
![Page 16: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/16.jpg)
Create a new policy by pressing the + Sign
HOL-SDC-1317
Page 16VMware Beta Program CONFIDENTIAL
![Page 17: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/17.jpg)
Choose SQL 2008 R2 as the application service
HOL-SDC-1317
Page 17VMware Beta Program CONFIDENTIAL
![Page 18: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/18.jpg)
Setup remediation parameters for the service as shown
HOL-SDC-1317
Page 18VMware Beta Program CONFIDENTIAL
![Page 19: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/19.jpg)
Ignore Alarm setup and click next
HOL-SDC-1317
Page 19VMware Beta Program CONFIDENTIAL
![Page 20: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/20.jpg)
Finish Creating Policy
HOL-SDC-1317
Page 20VMware Beta Program CONFIDENTIAL
![Page 21: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/21.jpg)
The new policy that was created is now shown.
HOL-SDC-1317
Page 21VMware Beta Program CONFIDENTIAL
![Page 22: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/22.jpg)
Enable Policy
The created policy needs to be assigned to services for it to be enabled.
1. Browse to the vCenter server and click on the Monitor tab. Choose vCenter AppHA. All the compatible applications for APP HA in the environment are displayed.Select the MS SQL 2008 R2 and then right click and choose “Assign Policy”
HOL-SDC-1317
Page 22VMware Beta Program CONFIDENTIAL
![Page 23: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/23.jpg)
Assign Policy to MS SQL Application
HOL-SDC-1317
Page 23VMware Beta Program CONFIDENTIAL
![Page 24: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/24.jpg)
M1.2 - Test PolicyNow let's test to veryify the newly created VMware App HA policy is working
Remote desktop to the SQL server :
HOL-SDC-1317
Page 24VMware Beta Program CONFIDENTIAL
![Page 25: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/25.jpg)
Stop the SQL Service
Launch the services view with services.msc. Browse to the SQL server service and stopit.
HOL-SDC-1317
Page 25VMware Beta Program CONFIDENTIAL
![Page 26: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/26.jpg)
View App HA Alert in Hyperic Console
Login to the Hyperic console and look at the dashboard. The dashboard will show analert and the SQL server is automatically restarted.
Application HA Maintenance Mode (Optional)
Browse to the Application Availability under the Monitor for the vCenter and then put theMS SQL 2008 R2 service in maintenance mode.
Manually Stop the SQL service
You can now go back to your RDP session for the SQL server and shut down the SQLservice again.
HOL-SDC-1317
Page 26VMware Beta Program CONFIDENTIAL
![Page 27: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/27.jpg)
Wait for a few minutes and confirm that the SQL service is not restarted. This shows thatif a service is in APP HA maintenance mode it can be brought down without APP HAreacting to it.
HOL-SDC-1317
Page 27VMware Beta Program CONFIDENTIAL
![Page 28: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/28.jpg)
Restart SQL
Restart SQL manually from the services console.
HOL-SDC-1317
Page 28VMware Beta Program CONFIDENTIAL
![Page 29: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/29.jpg)
Exit App HA Maintenance mode
Browse to the Application Availability under the Monitor for the vCenter and Exitmaintenance mode for MS SQL R2 server instance.
HOL-SDC-1317
Page 29VMware Beta Program CONFIDENTIAL
![Page 30: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/30.jpg)
M1.3 - SummaryThis module demonstrated the workings of vSphere App HA and its ability to protectfrom application level failures. vSphere App HA works with VMware Hyperic to monitorand remediate supported applications. vSphere App HA is very simple to configure andis setup with a few mouse clicks.
Using APP HA along with vSphere HA and Fault Tolerance can protect business criticalapplications from hardware and software related failures. vSphere vMotion and DRS helpaddress planned downtime.
The VMware HA components improve SLA and availability metrics for business criticalapplications, with reduced planned and unplanned downtime.
HOL-SDC-1317
Page 30VMware Beta Program CONFIDENTIAL
![Page 31: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/31.jpg)
Module 2: CPU ContentionSituation on the MS SQL
Virtual Machine (CPULimit in Virtual Machine
Settings)
HOL-SDC-1317
Page 31VMware Beta Program CONFIDENTIAL
![Page 32: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/32.jpg)
M2.1 - PreparationThis use case put parts of the application into a resource contention situation for CPUresources. This simulates a scenario in which the Microsoft SQL Server does not getsufficient CPU resources and shows how this issue appears when vCenter OperationsManager is used.
Generate Resource Contention Situation - Log in tovSphere Web Client
*** For your convenience, you can use the file named “HOL-SDC-1317 CheatSheet.txt” to cut & paste commands and other information used in this lab. This file islocated on the desktop of the ControlCenter. ***
Select the vSphere Web Client tab in Internet Explorer and then log in with user nameadministrator with password VMware1!.
HOL-SDC-1317
Page 32VMware Beta Program CONFIDENTIAL
![Page 33: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/33.jpg)
Browse to the MS SQL Server Virtual Machine
Click VMs and Templates.
HOL-SDC-1317
Page 33VMware Beta Program CONFIDENTIAL
![Page 34: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/34.jpg)
Browse to the MS SQL Server Virtual Machine (cont.)
1. Click Related Objects.2. Click Virtual Machines.3. Click sql-w8-01a.
HOL-SDC-1317
Page 34VMware Beta Program CONFIDENTIAL
![Page 35: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/35.jpg)
Manage the MS SQL Server Virtual Machine
1. Click Manage.2. Click Edit.
HOL-SDC-1317
Page 35VMware Beta Program CONFIDENTIAL
![Page 36: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/36.jpg)
Set CPU Limit
1. Click to expand the virtual machine CPU settings.2. Change Limit from Unlimited to 250 MHz.3. Click OK.
It takes a while for the effects to be visible in vCenter Operations Manager or Hyperic.
HOL-SDC-1317
Page 36VMware Beta Program CONFIDENTIAL
![Page 37: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/37.jpg)
M2.2 - AnalysisNote: It can take a few minutes for the actual behavior to show up.
ACME is running into a resource contention situation on their Microsoft SQL Server.Observe the IT Manager dashboard to see whether this can be observed.
Login to vCenter Operations
Using the bookmark shortcuts in Internet explorer add a new tab and choose thebookmark for Custom UI vCenter Operations. Login as admin user.
HOL-SDC-1317
Page 37VMware Beta Program CONFIDENTIAL
![Page 38: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/38.jpg)
Observe CPU Alerts in vCenter Operations:
Select the IT Manager tab on the vCenter Operations Manager screen.
Sort the Active Alerts in descending order by Start time. Locate the SQL Server alert anddouble click.
Examine the Alerts More Closely
Under the Root Cause tab, explore the message event and the related change eventthat caused this alert. This is useful to correlate alerts to potential change events in theenvironment.
HOL-SDC-1317
Page 38VMware Beta Program CONFIDENTIAL
![Page 39: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/39.jpg)
Troubleshooting
Click on the Troubleshoot button and then choose the Mashup tab to look at graphicaldetails of the alert for analysis.
HOL-SDC-1317
Page 39VMware Beta Program CONFIDENTIAL
![Page 40: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/40.jpg)
Alert Metrics & Anomalies
Go to the Metric Charts tab which shows the anomaly relating to the alert with CPUReady above normal threshold
HOL-SDC-1317
Page 40VMware Beta Program CONFIDENTIAL
![Page 41: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/41.jpg)
M2.3 - RemediationRemediate Resource Contention Situation - Log in tovSphere Web Client
Log in with user name Administrator and password VMware1!.
HOL-SDC-1317
Page 41VMware Beta Program CONFIDENTIAL
![Page 42: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/42.jpg)
Browse to the MS SQL Server Virtual Machine
Click VMs and Templates.
HOL-SDC-1317
Page 42VMware Beta Program CONFIDENTIAL
![Page 43: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/43.jpg)
Browse to the MS SQL Server Virtual Machine (cont.)
1. Click Related Objects.2. Click Virtual Machines.3. Click sql-w8-01a.
HOL-SDC-1317
Page 43VMware Beta Program CONFIDENTIAL
![Page 44: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/44.jpg)
Manage the MS SQL Server Virtual Machine
1. Click Manage.2. Click Edit.
HOL-SDC-1317
Page 44VMware Beta Program CONFIDENTIAL
![Page 45: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/45.jpg)
Remove CPU Limit
1. Click to expand the virtual machine CPU settings.2. Change Limit from 250 MHz to Unlimited.3. Click OK.
It takes a while for the effects to be visible in vCenter Operations Manager or Hyperic.
HOL-SDC-1317
Page 45VMware Beta Program CONFIDENTIAL
![Page 46: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/46.jpg)
M2.4 - SummaryThis module showed you the ability to use vCenter operations for troubleshooting CPUrelated problems at the VM level and performing root cause analysis that ties it back tochanges made in the environment. VCOPS also provides metrics and anomaly data thatspeeds up the troubleshooting process. This is invaluable for business criticalapplications as downtime should be minimized or avoided. This also demonstrates thatsetting limits on CPU can be dangerous.
HOL-SDC-1317
Page 46VMware Beta Program CONFIDENTIAL
![Page 47: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/47.jpg)
Module 3: MemoryContention Situation on
the MS SQL VirtualMachine (Memory Limit inVirtual Machine Settings)
HOL-SDC-1317
Page 47VMware Beta Program CONFIDENTIAL
![Page 48: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/48.jpg)
M3.1 - PreparationGenerate Resource Contention Situation - Log in tovSphere Web Client
*** For your convenience, you can use the file named “HOL-SDC-1317 CheatSheet.txt” to cut & paste commands and other information used in this lab. This file islocated on the desktop of the ControlCenter. ***
Log in with user name Administrator and password VMware1!.
HOL-SDC-1317
Page 48VMware Beta Program CONFIDENTIAL
![Page 49: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/49.jpg)
Browse to the MS SQL Server Virtual Machine
Click VMs and Templates.
HOL-SDC-1317
Page 49VMware Beta Program CONFIDENTIAL
![Page 50: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/50.jpg)
Browse to the MS SQL Server Virtual Machine (cont.)
1. Click Related Objects.2. Click Virtual Machines.3. Click sql-w8-01a.
HOL-SDC-1317
Page 50VMware Beta Program CONFIDENTIAL
![Page 51: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/51.jpg)
Manage the MS SQL Server Virtual Machine
1. Click Manage.2. Click Edit.
HOL-SDC-1317
Page 51VMware Beta Program CONFIDENTIAL
![Page 52: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/52.jpg)
Configure Memory Limit to Simulate a ResourceContention Issue
1. Click Memory to expand.2. For Limit,enter 250 MB and enter 0 for Reservation.3. Click OK.
HOL-SDC-1317
Page 52VMware Beta Program CONFIDENTIAL
![Page 53: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/53.jpg)
M3.2 - AnalysisNote: It can take several minutes for the actual behavior to show up.
ACME is experiencing memory resource contention on their Microsoft SQL Server.
Observe the IT Managers Dashboard
Browse to the Alerts Overview tab to look at the initial alerts generated.
Alerts for MemoryContention are displayed in the Active Alerts pane.
Double-click the one of the memory related alerts for the SQL server.
HOL-SDC-1317
Page 53VMware Beta Program CONFIDENTIAL
![Page 54: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/54.jpg)
A Detailed View of the Memory Alert
The more detailed view shows that multiple KPIs are breaching for memory contentionin the mashup pane.
HOL-SDC-1317
Page 54VMware Beta Program CONFIDENTIAL
![Page 55: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/55.jpg)
Root Cause Analysis
When further examining the change events shown in the Root Cause pane, you willeventually find the resource allocation change you did in the preparation section.
HOL-SDC-1317
Page 55VMware Beta Program CONFIDENTIAL
![Page 56: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/56.jpg)
What Can the SQL Administrator Observe?
Select the SQL Server Overview tab on the vCenter Operations Manager screen. Thisdashboard shows how the SQL administrator can observe the issue surfacing. Due to thememory contention, swapping would go up (2). This leads to higher disk I/O (1) andhigher CPU usage (3).
HOL-SDC-1317
Page 56VMware Beta Program CONFIDENTIAL
![Page 57: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/57.jpg)
M3.3 - RemediationThe resource contention can be remediated by reversing the change regarding memorylimits.
Reverting it back in this lab will not necessarily produce any results in a timely manner.This is because the pages that have been swapped out due to memory shortage andcould take hours to go back into real memory based on the usage characteristics of theSQL server.
HOL-SDC-1317
Page 57VMware Beta Program CONFIDENTIAL
![Page 58: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/58.jpg)
M3.4 - SummaryThis module showed you the ability to use vCenter operations for troubleshootingmemory related problems at the VM level and at the SQL server application level. TheSQL Server Management pack for VCOPS provides the ability to collect and look at SQLlevel metrics from VCOPS and correlate events across the entire infrastructure stack.Application specific management packs for VCOPS can help the infrastructure andapplication team members collaborate in problem resolution.
This also demonstrates that setting limits on memory can be dangerous.
HOL-SDC-1317
Page 58VMware Beta Program CONFIDENTIAL
![Page 59: Table of Contents · VMware vCenter Operations Manager is the key component of the vCenter Operations Management Suite. It provides a new and simplified approach to operations management](https://reader034.vdocuments.us/reader034/viewer/2022052000/601215b1070ac326d327c8a7/html5/thumbnails/59.jpg)
ConclusionThank you for participating in the VMware 2013 Hands-on Labs. Be sure to visithttp://hol.vmware.com/ to continue your lab experience online.
Lab SKU: HOL-SDC-1317
Version: 20140213-185244
HOL-SDC-1317
Page 59VMware Beta Program CONFIDENTIAL