Re: CPU & Memory utilization report weekly (254 Views)
Reply
Frequent Advisor
sagar Bhattacharya
Posts: 50
Registered: ‎08-16-2007
Message 1 of 7 (312 Views)

CPU & Memory utilization report weekly

HI ,

 

I have installed OVPI 5.41 and system resource report pack, I am getting CPU memory report daily and hourly but unable to get weekly and monthly.

 

So could you help me how to generate CPU & memory utilization report weekly and monthly , if possible step by step .

 

 

Thanks

 

Sagar Bhattacharya

Sagar.bhattacharya@gmail.com

 

Honored Contributor
Piku
Posts: 4,136
Registered: ‎06-17-2010
Message 2 of 7 (299 Views)

Re: CPU & Memory utilization report weekly

Hi,

I don't feel there is any table for weekly and monthly.

hth,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Honored Contributor
sekar sundaram
Posts: 615
Registered: ‎11-14-2008
Message 3 of 7 (293 Views)

Re: CPU & Memory utilization report weekly

I am not sure of this issue.. and i tried to read the manual(User guide - System Resource Report Pack

For the Windows®, HP-UX, Solaris, and Linux operating systems
Software Version: 4.52
HP Performance Insight 5.41 )...

 

and found this...:

 

System Resource Report Pack
The reports in System Resource will help you anticipate resource issues before they become
serious. You will know whether resources are plentiful, limited, or somewhere in between, and
you will be able to make useful comparisons. For example, you can look at hourly utilization
levels for yesterday, and if something does not look quite right, you can easily compare
yesterday’s performance to weekly and monthly trends.

Advisor
zidercol
Posts: 13
Registered: ‎12-05-2012
Message 4 of 7 (284 Views)

Re: CPU & Memory utilization report weekly

1) What certainly do you need ? You can use Builder to change timeperiod of the Graph in Options. For Example, pic1 in attachments.

2) Do you have data for graph ? May be you need to change Pooling Policy? Pic2.

Frequent Advisor
sagar Bhattacharya
Posts: 50
Registered: ‎08-16-2007
Message 5 of 7 (272 Views)

Re: CPU & Memory utilization report weekly

HI expert ,

 

Thanks for your information,

 

I want to create teel file  along with data table in the OVPI database  where store weekly and monthly data. I have change the time frame but it is only show only 4 days data.

 

So I need steps which will help me to create teel and data table in the ovpi .

 

Regards

Sagar

sagarbh@hotmail.com

Honored Contributor
Piku
Posts: 4,136
Registered: ‎06-17-2010
Message 6 of 7 (260 Views)

Re: CPU & Memory utilization report weekly

Hi Sagar,

I do not suppose it possible as there is no such report pack which summarized data for weekly or monthly table.
You should ask for same.
At DB end you may ask you DBA to write the sql procedure to sum and average the data from day table to weekly/monthly table.


hth,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
HP Expert
Nick Paine
Posts: 417
Registered: ‎12-23-2003
Message 7 of 7 (254 Views)

Re: CPU & Memory utilization report weekly

The daily SR CPU data table - SD_SR_CPU has a default retention period of 150 days so you can adjust the time periods in your daily reports to look at daily data going back 150 days (if it exists).

 

Alternatively you can create trend_sum *.sum files to summarize the daily data to a weekly and monthly level.  When the trend_sum is run for the first time, it will automatically create the destination table if it does not already exist.

 

Therefore based on the existing SD_SR_CPU.sum file you could create a weekly summarization file SW_SR_CPU.sum as:

 

source table:SD_SR_CPU
destination table:SW_SR_CPU

 

column:CPUSystemMode=AVGCPUSystemMode:avg
column:CPUUserMode=AVGCPUUserMode:avg
column:CPUUtil=AVGCPUUtil:avg
column:CSRate=AVGCSRate:avg
column:IntRate=AVGIntRate:avg


by_variable:keyid
by variable:week

 

And then create the weekly table and summarize the data with:

 

trend_sum -f {DPIPE_HOME}/scripts/SW_SR_CPU.sum

 

See the PI Reference Guide for details about trend_sum.

 

Once you have data in the weekly table, you can modify/create reports using Builder to look at the data.  See the PI Building and Viewing Reports Guide for details.

 

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.