Network Analizer Very Slow - Queries

[bosecorp]

I am trying to running queries and seems to be taking a lot time. my VM server doesn't seem to be under a lot stress. CPU, Memory, IO seem to be OK.

when I use Nagios XI, by going to the network analyzer tab I am able to see the top 10 from there.



top - 15:53:33 up 78 days, 7:07, 1 user, load average: 0.12, 0.03, 0.01
Tasks: 376 total, 1 running, 375 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.2%us, 0.0%sy, 0.0%ni, 99.6%id, 0.1%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 16464852k total, 16229880k used, 234972k free, 358624k buffers
Swap: 33521648k total, 356k used, 33521292k free, 14798452k cached

# free -m
total used free shared buffers cached
Mem: 16078 15844 234 0 350 14453
-/+ buffers/cache: 1040 15038
Swap: 32735 0 32735
root@nagnetanalyzer:(07-07 15:53): /root
# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/rootvg-lvroot
2.0G 555M 1.3G 30% /
tmpfs 7.9G 0 7.9G 0% /dev/shm
/dev/sda1 239M 47M 179M 21% /boot
/dev/mapper/rootvg-lvopt
2.0G 28M 1.8G 2% /opt
/dev/mapper/rootvg-lvtmp
2.0G 7.4M 1.8G 1% /tmp
/dev/mapper/rootvg-lvusers
3.9G 8.0M 3.7G 1% /users
/dev/mapper/rootvg-lvusr
7.8G 3.4G 4.1G 46% /usr
/dev/mapper/rootvg-lvvar
3.9G 1.5G 2.2G 40% /var
/dev/mapper/vgapp-lvnagiosna_var
9.8G 39M 9.2G 1% /var/www/html/nagiosna
/dev/mapper/vgapp-lvnagiosna_local
100G 62G 33G 66% /usr/local/nagiosna


here more useful information

root@nagnetanalyzer:(07-07 15:53): /root
# du -h /usr/local/nagiosna/var/
1.9G /usr/local/nagiosna/var/Cisco_L3_MA/flows
1.9G /usr/local/nagiosna/var/Cisco_L3_MA
8.8G /usr/local/nagiosna/var/Sprint_MA/flows
8.8G /usr/local/nagiosna/var/Sprint_MA
9.3G /usr/local/nagiosna/var/Sprint_Global/flows
9.3G /usr/local/nagiosna/var/Sprint_Global
1.2M /usr/local/nagiosna/var/PA_Firewalls/flows
2.4M /usr/local/nagiosna/var/PA_Firewalls
5.3G /usr/local/nagiosna/var/ATT_Partners/flows
5.3G /usr/local/nagiosna/var/ATT_Partners
45M /usr/local/nagiosna/var/Sprint/flows
47M /usr/local/nagiosna/var/Sprint
37G /usr/local/nagiosna/var/Firewalls_PA_MA/flows
37G /usr/local/nagiosna/var/Firewalls_PA_MA
399M /usr/local/nagiosna/var/Linux_MA/flows
400M /usr/local/nagiosna/var/Linux_MA
62G /usr/local/nagiosna/var/

[jdalrymple]

bosecorp...

Can you tell us a bit more about the resources available to the NNA system?

Physical of virtual?
Number and type of CPUs?
Memory?
Disk subsystem <-- Very important to know as much detail as possible

Please reference this forum thread:

http://support.nagios.com/forum/viewtop ... lyzer+slow

We are still looking for some potential optimizations for the data queries deep deep under the hood, but unfortunately it sounds like you may have run across the same performance limitation that CFT6Server has come across.

Let us know about the resources your system has please.

Thanks