Hello!
We have a Nav 2015 installed in an Microsoft Azure environment. One applicationserver and one sql server.
Appserver is a 4 core with 28 gigs of ram, and the sqlserver is a 2 core with 14 gigs of ram.
I'm using webservices to connect Jet express to NAV and when trying to update a regular sized report i can take 30+ minutes and almost always ends up with a timeout.
While monitoring the appserver I can see that the Jetexpress webservice calls utilizes 1 core for 100% for the whole period of time.
The sql server idles at 3-5% load.
If I connect with RDP to the appserver and then run the report direct towards the sql database, instead of web services, the same report takes about 3-4 minutes.
These times are when noone else are utilizing the servers at all.
I made a replica of that azure environment within my VMWare workstation on my laptop, connecting to that one with the same report took 3 minutes to update.
Does anyone have any experience with performance issues in Azure like the ones mentioned above?
Best Regards
Christian
Date
Votes
3 comments
-
Jet Reports Historic Posts Hello Christian,
I would suggest reviewing the following knowledgebase articles for potential answers.
Essentials Performance with NAV 2013-2015 & Web Services: http://kb.jetreports.com/article/AA-00808
Table Cache Optimization: http://kb.jetreports.com/article/AA-00938
Both of these articles reference Jet Essentials but the same solutions apply to Jet Express.
Best regards,
MWilson -
Jet Reports Historic Posts Hello!
Thank you for you relpy!
I will look into those KB-articles and see if I can sort something out
BR
CHristian -
Jet Reports Historic Posts Hello Christian,
I would suggest reviewing the following knowledgebase articles for potential answers.
Essentials Performance with NAV 2013-2015 & Web Services: http://kb.jetreports.com/article/AA-00808
Table Cache Optimization: http://kb.jetreports.com/article/AA-00938
Both of these articles reference Jet Essentials but the same solutions apply to Jet Express.
Best regards,
MWilson
Yeah, I've been trying to optimize the table cache and it helps a bit but reports still take ages to load.
Please sign in to leave a comment.