Monitoring and reporting for Veeam Backup & Replication, VMware vSphere and Microsoft Hyper-V in a single System Center Operations Manager Console
Post Reply
mbietz
Influencer
Posts: 23
Liked: 3 times
Joined: Jul 10, 2015 9:18 am
Contact:

Performance Collection Rule Bug - only Data in Datawarehouse

Post by mbietz »

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?
sergey.g
Veteran
Posts: 452
Liked: 76 times
Joined: May 02, 2012 1:49 pm
Full Name: Sergey Goncharenko
Contact:

Re: Performance Collection Rule Bug - only Data in Datawareh

Post by sergey.g »

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.
mbietz
Influencer
Posts: 23
Liked: 3 times
Joined: Jul 10, 2015 9:18 am
Contact:

Re: Performance Collection Rule Bug - only Data in Datawareh

Post by mbietz »

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
sergey.g
Veteran
Posts: 452
Liked: 76 times
Joined: May 02, 2012 1:49 pm
Full Name: Sergey Goncharenko
Contact:

Re: Performance Collection Rule Bug - only Data in Datawareh

Post by sergey.g »

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
Veteran
Posts: 452
Liked: 76 times
Joined: May 02, 2012 1:49 pm
Full Name: Sergey Goncharenko
Contact:

Re: Performance Collection Rule Bug - only Data in Datawareh

Post by sergey.g »

Sorry, forgot about another part of the question, I'll post more details about PowerBI, and PowerPivot a little bit later.
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests