topic Re: SQL server performance issues. in Nuxeo Forum

SQL server performance issues.

Jose_Luis_Ferna — Mon, 02 Nov 2015 11:47:13 GMT

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.

Re: SQL server performance issues.

Julien_Carsique — Mon, 02 Nov 2015 15:00:37 GMT

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)?

Re: SQL server performance issues.

Jose_Luis_Ferna — Tue, 03 Nov 2015 16:22:05 GMT

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,

Re: SQL server performance issues.

ben_ — Wed, 04 Nov 2015 15:58:43 GMT

Hi, Thanks for these details,

Re: SQL server performance issues.

Jose_Luis_Ferna — Wed, 04 Nov 2015 16:27:52 GMT

thank you Ben, I'll try.