Jiwa Sales order Performance issues

[pricerc]

at risk of asking a(nother) silly question, what edition (standard, web, enterprise, express, developer) of SQL Server have they installed?

[SBarnes]

SQL 2014 at least Standard might be Enterprise, which was another point that I raised in favour of moving to Azure SQL rather than sticking with technology that is 10 years old.

[pricerc]

Have you tried suggesting that they try Mike's suggestion?

i.e. Within their Azure portal, add a SQL Server and upload their database into it, and then add a connection to Jiwa and see how it compares?

It will only cost them a few Azure dollars, but it could be quite informative.

Of course, you'd still have to make sure you pick the right level of SQL Server.

One of the big benefits of Jiwa having everything "in the database" is that this is easy to do without confusing the whole ERP installation.

[SBarnes]

The first step is going to be the archiving, hopefully in the next day or two, then Mike's diagnostic suggestions, then I will approach the Azure SQL issue again.

Unfortunately, this is having to be done in small increments, the client has lived in an on-premises environment for years so convincing them of "cloud" way of doing things is going to take some time particularly given other technical resources have been advising against Azure SQL and originally, they believed Jiwa couldn't run in Azure SQL until I corrected that error.

Even convincing them that archiving the database, given a copy of what was there now can be taken and kept before it's done has taken some effort and meetings with them.

Unfortunately, as a friend of mine said to me yesterday people don't necessarily understand how things work in the cloud and often don't like stepping outside their comfort zone from a traditional environment mentality.

Put more simply I've learnt not to disagree with Mike when he is right.