i have a data list and i want to create a chart for particular data, monthly and daily basis. i have attached the .csv file and necessary data below, any one explain step by step ( if possible screen shot) it will b nice tutorial for learning.
•X-axis is hourly. Norm is 2 days 24 points. You can scale to 60 days on x axis. It will make the point very small, but we need capability is a requirement
•The value shown will be the hourly average. X-axis is hour. So do we want hourly average or hourly max. We could make this a filter and based on the filer you select it would Show hrly average
CPU Utilization –
GBL_CPU_SYS_MODE_UTIL – SYSCPUPCTSYSTime
GBL_CPU_USER_MODE_UTIL - SYSCPUPCTUSERTIME
Everything except Windows: GBL_CPU_WAIT_UTIL – SYSCPUWAITTIME
Windows Only - SysCpuPctIntrptTime
Memory Utilization –
GBL_MEM_SYS_UTIL (SYSMEMPHYSPCTSYS)
GBL_MEM_USER_UTIL (SYSMEMPHYSPCTUSER)
GBL_MEM_CACHE_UTIL (SYSMEMPHYSPCT) this metric will be Null for Solaris systems.
I/O Rate –
GBL_DISK_PHYS_READ_RATE (SysDiskPhysReadRate)
GBL_DISK_PHYS_WRITE_RATE (SysDiskPhysWriteRate
Run Queue – not valid for VMWare Guests
GBL_RUN_QUEUE (SYSPROCRUNQUEUELENGTH) (everything except HP-UX)
GBL_PRI_QUEUE (SysProcPriorityQueueLength) (HP-UX only)
If “Is Virtual” = Yes and “Virtualization Technology” = VMWare, use VmGuestCpuPhysPctReady
Paging Rates (Windows)
GBL_MEM_PAGEIN_RATE (SYSMEMPAGESINRATE)
GBL_MEM_PAGEOUT_RATE (SYSMEMPAGESOUTRATE)
Paging Rate metrics must be on separate axes in the graph.
Network Packet Rates –
GBL_NET_IN_PACKET_RATE (SYSNWLFPACKETINRATE)
GBL_NET_OUT_PACKET_RATE (SYSNWLFPACKETOUTRATE)
Page Scan Rate
HP-UX, AIX and Solaris = GBL_MEM_PG_SCAN_RATE (SYSMEMPAGESCANRATE)
Swap In / Swap Out Byte Rate
*X systems only: SysMemSwapInByteRate
* X systems only: SysMemSwapOutByteRate
,
CPU Total Processor Usage – Forecast vs Actual
D1_GBL_CPU_TOTAL_USED (SysCpusUsed). (monthly average, monthly peak hour, monthly peak interval) not really staked bar, but 3 separate bars overlaid
Trend – Trend line based on 12 month linear trend calculation. From the last month we have data trend out the next 12 months
Installed Capacity CI_SYS_PROP_D.NR_OF_PHYSCL_CPU_DN (Installed Capacity comes from ESL)
Usable Capacity CI_SYS_PROP_D.NR_OF_PHYSCL_CPU_DN * Warning threshold for (Capacity/CPU Percent Used) (Based on warning threshold in ESL)
Memory Usage
GBL_MEM_UTIL (SysMemPhysPctUsed) (monthly average, monthly peak hour, Monthly peak interval) not really staked bar, but 3 separate bars overlaid.
AIX Linux HPUX (GBL_MEM_SYS_UTIL + GBL_MEM_USER_UTIL)
Usable capacity – Warning threshold - Capacity – (Physical Memory Percent Used) (D1_GBL_MEM_PHYS_USED)
Memory Usage Forecast
D1_GBL_MEM_PHYS_USED (SysMemPhysSpaceUsed) - (monthly average, monthly peak hour, monthly peak interval) not really staked bar, but 3 separate bars overlaid
Trend – Trend line based on 12 month linear trend calculation. From the last month we have data trend out the next 12 months
Installed capacity CI_SYS_PROPR_D.INSTLD_MEM_DN (from ESL)
Usable Capacity CI_SYS_PROPR_D.INSTLD_MEM_DN * Warning threshold (Capacity - Physical Memory Percent Used)
Paging Usage
Windows: GBL_MEM_PAGEOUT_RATE (SysMemPagesOutRate) (monthly average, monthly peak hour, Monthly peak interval) not really staked bar, but 3 separate bars overlaid.
Solaris – show Page Scan Rate – SysMemPageScanRate
*X - D1_GBL_MEM_SWAP_RATE (derived metric)
IO Usage
GBL_DISK_PHYS_IO_RATE (SysDiskPhysIoRate) (monthly average, monthly peak hour, Monthly peak interval) not really staked bar, but 3 separate bars overlaid.
Swap Space
GBL_SWAP_SPACE_UTIL (SysMemSwapPctUsed) (monthly average, monthly peak hour, Monthly peak interval) not really staked bar, but 3 separate bars overlaid.
If OS = Windows, this graph should be titled“Page File Util”/ all other OSs Title is Swap Space Util”
.png "Miguel_Angel_Baeyens"){kind=avatar}
