NetXMS Support Forum

Hi,

Since I upgraded to v1.2.7 yesterday I've been having some small problems with creating nodes, containers, templates, template groups, etc.
Some times (not always), the operations takes up to 10-30 seconds, or even gives a message such as "Request timed out". However, if I manually refresh the object browser a while later, the requested operation is usually done.

The NetXMS server is running on Windows 2008 R2 (x64) with MS SQL Express 2012, with 16GB of RAM and two quad core CPU's. CPU usage of netxmsd is about 1-2%, 400MB RAM, sqlservr about 1-3%, 4GB RAM in use.

The queue lengths are all within reason, except for "Database writer's request queue (other queries) for last minute" which sometimes goes up to 1K-2K+. I have 8 database writers configured, and there are 933 nodes with 18296 objects and 8350 DCI's.

Any ideas?
Thanks in advance!

Hi!

I've seen similar behavior on a site I'm supporting. In 1.2.7 I've added additional locks to ensure database integrity. Looks like this feature causing excessive internal locks under some circumstances. I'll make it configurable and turned off by default in 1.2.8.

Best regards,
Victor