nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

SQL server performance issues.

Jose_Luis_Ferna

We have several environments Nuxeo 6.0 + SQL Server 2012 and we are experiencing some performance issues.

When we add documents the system slows down. The whole system slows down even login user. For example, with the newly installed system to create 100 documents takes 5 seconds, ith 50,000 documents in the system it takes to create 100 docs, 20 seconds, and with 150,000 documents in the system takes 38 seconds to create 100 docs.

The operating system is ubuntu jessie / sid (Nuxeo) and Windows 2012 server (database). We have followed the procedures of this page https://doc.nuxeo.com/display/ADMINDOC/Configuring+MS+SQL+Server , installing nuxeo from tar.gz file.

Nuxeo with postfgresql does not have this comportment, the same 100 documents takes 3/4 seconds to create.

Is there any specific configuration or upgrade for Nuxeo + mssql?

thanks in advance.

Find more posts tagged with

Comments

Julien_Carsique

SQL server has some known limitations: ADMINDOC/Configuring+MS+SQL+Server#ConfiguringMSSQLServer-Limitations

In addition, the SQL server performances highly depend on your Microsoft license: have you paid for using all available system resources (memory and CPU)?

Jose_Luis_Ferna

Hi Julien, thank you for your comments.

We have SQL Server 2014 Standard edition running over m4.large EC2 instance.

We have done some testing and see that the CPU time on some stored procedures is high. I attached a screenshot with some data.

What versions and equipment requirements recommended for work with Nuxeo + mssql in good condition?

BR,

Captura de pantalla 2015-10-30 a las 8.47.58.png

ben_

Hi, Thanks for these details,

Jose_Luis_Ferna

thank you Ben, I'll try.