Cluster Capacity Forecast

Unleash the power of System Center for vSphere and Hyper-V | Veeam Task Manager for Hyper-V

Cluster Capacity Forecast

Veeam Logoby Cragdoo » Mon Jun 20, 2016 3:53 pm

Are there any deep dive information posts about how the Cluster Capacity forecast dashboards are compiled? ... oards.html

Looking for information around what metrics are collected/used to create the figures etc, as I'm interested in extracting the raw data for visualising elsewhere.

Thanks in advance
Veeam Vanguard
Posts: 489
Liked: 181 times
Joined: Tue Sep 27, 2011 12:17 pm
Location: Scotland
Full Name: Craig Dalrymple

Re: Cluster Capacity Forecast

Veeam Logoby sergey.g » Mon Jul 11, 2016 3:57 pm

Hi Craig,

With respect to counters - it's pretty much what you see in the UI, with respect to how it works - everything you need can be captured with SQL Profiler. However, I would recommend using Capacity Planning report instead of a widget. Widget SQL SP returns data in a special XML schema and it is going to be difficult to parse this data. On the other hand report SQL SP return numbers. Here is what I have in my lab in the profiler:

Code: Select all
exec dbo.Veeam_VE_VMware_PerformanceForecastGet @StartDate='2016-06-11 15:26:00',@EndDate='2016-08-10 15:26:00',@ReportSystemName=N'Veeam.Virt.Extensions.VMware.CapacityPlanning.Reports.ForecastVMCCR.LR',@ObjectList=N'<Data><Objects><Object Use="Containment">1265</Object></Objects></Data>',@RawThresholds=N'<Thresholds><Threshold Id="1" Value="90" /><Threshold Id="2" Value="90" /><Threshold Id="3" Value="0" /><Threshold Id="4" Value="0" /><Threshold Id="5" Value="0" /><Threshold Id="6" Value="0" /></Thresholds>',@SelectedAspects=N'<SelectedAspects><SelectedAspect TargetId="VMCCR" AspectId="CPU" /><SelectedAspect TargetId="VMCCR" AspectId="RAM" /></SelectedAspects>'

StartDate - how far away you want to check data in the past
EndDate - how far in the future you want to check your resources
ObjectList - it's a root level All vSphere Clusters group, in my lab it's 1265, use the following to get rowid in yours:

Code: Select all
SELECT [ManagedEntityRowId]
  FROM [OperationsManagerDW].[dbo].[ManagedEntity]
  where [Fullname] like 'Veeam.Virt.Extensions.VMware.VMCCR.Group'

In the results of the qurey you will need RowType like 'A' - it's Average/Summary part of the report (there is also P - advanced performance data, S - summary for resources). You will be able to get Cluster name, Resource name (CPU or RAM) whether you have enough resources or not (IsConstraining column) and how many days till treshold (DaysTillThreshold column) and many many more ;) .

Let me know if you have any other questions.
Posts: 455
Liked: 75 times
Joined: Wed May 02, 2012 1:49 pm
Full Name: Sergey Goncharenko

Return to Veeam Management Pack for Microsoft System Center

Who is online

Users browsing this forum: No registered users and 3 guests