getting historical data out of OCUM
2017-11-10 04:36 AM
using OCUM-appliance 7.1P1
I am trying the get the rigth data out of the OCUM database, as I need historical data.
I suucceeded partly when I followed
http://thetecharch.com/2016/03/querying-ocum-database-using-powershell-2/ .... but I think I do not have enough data to make the right calculation.
This method uses Powershell, and within Powershell some SQL-commands to get data out of the databases.
My problem: I need TOTAL and USED per PERIOD, so I can calculate per used-percentage for that PERIOD.
Now I have this data for a certain volume, but I think this is to less info:
volumeId : 2022231
periodEndTime : 9-11-2017 01.00.00 uur
sampleCount : 670
UsedSum : 3729838208
Total : 597688320
SnapshotUsedSum : 54430564
SnapshotTotal : 31457280
If I UsedSum / sampleCount , it gives me a number that is to small. I have not much more fields to choose
Who can help?! Thank you!! Moray
1 REPLY 1
Re: getting historical data out of OCUM
2017-11-15 09:37 AM
From what i could compute, your volume consumption is 0.00518GB / sample or 5.18MB / sample which basically means the volume growth rate is on an average 5.18MB every 15 mins
since the default capacity poll runs every 15 mins.
Is this number way too short of the expected value, for the I/O's runnnig on this volume ?