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
Was is faster of previous versions? What is the network throughput and ping time between nxmc machine and the server?
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.
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.