Slow load time for NetXms

Started by Egert143, October 15, 2021, 09:48:24 AM

Previous topic - Next topic

Egert143

Hello

How can i debug why NetXms Management Console is starting up really slow? Currently timed startup time to 3min and 53s. Most of that time was spent on "Synchronizing objects...".

Version is 3.8.382
DB is Ms Sql 2019

Show dbstats:
Total: 2183360433
Select: 470887177
Non-Select: 1712735689
Long running: 0
Failed: 0
Background writer requests
DCI data: 552603253
DCI raw data: 622931142
Others: 1633579


Show stats:
Objects: 38264
Monitored nodes: 5644
Collectible DCIs: 16531
Active alarms: 642
Uptime: 52 days, 0:37:07


Show syncer:
Last run at 15.Oct.2021 09:45:28
Last run time: 4077 ms
Average run time: 3496 ms
Max run time: 106385 ms
Min run time: 1015 ms

Filipp Sudanov

Was is faster of previous versions? What is the network throughput and ping time between nxmc machine and the server?

Egert143

It seems to have gotten slower with addition of new nodes over time.

Server is in same machine as sql. Client is connected with 1g link and ping time is ~1ms.

It seems restarting the server + changing "ThreadPool.Poller.MaxSize" from 250->1200, "ThreadPool.Poller.BaseSize" 10->600 helped, now it loads in few seconds.

Filipp Sudanov

That's a great finding. The reason is that pollers can lock objects in some situations. Increasing the number of pollers reduces the chance that a locked objects would be encountered when nxmc is syncing objects.