Reports Tab taking too longtime to load

[raamardhani7]

Hi Team,

I have repaired database and stillfacing the same issue.

Code: Select all

[root@lussvpnagiosxi00 mibs]# cat /proc/meminfo
MemTotal:        8061568 kB
MemFree:          791240 kB
Buffers:          568800 kB
Cached:          4063220 kB
SwapCached:         8776 kB
Active:          3902040 kB
Inactive:        1455364 kB
Active(anon):     600932 kB
Inactive(anon):   159176 kB
Active(file):    3301108 kB
Inactive(file):  1296188 kB
Unevictable:           0 kB
Mlocked:               0 kB
SwapTotal:       4128764 kB
SwapFree:        4061496 kB
Dirty:             76552 kB
Writeback:             0 kB
AnonPages:        719240 kB
Mapped:            76192 kB
Shmem:             34556 kB
Slab:            1805020 kB
SReclaimable:    1164720 kB
SUnreclaim:       640300 kB
KernelStack:        2336 kB
PageTables:        34404 kB
NFS_Unstable:          0 kB
Bounce:                0 kB
WritebackTmp:          0 kB
CommitLimit:     8159548 kB
Committed_AS:    1350376 kB
VmallocTotal:   34359738367 kB
VmallocUsed:      158264 kB
VmallocChunk:   34359533544 kB
HardwareCorrupted:     0 kB
AnonHugePages:    129024 kB
HugePages_Total:       0
HugePages_Free:        0
HugePages_Rsvd:        0
HugePages_Surp:        0
Hugepagesize:       2048 kB
DirectMap4k:       10240 kB
DirectMap2M:     8378368 kB
[root@lussvpnagiosxi00 mibs]#  cat /proc/cpuinfo
processor       : 0
vendor_id       : GenuineIntel
cpu family      : 6
model           : 45
model name      : Intel(R) Xeon(R) CPU E5-2670 0 @ 2.60GHz
stepping        : 7
microcode       : 1808
cpu MHz         : 2600.000
cache size      : 20480 KB
physical id     : 0
siblings        : 2
core id         : 0
cpu cores       : 2
apicid          : 0
initial apicid  : 0
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss ht syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts xtopology tsc_reliable nonstop_tsc aperfmperf unfair_spinlock pni pclmulqdq ssse3 cx16 pcid sse4_1 sse4_2 x2apic popcnt aes xsave avx hypervisor lahf_lm ida arat epb pln pts dts
bogomips        : 5200.00
clflush size    : 64
cache_alignment : 64
address sizes   : 40 bits physical, 48 bits virtual
power management:

processor       : 1
vendor_id       : GenuineIntel
cpu family      : 6
model           : 45
model name      : Intel(R) Xeon(R) CPU E5-2670 0 @ 2.60GHz
stepping        : 7
microcode       : 1808
cpu MHz         : 2600.000
cache size      : 20480 KB
physical id     : 0
siblings        : 2
core id         : 1
cpu cores       : 2
apicid          : 1
initial apicid  : 1
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss ht syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts xtopology tsc_reliable nonstop_tsc aperfmperf unfair_spinlock pni pclmulqdq ssse3 cx16 pcid sse4_1 sse4_2 x2apic popcnt aes xsave avx hypervisor lahf_lm ida arat epb pln pts dts
bogomips        : 5200.00
clflush size    : 64
cache_alignment : 64
address sizes   : 40 bits physical, 48 bits virtual
power management:

[rkennedy]

Can you please answer these questions?

1. How many CPUs do you have allocated to this machine?
2. Is it physical or virtual?

Are you running a ramdisk in your environment?

Judging by your load and memory it looks like you will need much more resources in order to speed things up. Creating reports takes time, and resources. If your resources are bottle-necked then generating the reports will take much longer.

[raamardhani7]

Can you please answer these questions?

1. How many CPUs do you have allocated to this machine?
2. Is it physical or virtual?

Are you running a ramdisk in your environment?

Judging by your load and memory it looks like you will need much more resources in order to speed things up. Creating reports takes time, and resources. If your resources are bottle-necked then generating the reports will take much longer.

4 CPU cores are allocated to this machie, 16GB RAM and it is a Virtual machine with Linux OS 6.3 Version.

[rkennedy]

Can you allot atleast 4 more CPU's to the machine? Have you noticed a performance increase since upping it to 16GB (it previously looks like you had 8GB).

[WillemDH]

4 cpus for 3811 hosts seems not enough. Can you post a screenshot of load and cpu utilisation of yr Nagios server of the last 30 days? I would suggest you add at least two cpus.

[rkennedy]

@raamardhani7 - let us know when you're able to allocate more CPU's to it and the result.

[raamardhani7]

@raamardhani7 - let us know when you're able to allocate more CPU's to it and the result.

Hi rkennedy,

You can close this thread, will ask our client to add 2 more CPU cores and if still facing issues. Will start a new thread. Thanks.