Performance Collection Rule Bug - only Data in Datawarehouse

[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]

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]

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]

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]

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