Performance Collection Rule Bug - only Data in Datawarehouse

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

Performance Collection Rule Bug - only Data in Datawarehouse

Veeam Logoby mbietz » Tue Nov 03, 2015 6:28 pm

Hello,

I wanted to see Data collected by the Rule "DATASTORE.Collect.totalReadRate".
But there seems no data in the operationsmanager database.
(is the Data Collection Write Action missing?)
In the Datawarehouse there is data from this rule.
Does this rule only pushes data into the Datawarehouse?
Is this normal, or is it a bug?
How can I get those metrics in the operationsmanager database?
mbietz
Influencer
 
Posts: 21
Liked: 3 times
Joined: Fri Jul 10, 2015 9:18 am

Re: Performance Collection Rule Bug - only Data in Datawareh

Veeam Logoby sergey.g » Thu Nov 05, 2015 3:30 pm

Hi,

Yes, this metric is not in the Operations DB by design. This allows us to reduce footprint of our MP in the operations database. But you should be still able to see this data, either via Report (Datastore Performance History report) or via dashboard, you can either create new dashboard with performance view and select this metric or use the following dashboard views from our MP:

1. Datastore Traffic Analysis
2. Top Datastores for Traffic & Latency

We have also several other examples how to extract data from the DW DB, please let me know if you are interested in MS Excel PowerPivot example or PowerBI example.

Thanks.
sergey.g
Veeam Software
 
Posts: 453
Liked: 75 times
Joined: Wed May 02, 2012 1:49 pm
Full Name: Sergey Goncharenko

Re: Performance Collection Rule Bug - only Data in Datawareh

Veeam Logoby mbietz » Mon Nov 09, 2015 9:50 am

Hi Sergey,

yes you can send me more information on MS Excel PowerPivot example or PowerBI example.
Is there a Document, in which I can see, which rules does not store their metric in the Operations DB?

Thanks
mbietz
Influencer
 
Posts: 21
Liked: 3 times
Joined: Fri Jul 10, 2015 9:18 am

Re: Performance Collection Rule Bug - only Data in Datawareh

Veeam Logoby sergey.g » Mon Nov 09, 2015 4:12 pm

Hi,

So, to get this list you can do something like that in the SCOM PS console (not fully correct logically, but in our MP rules with a single write action are those which write to DW only)

Code: Select all
get-scommanagementpack -name "veeam*" | get-scomrule | ? {$_.category -like "*performance*" -and $_.writeactioncollection[1] -eq $null} | select displayname, name, writeactioncollection


And I've also created such a list from my lab, you can check it there

And we also try to add this information to our online user guides.

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

Re: Performance Collection Rule Bug - only Data in Datawareh

Veeam Logoby sergey.g » Mon Nov 09, 2015 4:14 pm

Sorry, forgot about another part of the question, I'll post more details about PowerBI, and PowerPivot a little bit later.
sergey.g
Veeam Software
 
Posts: 453
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 2 guests