Hello.
Sorry for late reply.
It's definitely an issue with database performance, queue size is way to high.
1) Check "EnableMultipleDBConnections" parameter (either in server settings or using "nxdbmgr get EnableMultipleDBConnections"), it should be set to "1"
2) Check "ConnectionPoolBaseSize" and "ConnectionPoolMaxSize". Server can be very slow if poll size is limited to 1.
2) Increase number of DB writers to at least 4 ("nxdbmgr set NumberOfDatabaseWriters 4")
3) Check I/O, enable slow query logging
Please note "nxdbmrg set" should be used only when server is stopped.
Sorry for late reply.
It's definitely an issue with database performance, queue size is way to high.
1) Check "EnableMultipleDBConnections" parameter (either in server settings or using "nxdbmgr get EnableMultipleDBConnections"), it should be set to "1"
2) Check "ConnectionPoolBaseSize" and "ConnectionPoolMaxSize". Server can be very slow if poll size is limited to 1.
2) Increase number of DB writers to at least 4 ("nxdbmgr set NumberOfDatabaseWriters 4")
3) Check I/O, enable slow query logging
Please note "nxdbmrg set" should be used only when server is stopped.
